SELECT load_info.load_id, load_info.usr_id, load_info.load_no, load_info.driver_typ, load_info.created_date, load_info.wo_no, load_info.cost, load_info.cost_currency_iso3, load_info.amount, load_info.currency_iso3, load_info.notes As load_notes, load_info.load_csa, load_info.load_fast, load_info.load_pips, load_info.load_status, load_info.charges_rate, load_info.attachment_key, load_info.manifest, load_info.custmr_id AS CustomerID, custmr_profile.custmr_name, custmr_profile.account AS CustomerAccount, custmr_profile.custmr_email, custmr_profile.custmr_pri_phon, custmr_profile.custmr_alt_phon, load_status.status_desc, load_status.status_color, load_status.status_soft_color, load_status.status_bullet, shippertable.pickup_date, shippertable.pickup_loc, consigneetable.dropoff_date, consigneetable.dropoff_loc FROM ((((load_info LEFT JOIN custmr_profile ON load_info.custmr_id = custmr_profile.custmr_id) INNER JOIN load_status ON load_info.load_status = load_status.status_id) LEFT JOIN (SELECT load_shipper.load_id, load_shipper.pickup_date, load_shipper.pickup_loc FROM load_shipper WHERE load_shipper.pickup_date BETWEEN '2000-01-01 00:00:00' AND '2030-12-31 23:59:59' AND load_shipper.archive = 0 GROUP BY load_shipper.load_id) AS shippertable ON load_info.load_id = shippertable.load_id) LEFT JOIN (SELECT load_consignee.load_id, load_consignee.dropoff_date, load_consignee.dropoff_loc FROM load_consignee WHERE load_consignee.dropoff_date BETWEEN '2000-01-01 00:00:00' AND '2030-12-31 23:59:59' AND load_consignee.archive = 0 GROUP BY load_consignee.load_id) AS consigneetable ON load_info.load_id = consigneetable.load_id) WHERE load_info.account = '' AND ((load_info.load_status < 10 AND load_info.load_status != 3) OR load_info.load_status > 12) AND load_no LIKE '%%' AND (shippertable.pickup_date IS NOT NULL OR consigneetable.dropoff_date IS NOT NULL) GROUP BY load_info.load_id ORDER BY load_info.load_no DESC