Re: More records after sort

Query:
INSERT INTO invl_aml_mapping_temp(invl_id, aml_id, cond)
               SELECT il.id, ml.id, 48
                   FROM account_invoice_line il
                   JOIN account_invoice i ON i.id = il.invoice_id
                   JOIN account_move m ON m.id = i.move_id
                   JOIN account_move_line ml ON ml.move_id = m.id
                   JOIN res_company comp ON comp.id = i.company_id
               WHERE il.display_type IS NULL
                 AND ml.tax_line_id IS NULL
                 AND NOT EXISTS (SELECT invl_id FROM invl_aml_mapping WHERE invl_id=il.id)
                 AND NOT EXISTS (SELECT aml_id FROM invl_aml_mapping WHERE aml_id=ml.id)
                 AND i.id =