Untitled
unknown
plain_text
4 months ago
4.7 kB
4
Indexable
SELECT ApprovedOrders.order_id AS `ApprovedOrders__order_id`, ApprovedOrders.order_user_id AS `ApprovedOrders__order_user_id`, ApprovedOrders.order_storage_id AS `ApprovedOrders__order_storage_id`, ApprovedOrders.order_number AS `ApprovedOrders__order_number`, ApprovedOrders.order_con_note_number AS `ApprovedOrders__order_con_note_number`, ApprovedOrders.order_store_id AS `ApprovedOrders__order_store_id`, ApprovedOrders.order_is_store_address AS `ApprovedOrders__order_is_store_address`, ApprovedOrders.order_created_date AS `ApprovedOrders__order_created_date`, ApprovedOrders.order_delivery_date AS `ApprovedOrders__order_delivery_date`, ApprovedOrders.order_dispatch_date AS `ApprovedOrders__order_dispatch_date`, ApprovedOrders.order_estimated_dispatch_date AS `ApprovedOrders__order_estimated_dispatch_date`, ApprovedOrders.order_requested_dispatch_date AS `ApprovedOrders__order_requested_dispatch_date`, ApprovedOrders.order_postcode AS `ApprovedOrders__order_postcode`, ApprovedOrders.order_status AS `ApprovedOrders__order_status`, ApprovedOrders.order_estimated_delivery_date AS `ApprovedOrders__order_estimated_delivery_date`, ApprovedOrders.order_approved_date AS `ApprovedOrders__order_approved_date`, ApprovedOrders.order_priority AS `ApprovedOrders__order_priority`, ApprovedOrders.order_connote_url AS `ApprovedOrders__order_connote_url`, ApprovedOrders.order_carrier_type AS `ApprovedOrders__order_carrier_type`, ApprovedOrders.order_actual_dispatch_date AS `ApprovedOrders__order_actual_dispatch_date`, Suburb.suburb_name AS `Suburb__suburb_name`, State.state_name AS `State__state_name`, StorageLocation.sl_storage_type AS `StorageLocation__sl_storage_type`, StorageLocation.sl_id AS `StorageLocation__sl_id`, StorageLocation.sl_name AS `StorageLocation__sl_name`, StorageLocation.sl_company_name AS `StorageLocation__sl_company_name`, Store.store_id AS `Store__store_id`, Store.store_name AS `Store__store_name`, DestinationStore.store_id AS `DestinationStore__store_id`, DestinationStore.store_name AS `DestinationStore__store_name`, Carrier.ca_name AS `Carrier__ca_name`, Users.user_fname AS `Users__user_fname`, Users.user_lname AS `Users__user_lname`, Users.user_id AS `Users__user_id`, Carrier.ca_website AS `Carrier__ca_website`, Company.cmp_name AS `order_company_name`, ApprovedOrders.order_bulk_order_id AS `ApprovedOrders__order_bulk_order_id`, BulkOrders.bulk_order_number AS `bulk_order_number`, BulkOrders.bulk_order_name AS `bulk_order_name`, BulkOrders.bulk_order_code AS `bulk_order_code`, ApprovedOrders.order_approval_array AS `ApprovedOrders__order_approval_array`, ApprovedOrders.order_delivered_date AS `ApprovedOrders__order_delivered_date`, COUNT(DISTINCT OrderCommunication.oc_id) AS `OrderCommunicationCount`, ApprovedOrders.order_mobile AS `ApprovedOrders__order_mobile`, concat(ApprovedOrders.order_store_address_1," ",ApprovedOrders.order_store_address_2) AS `destination_address`, Store.store_type AS `store_type`, ApprovedOrders.pod_file AS `pod_file`, group_concat(distinct(Brand.brand_name) separator ' ') AS `brand`, group_concat(distinct(Brand.brand_name) separator '\n') AS `brand_csv` FROM fp_order ApprovedOrders LEFT JOIN fp_users Users ON Users.user_id = ApprovedOrders.order_user_id INNER JOIN fp_order_items OrderItems ON OrderItems.oi_order_id = ApprovedOrders.order_id LEFT JOIN fp_storage_location StorageLocation ON StorageLocation.sl_id = ApprovedOrders.order_storage_id LEFT JOIN fp_carrier Carrier ON Carrier.ca_id = ApprovedOrders.order_carrier_id LEFT JOIN fp_states State ON State.id = ApprovedOrders.order_state_id LEFT JOIN fp_suburbs Suburb ON Suburb.suburb_id = ApprovedOrders.order_suburb_id LEFT JOIN fp_store Store ON Store.store_id = ApprovedOrders.order_store_id LEFT JOIN fp_store DestinationStore ON DestinationStore.store_id = ApprovedOrders.order_retailer_store_id LEFT JOIN fp_company Company ON Company.cmp_id = ApprovedOrders.order_cmp_id LEFT JOIN fp_bulk_orders BulkOrders ON BulkOrders.bulk_order_id = ApprovedOrders.order_bulk_order_id LEFT JOIN fp_order_communication OrderCommunication ON OrderCommunication.oc_order_id = ApprovedOrders.order_id LEFT JOIN fp_products Products ON Products.product_id = OrderItems.oi_product_id LEFT JOIN fp_brand Brand ON Brand.brand_id = Products.product_brand_id WHERE (ApprovedOrders.order_number LIKE "%ORD0062705%" AND ApprovedOrders.order_status in (:c0,:c1,:c2,:c3,:c4,:c5,:c6,:c7,:c8,:c9,:c10,:c11,:c12,:c13,:c14) AND ApprovedOrders.order_brand_id = :c15 AND OrderItems.oi_master_product_id IS NULL AND ApprovedOrders.order_status != :c16 AND ApprovedOrders.order_is_store_address = :c17) GROUP BY OrderItems.oi_order_id, Users.user_id ORDER BY ApprovedOrders.order_created_date DESC
Editor is loading...
Leave a Comment