03/08/2021 14:23:53 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 = 'Mirte.dejager@adidas.com' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC
03/08/2021 14:29:56 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = '4400700203'
03/08/2021 14:38:27 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('MD0185','GOLF TROLLEY SPECIALIST,TORENLAAN 42,HENGELO,7559 PJ','Mirte de Jager','2021/8/3','Open','4200700216','Golf Trolley Specialist','Mirte.dejager@adidas.com')
03/08/2021 14:38:27 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0185','ADI-010','1','Pending','N')
03/08/2021 14:38:27 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0185','ADI-012','1','Pending','N')
03/08/2021 14:38:27 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0185','ADI-014','1','Pending','N')
03/08/2021 14:38:46 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 = 'Mirte.dejager@adidas.com' AND t2.status = 'Shipped' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 3 MONTH) ORDER BY orderdate DESC
03/08/2021 14:41:26 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = '4200700427'
03/08/2021 14:51:05 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('MD0186','Het Hoge Land 2,Velsen-Zuid,1981 LT','Mirte de Jager','2021/8/3','Open','4200700065','Exploitatie Golfbaan Spaarnwoude','Mirte.dejager@adidas.com')
03/08/2021 14:51:05 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0186','ADI-012','1','Pending','N')
03/08/2021 14:51:05 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0186','ADI-006','2','Pending','N')
03/08/2021 14:51:05 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0186','ADI-007','1','Pending','N')
03/08/2021 14:52:02 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('MD0187','Het Hoge Land 2,Velsen-Zuid,1981 LT','Mirte de Jager','2021/8/3','Open','4200700065','Exploitatie Golfbaan Spaarnwoude','Mirte.dejager@adidas.com')
03/08/2021 14:52:02 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0187','ADI-011','1','Pending','N')
03/08/2021 14:55:07 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('MD0188','Zwart Moerken 12, 
4891 TK Rijsbergen
','Mirte de Jager','2021/8/3','Open','4200700427','DERKSEN GOLF SERVICES','Mirte.dejager@adidas.com')
03/08/2021 14:55:07 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0188','ADI-012','1','Pending','N')
03/08/2021 14:57:11 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('MD0189','Zwart Moerken 12, 
4891 TK Rijsbergen
','Mirte de Jager','2021/8/3','Open','4200700427','DERKSEN GOLF SERVICES','Mirte.dejager@adidas.com')
03/08/2021 14:57:11 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0189','ADI-011','1','Pending','N')
03/08/2021 14:57:11 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0189','ADI-006','1','Pending','N')
03/08/2021 14:57:11 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0189','ADI-007','1','Pending','N')
03/08/2021 15:01:07 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('MD0190','Haarlebeek 3, 2275 Lille, 
België
','Mirte de Jager','2021/8/3','Open','4400700203','Lilse Golf & Country BV','Mirte.dejager@adidas.com')
03/08/2021 15:01:07 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0190','ADI-004','1','Pending','N')
03/08/2021 15:01:07 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0190','ADI-024(GB)','1','Pending','N')
03/08/2021 15:01:07 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0190','ADI-021','1','Pending','N')
03/08/2021 15:01:08 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0190','ADI-027','10','Pending','N')
03/08/2021 15:01:08 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0190','ADI-025','1','Pending','N')