attachments.sql

SELECT
    i.id,
    i.number,
    att1.datas_fname,
    att1.store_fname
FROM
    account_invoice AS i
JOIN
    ir_attachment AS att1 ON (i.id = att1.res_id AND att1.res_model = 'account.invoice' AND att1.l10n_mx_edi_uuid IS NOT NULL)
LEFT OUTER JOIN
    ir_attachment AS att2 ON (i.id = att2.res_id AND
                              (att1.create_date < att2.create_date OR
                               att1.create_date = att2.create_date AND att1.id < att2.id))
WHERE
    att2.id IS NULL;