SELECT ra.id, ra.stid, ent.paid, gs.date, gs.time, ent.invoice_number, ent.purchase_order, inv.id AS invId, po.id AS poid, gs.master_receiver as receiver, gs.master_receiver_company as receiverId, gs.master_sender_company as senderId, gs.master_sender as sender, gs.group_ctrl_number as control FROM edi_820 AS ra INNER JOIN gs_header AS gs ON ra.gs=gs.id INNER JOIN edi_820_entity AS ent ON ra.id=ent.master_820 INNER JOIN edi_810 AS inv ON ent.invoice_number=inv.invoice_number INNER JOIN edi_850 AS po ON ent.purchase_order=po.po_number WHERE (ra.master_receiver_company=1219 OR ra.master_sender_company=1219 ) AND (gs.date BETWEEN '2006-07-01 00:00:00' AND '2006-09-06 23:59:59' )AND (inv.master_sender_company=1219 OR inv.master_receiver_company=1219 ) AND (po.master_sender_company=1219 OR po.master_receiver_company=1219 ) ORDER BY gs.date DESC, gs.time DESC, gs.master_sender ASC;