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 ('C9 LS489A','A2 J1313016','C4 W 610/3','A2 H10W09','C4 LS287PU','A9 J1315025','A2 J1315025','A1 OC196','C9 H20W07','A1 32100 FE','A3 MHL OC1673','A3 JAP FO-K02S','A2 J1315015','C9 SP-961','B1 PURLS415','C9 SP-873','A1 LS910PU','B7 H10W09','B1 CHACOF102126S','B7 MO-511/KAVO','C4 W 815/80','A1 OC1673','A8 313 537','A3 KAP MO-443','A8 318 852','B7 W610/3/AG','A8 358 665','A8 326 553','C9 LS910','C9 FO-502S','A1 F119','B1 VAL586016','A9 FI OP536','A1 F126','A5 288090','A9 W610/3','C9 SP-919','D1 BP ADC42112','A5 30173','A9 OC1673','B7 OP 536/IP','B1 CHACOF100119S','B1 PURLS287','A1 10-K0-002ASK','C9 SP-911','A5 82995','B1 HENH10W09','A2 W610/3','C4 J1315025','C9 0986452016','A9 J1315015','C4 LS910PU','C9 FE32100','A3 FLT OP536','A9 J1313016','B1 FTROP536','B7 A210021/DKM','B7 1518501009/JP','C4 32100F','A1 W610/3','C9 H97W02','A8 370 346','C9 ADC42112','C4 OC 196','A1 WOF131','A1 0986452008','C9 LS415','A5 202446','B1 KNEOC196','B7 A210159/DKM','A1 10-05-502ASK','A1 COF102126S','B1 MANW610/3','A1 0986452007','A1 LS287PU','A2 OC1673','A5 30171','C4 S 3265 R','A1 0986452016','C4 J1315024','C9 W610/3','B7 A210305/DKM','A9 UFI 23.165.00','B7 A210027/DKM','B7 H20W07','C4 J1313016','A3 KAP MO-511','D1 BP ADM52107','C9 32-143220005','B1 MANW815/80','A8 318 255','A3 BOS 0986452016','A2 OC196','B1 PURLS910','A3 JAP FO-510S','B1 BLPADC42112','A9 0986452016','A1 LS415PU','A1 10-03-316ASK','A5 372329','B7 MO-448/KAVO','A3 MNN W610/3','A1 LS489APU','B7 MO-443/KAVO','C9 LS287','C9 H10W09','B7 MO-424/KAVO','A8 365 855','B7 10510/JAPKO','C9 W815/80','B1 BLPADM52107','C4 J1315015','A2 UFI 23.165.00','C9 32-143220006','C4 O0537DREIS','C9 ADM52107','A5 23607','C9 71760123','B1 BOS0986452016','A3 MHL OC196','A2 W815/80','A2 J1315024','A5 385474','C9 SP-819','A1 0986AF1038','A5 174793','A3 JAP FO-502S','A3 KAP MO-433','E6 FL1045','C9 50013109','A1 01-00-008ASK','A8 302 460','C4 LS489APU','A3 MNN W815/80','A1 0986AF1034','A1 10-05-510ASK','A2 FI OP536','C9 DO328','C9 FO-510S','B1 MISZ165','A2 UFI 23.265.00','B1 FEB32100','A9 UFI 23.265.00','B1 KNEOC1673','E6 FL1157','A3 KAP MO-432','A2 0986452016','B7 MO-432/KAVO','A1 W815/80','A8 365 906','C9 FO-K02S','B1 PURLS489A','A9 OC196','A1 0986452036','A1 F026407025','A1 H97W05','A1 LS225PU','A1 LS892PU','A1 W610/6','A1 W67/1','A1 WOF189','A1 WOF197','A1 WOF380','A2 0986452036','A2 F026407025','A2 FI OP575','A2 FI OP595','A2 H97W05','A2 J1311026','A2 SF OF0054','A2 SF OF0066','A2 W610/6','A2 W67/1','A3 FLT OP575','A3 FLT OP595','A3 JAP FO-316S','A5 174791','A5 174794','A5 202448','A5 30172','A5 40935','A5 496739','A5 75071','A8 300 080','A8 313 523','A8 318 339','A8 318 352','A8 349 237','A8 914 400','A9 0986452036','A9 F026407025','A9 J1311026','A9 SF OF0054','A9 SF OF0066','A9 W610/6','A9 W67/1','B1 BLPADH22114','B1 BOS0986452036','B1 BOSF026407025','B1 FTROP575','B1 FTROP595','B1 KAMF113501','B1 MANW610/6','B1 MANW67/1','B1 PURLS225','B1 PURLS892','B1 VAL586013','B1 VAL586022','B7 H97W05','B7 OP595/AG','B7 SM104','B7 SM134','B7 W67/1/AG','C4 0986452036','C4 F026407025','C4 H97W05','C4 J1311026','C4 O0539DREIS','C4 W 610/6','C4 W 67/1','C9 0986452036','C9 ADH22114','C9 F026407025','C9 FO-316S','C9 OF-0410','C9 OF-1094','C9 OF-919','C9 W610/6','C9 W67/1','D1 BP ADH22114','E6 FL1151')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #