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 ('A3 JAP FO-891S','C4 S 3418 R','C9 DO1836','A2 F026407022','A1 WOF1905','B1 BOSF026407022','B1 BLPADC42115','B1 KAMF100301','B7 A210009/DKM','B1 BOSF026407124','B1 MANW75/3','C4 LS933PU','A8 315 301','B1 VAL586001','A9 H11W02','A5 80537','B1 PURLS932','A9 FI OP643/3','A9 F026407209','D1 BP ADC42115','A1 10-08-891ASK','A1 H221W','B7 H221W','A9 F026407124','B1 KNEOC467','C4 O0636DREIS','B1 BOSF026407209','A8 307 641','A1 OC 205','C9 16-143220000','A8 314 351','A1 LS218PU','C9 FO-891S','C9 FO-122S','A2 F026407124','B7 10891/JAPKO','A5 174871','B7 OP 643/3/IP','A2 OC727','A2 OC205','B7 A210582/DKM','A2 OC467','A5 66925','B7 H97W06','A3 BOS F026407124','B1 FTROP643/3','A5 410733','A3 BOS F026407209','B7 MO-441/KAVO','C4 F026407022','C9 LS218','A2 UFI 23.418.00','C9 OF-1039','C9 71758726','A9 OC727','A9 W75/3','C4 LS218PU','A5 40945','C9 0451103336','B1 CHACOF100136S','C4 S 3820 R','A1 H97W06','B7 A210125/DKM','A1 OC471','B1 BOS0451103235','A8 370 625','C9 50013504','C4 W 75/3','A1 OC 309','A9 OC205','A5 272918','B7 H11W02','C9 DO905','B7 H221WK','A2 OC471','B1 KNEOC205','D2 8200768913','A1 OC467','A2 H11W02','B7 SM142/1','C4 H97W06','A1 F026407124','B1 VAI46-0083','A9 UFI 23.418.00','C4 LS932PU','A8 318 884','A1 WOF120','B1 VAI46-0084','A3 BOS 0451103336','A2 0451103235','A5 80590','C9 W75/3','C4 F026407209','C9 DO328','C9 SP-1039','A9 SF OF0012','B1 PURLS218','A3 FLT OP643/3','A1 OC727','C4 H11W02','A2 UFI 23.481.00','A2 SF OF0012','A9 SF OF0961','A2 0451103336','A1 WOF104','B1 MISZ194','B7 SM142','A8 312 858','B1 CHACOF103105S','C9 16-143220005','A1 F120','B1 HENH97W06','C9 DO332','C9 F026407022','C9 H11W02','A3 MHL OC467','A3 BOS 0451103235','A2 FI OP643/3','B1 TRU02.18.169','A2 SF OF0961','A3 MNN W75/3','C9 DO1800','A5 86220','A3 BOS F026407022','C9 0451103235','A1 OC205','B7 MO-411/KAVO','A5 27476','A1 LS933PU','C4 OC 471','A1 F026407209','A3 JAP FO-122S','A9 0451103336','D2 86001543357','A2 F026407209','C9 SP-1321','A3 KAP MO-441','A5 24793','C4 OC 467','C9 F026407124','B7 OP643/3/AG','B7 MO-432/KAVO','B1 KAMF105101','C4 S 3424 R','C4 H221W','C9 OF-1321','C4 J1315020','D2 7700274177','C4 OC 205','A3 MHL OC205','A9 F026407022','C9 H221W','A9 UFI 23.481.00','B7 SM118','E2 207 027 756','A8 326 211','C9 LS932','C4 F026407124','B7 W75/3/AG','A8 370 509','C9 DO832','E6 FL1192','A2 J1315020','A8 365 980','B1 KAMF106201','B1 HENH11W02','C4 7700274177OE','A1 WOF462','A8 919 259','A5 51852','C4 N1311044','B1 VAL586003','A1 F026407022','B7 10122/JAPKO','C9 ADC42115','A1 WOF272','B1 HENH221W','C4 OC 727','A1 J1315020HB','C4 0451103336','A3 VAC V46-0084','D2 8671002274','C9 71758768','A8 323 933','A5 202467','A9 J1315020','B1 KAMF104701','A3 VAC V46-0083','C9 LS933','C9 71760808','A3 KAP MO-432','B1 BOS0451103336','B1 KNEOC3','A1 0451103235','A5 80557','A3 MHL OC727','A2 W75/3','A1 LS932PU','D2 F136','B1 KNEOC223','A1 W75/3','A9 OC467','C9 H97W06','B1 PURLS933','A1 OC309','A1 F105','A1 0451103336','A8 365 769','C4 COF100136S','A1 OC223','A1 OC313','A2 OC223','A2 OC313','A3 MHL OC313','A9 OC223','A9 OC313','B1 KNEOC313','C4 OC 313')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #