Advand | Autóalkatrész webáruház és autóápolás

#SELECT cikk_raktar.cikkszam, cikk_tecdoc.gyarto, cikk_tecdoc.keresoAZ, cikk_tecdoc.DLNr FROM cikk_tecdoc LEFT JOIN cikk_raktar on (cikk_raktar.eredeti=cikk_tecdoc.cikkszam) WHERE ((cikk_tecdoc.cikkszam IN ('A2 H11W02','A1 WOF155','B1 BOS0451103336','A2 UFI 23.177.00','A9 UFI 23.177.00','A8 323 933','C4 152085488ROE','C4 32398F','C9 DO817','A8 307 641','A2 UFI 23.481.00','B1 KNEOC727','A1 W7032','B1 HENH11W02','A8 392 939','C9 ADN12133','C9 W79','A2 FI OP643/5','A8 365 672','A8 378 606','A8 370 509','C9 LS926','A1 WOF272','B1 MANW79','C9 ADN12121','A1 27155 FE','B1 BLPADC42115','A8 919 259','D2 8200768927','B1 PURLS946','A5 40945','B7 W79/AG','B7 H11W02','C4 W 79','C4 H14W42','A5 80590','C4 152089599R','A8 916 108','A1 0451103293','A1 W75/3','C9 FE27155','A1 W79','A1 H221W','E6 FL1192','A1 0451103233','A1 LS223PU','C9 LS223','C9 0451103293','B1 KNEOC309','C9 ADC42115','C9 H221W','A8 365 862','A8 369 323','C4 OC 471','C9 H11W02','B7 10122/JAPKO','A9 UFI 23.481.00','B7 SM158','A5 202467','C4 H11W02','C4 O0640DREIS','C4 N1311044','D1 BP ADN12133','A8 365 980','B7 MO-441/KAVO','C9 W75/3','C9 LS946','A5 358869','A2 UFI 23.419.00','B1 PURLS933','C4 S 3820 R','A3 MNN W7032','B7 OP643/5/AG','A1 LS933PU','C4 LS933PU','B1 KAMF106201','B1 FEB109603','A1 32398 FE','A9 W79','A3 MNN W75/3','B1 HENH14W42','C9 FE109603','B1 KNEOC467','A8 365 769','C4 27155F','A2 FI OP643/4','B1 FEB27155','A2 W75/3','B7 OP643/4/AG','B1 BLPADN12133','A9 J1315020','B1 FTROP643/5','A9 N1311041','A5 202468','B1 FEB32398','A3 MNN W79','B1 KNEOC978','B7 OP 643/4/IP','A2 N1311041','B7 H14W42','A1 10-01-122ASK','D1 BP ADC42115','C9 0451103336','C9 LS917','C9 H12W02','A1 J1315020HB','A2 J1315020','A3 BOS 0451103336','C4 152089599ROE','A9 0451103336','A1 LS926PU','B1 MANW75/3','A2 W7032','A2 UFI 23.418.00','C9 SP-1321','A2 W79','C9 LS933','C4 W 7032','B7 H221WK','A1 J1311035HB','A1 LS946PU','A3 KAP MO-441','B7 W7032/AG','B1 BLPADN12121','C4 O0552DREIS','C9 FE32398','A3 FLT OP643/4','C9 SP-1039','A1 OC471','C4 J1315020','A2 OC471','A8 312 858','B1 KNEOC471','A9 FI OP643/4','B7 OP 643/5/IP','A1 0451103336','C4 0451103336','A5 140857','A8 343 569','B7 W75/3/AG','C4 N1311041','C9 152089599R','C9 LS309','B1 HENH221W','A1 OC309','A9 UFI 23.418.00','C9 ADL142116','A9 FI OP643/5','C9 W7032','A3 FLT OP643/5','A9 W75/3','A8 340 115','C4 W 75/3','A1 OC 309','A9 W7032','A9 UFI 23.419.00','B1 PURLS223','B1 FTROP643/4','B1 MANW7032','B7 H221W','A1 WOF1405','B1 BLPADL142116','B7 SM142/1','C4 H221W','A9 H11W02','C4 S 3418 R','C4 O0636DREIS','D1 BP ADN12121','A1 LS917PU','A2 0451103336','A1 F026407022','A1 WOF1905','A2 F026407022','A2 SF OF0961','A3 BOS F026407022','A5 51852','A8 314 351','A9 F026407022','A9 SF OF0961','B1 BOSF026407022','B1 FEB108865','B1 KAMF100301','B1 KAMF117101','B1 VAL586003','B7 A210582/DKM','C4 F026407022','C9 16-143220005','C9 16-143220011','C9 F026407022','C9 FE108865','C9 OF-1321')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #