08/12/2020 09:22:30 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0123','DOWNFIELD GOLF CLUB,TURNBERRY AVENUE,DUNDEE,DD2 3QP','Ken Blowing','2020/12/8','Open','2070081658','BARRY SMITH GOLF PRO LTD','Ken@codeworx.ltd.uk')
08/12/2020 09:22:30 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0123','ADI-014','2','Pending','N')
08/12/2020 09:22:30 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0123','ADI-015','2','Pending','N')
08/12/2020 10:55:22 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0124','DOWNFIELD GOLF CLUB,TURNBERRY AVENUE,DUNDEE,DD2 3QP','Ken Blowing','2020/12/8','Open','2070081658','BARRY SMITH GOLF PRO LTD','Ken@codeworx.ltd.uk')
08/12/2020 10:55:22 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0124','ADI-006','2','Pending','N')
08/12/2020 10:55:22 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0124','ADI-010','1','Pending','N')
08/12/2020 11:05:13 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0125','CAIMIN CONDREN,BRAEHEAD GOLF SHOP,ALLOA,FK10 2NT','Ken Blowing','2020/12/8','Open','2070080363','BRAEHEAD GOLF CLUB','Ken@codeworx.ltd.uk')
08/12/2020 11:05:13 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0125','ADI-012','2','Pending','N')
08/12/2020 11:05:13 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0125','ADI-015','1','Pending','N')
08/12/2020 12:20:21 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
08/12/2020 13:57:25 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 = 'oliver.kennedy@adidas.com' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC
08/12/2020 13:57:27 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 = 'oliver.kennedy@adidas.com' AND t2.status = 'Shipped' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 3 MONTH) ORDER BY orderdate DESC
08/12/2020 14:06:56 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0127','DOWNFIELD GOLF CLUB,TURNBERRY AVENUE,DUNDEE,DD2 3QP','Ken Blowing','2020/12/8','Open','2070081658','BARRY SMITH GOLF PRO LTD','Ken@codeworx.ltd.uk')
08/12/2020 14:06:57 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0127','ADI-015','2','Pending','N')
08/12/2020 14:06:57 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0127','ADI-014','1','Pending','N')