16/07/2023 15:40:18 Returns History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = '' AND t2.status = 'Shipped' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 3 MONTH) ORDER BY orderdate DESC
16/07/2023 15:40:27 Get Order History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno,t2.qty,CONCAT(t2.courier,' - ',t2.consignment) as pod,date_format(t1.orderdate,'%d/%m/%y') as orderdate FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = '' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC
16/07/2023 15:41:11 Returns History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = '' AND t2.status = 'Shipped' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 3 MONTH) ORDER BY orderdate DESC
16/07/2023 15:41:24 Get Order History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno,t2.qty,CONCAT(t2.courier,' - ',t2.consignment) as pod,date_format(t1.orderdate,'%d/%m/%y') as orderdate FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = '' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC
16/07/2023 15:41:30 Returns History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = '' AND t2.status = 'Shipped' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 3 MONTH) ORDER BY orderdate DESC
16/07/2023 15:41:38 Get Order History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno,t2.qty,CONCAT(t2.courier,' - ',t2.consignment) as pod,date_format(t1.orderdate,'%d/%m/%y') as orderdate FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = '' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC
16/07/2023 15:41:56 SQL used: INSERT INTO adidaspos.queries (raisedby, type, details, status, dateopened, asmemail) VALUES ('null','System','','Open','2023/7/16','null')
16/07/2023 15:41:56 ****Error: The parameter 'to' cannot be an empty string.
Parameter name: to****
16/07/2023 15:41:56 SQL used: INSERT INTO adidaspos.queries (raisedby, type, details, status, dateopened, asmemail) VALUES ('null','System','','Open','2023/7/16','null')
16/07/2023 15:42:06 Get Order History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno,t2.qty,CONCAT(t2.courier,' - ',t2.consignment) as pod,date_format(t1.orderdate,'%d/%m/%y') as orderdate FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = '' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC