03/12/2020 08:43:14 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
03/12/2020 08:43:16 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
03/12/2020 10:32:34 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0118','DOWNFIELD GOLF CLUB,TURNBERRY AVENUE,DUNDEE,DD2 3QP','Ken Blowing','2020/12/3','Open','2070081658','BARRY SMITH GOLF PRO LTD','Ken@codeworx.ltd.uk')
03/12/2020 10:32:34 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0118','ADI-014','2','Pending','N')
03/12/2020 10:34:00 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0119','SCOTSCRAIG GOLF CLUB,GOLF ROAD,TAYPORT,DD6 9DZ','Ken Blowing','2020/12/3','Open','2070083313','CRAIG MACKIE','Ken@codeworx.ltd.uk')
03/12/2020 10:34:01 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0119','ADI-008','4','Pending','N')
03/12/2020 10:34:29 SQL used: INSERT INTO adidaspos.queries (raisedby, type, details, status, dateopened, asmemail) VALUES ('Ken Blowing','Part','Part Query for ADI-013: Test query ','Open','2020/12/3','Ken@codeworx.ltd.uk')
03/12/2020 10:44:05 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0120','THE PROFESSIONAL SHOP,72 AYR ROAD, GIFFNOCK,NEWTON MEARNS,WHITECRAIGS GOLF CLUB,GLASGOW,G46 6SW','Ken Blowing','2020/12/3','Open','2070080126','DAVID ORR GOLF','Ken@codeworx.ltd.uk')
03/12/2020 10:44:05 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0120','ADI-015','1','Pending','N')
03/12/2020 10:45:18 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0121','GOUROCK GOLF CLUB,C/O GOUROCK GOLF CLUB, COWAL VIEW,GOUROCK, RENFREWSHIRE,PA19 1HD','Ken Blowing','2020/12/3','Open','2070082331','DEREK WATTERS PGA PROFESSIONAL','Ken@codeworx.ltd.uk')
03/12/2020 10:45:18 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0121','ADI-008','2','Pending','N')
03/12/2020 14:35:50 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0122','CAWDER GOLF CLUB,CADDER ROAD,BISHOPBRIGGS,G64 3QD','Ken Blowing','2020/12/3','Open','2070083092','GORDON STEWART','Ken@codeworx.ltd.uk')
03/12/2020 14:35:50 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0122','ADI-014','2','Pending','N')
03/12/2020 14:38:03 SQL used: UPDATE adidaspos.orderitems SET status = 'Returned' WHERE orderno = 'KB0120' AND partno = 'ADI-015'
03/12/2020 14:38:54 SQL used: INSERT INTO adidaspos.queries (raisedby, type, details, status, dateopened, asmemail) VALUES ('Ken Blowing','Part','Part Query for ADI-008: Do we have this in green?','Open','2020/12/3','Ken@codeworx.ltd.uk')