09/06/2022 12:47:01 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
09/06/2022 14:50:23 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 = 'Ken@codeworx.ltd.uk' AND t2.status = 'Shipped' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 3 MONTH) ORDER BY orderdate DESC
09/06/2022 14:50:31 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 = 'Ken@codeworx.ltd.uk' AND t2.status = 'Shipped' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 3 MONTH) ORDER BY orderdate DESC