02/07/2020 12:21:23 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-017' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'
02/07/2020 12:21:32 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-018' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'
02/07/2020 12:21:35 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-017' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'
02/07/2020 12:22:15 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-017' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'
02/07/2020 12:35:13 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-017' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'
02/07/2020 12:35:34 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-018' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'
02/07/2020 12:35:37 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-018' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'
02/07/2020 12:36:02 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-018' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'
02/07/2020 12: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 = 'Ken@codeworx.ltd.uk' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC
02/07/2020 12:41:26 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
02/07/2020 14:48: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 = 'Ken@codeworx.ltd.uk' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC
02/07/2020 15:42:47 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
02/07/2020 15:43:13 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber