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 ('B7 SM158','A3 FLT OP643/4','A1 LS933PU','B1 KNEOC727','C4 32398F','A8 365 980','C4 0451103336','C9 SP-1321','B7 H14W42','B7 OP643/4/AG','C4 J1315020','A8 312 858','A1 W7032','A1 0451103233','A2 UFI 23.418.00','A8 392 939','C4 H221W','A3 MNN W7032','A2 UFI 23.481.00','A1 WOF155','D1 BP ADN12133','C9 ADL142116','A9 UFI 23.481.00','A1 OC 309','A5 140857','A2 N1311041','C9 LS309','C4 152089599R','B1 KNEOC978','A2 J1315020','C4 W 79','A1 OC471','B1 BLPADL142116','B7 H221WK','A9 FI OP643/4','A1 J1315020HB','A8 307 641','B1 HENH11W02','A8 916 108','B1 PURLS223','C4 OC 471','B7 SM142/1','C4 H11W02','A8 919 259','A1 10-01-122ASK','A2 FI OP643/5','A8 365 862','A9 J1315020','A5 358869','B1 MANW79','B1 BLPADN12121','B7 OP 643/4/IP','A8 365 672','A9 W79','A2 FI OP643/4','A1 LS223PU','A9 0451103336','C9 FE27155','C4 S 3820 R','A9 W7032','B1 HENH14W42','B7 H11W02','C4 27155F','C9 H11W02','C9 ADN12133','C9 LS917','D2 8200768927','C9 0451103336','B1 KNEOC309','B1 BOS0451103336','B1 FTROP643/4','C9 W79','B1 KNEOC471','B1 KNEOC467','A3 MNN W79','C9 LS933','A1 LS926PU','A1 0451103293','A1 W79','A8 323 933','C9 LS223','A2 W79','A1 WOF272','B7 H221W','D1 BP ADN12121','C4 W 75/3','B1 FEB109603','A2 W75/3','B1 HENH221W','A8 378 606','A8 343 569','A1 OC309','C9 ADC42115','A1 0451103336','A8 340 115','A1 LS946PU','A9 N1311041','A1 H221W','C4 152089599ROE','A9 UFI 23.177.00','C4 LS933PU','A2 UFI 23.177.00','C9 DO817','B1 KAMF106201','A2 0451103336','B1 PURLS933','C9 FE109603','A5 40945','C9 LS926','A1 27155 FE','B1 BLPADN12133','B7 W7032/AG','A9 H11W02','C9 H12W02','A9 FI OP643/5','A3 KAP MO-441','C4 W 7032','A1 WOF1405','A3 FLT OP643/5','A9 UFI 23.418.00','B7 W75/3/AG','C9 LS946','A1 J1311035HB','A9 W75/3','A3 BOS 0451103336','B7 OP 643/5/IP','B7 10122/JAPKO','C4 S 3418 R','C4 N1311041','E6 FL1192','C4 O0640DREIS','B1 FEB32398','A1 W75/3','C4 152085488ROE','C9 SP-1039','B7 MO-441/KAVO','B1 PURLS946','B1 MANW7032','C9 H221W','A2 H11W02','A5 202467','A8 369 323','B1 BLPADC42115','C9 FE32398','C9 0451103293','B1 FEB27155','C9 W75/3','B1 MANW75/3','A8 365 769','C4 O0636DREIS','A2 W7032','A2 OC471','A1 LS917PU','B7 W79/AG','D1 BP ADC42115','C9 W7032','A9 UFI 23.419.00','A5 80590','C9 ADN12121','C4 H14W42','A3 MNN W75/3','A8 370 509','A2 UFI 23.419.00','B7 OP643/5/AG','C4 N1311044','B1 FTROP643/5','A1 32398 FE','C9 152089599R','C4 O0552DREIS','A5 202468','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)) #