SELECT cono FROM c_wait_price
WHERE orderdate like '20250429%' AND sts NOT IN ('Order Complete','Order Cancel')
group by cono
order by cono
Array
(
)
http://203.155.18.96/BCWEB_SERVICES/back/CREDIT_JSONOrderData.aspx?orderdate=20250429
DELETE FROM c_wait_price WHERE sts IN ('Order Complete','Order Cancel')-----------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO c_log_order_sync (number_row,date_update,sync_name,visit_date) value ('0','2025-04-29 06:42','sync_wait_price','20250429')