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 ('C4 W 7008 SD','A9 W719/27','A3 KAP TO-138','B1 CHACOF100148S','A9 OC606','A1 0451103259','A9 SF OF0033','A1 W719/36','A3 KAP MO-538','B1 BOS0451103363','C9 50013097','A9 OC479','B7 SM137','C9 H14W27','C9 71758761','C4 0451103259','A3 BOS 0451103363','B7 OP526/1/AG','A3 FLT OP532/1','A5 287926','A2 OC460','A2 W719/36','A1 W719/27','A1 OC266','B1 PURLS907','D1 BP ADM52117','B1 MANW719/27','A2 OC479','B7 H14W38','A3 MHL OC479','B1 HENH14W36','C9 H14W36','A2 586030','C9 LS907','C4 O0549DREIS','A3 MHL OC606','B1 KAMF126101','A3 BOS 0451103259','C4 COF100148S','A3 MNN W7008','B7 MO-538/KAVO','B7 TO-138/KAVO','B1 FTROP532/1','B1 KAMF101101','C4 H14W27','B1 VAI25-0058','B1 BOS0451103304','C9 7143220015','B1 FTROP526/1','A3 VAC V25-0058','C9 0451103259','A8 348 232','A9 UFI 23.440.00','B1 BLPADM52117','C9 ADM52117','A2 W7008','A5 208497','A9 FI OP526/1','A1 W7008','C9 OF-1084','A9 0451103363','A1 0451103363','C9 H14W38','A9 SF OF0036','B1 VAL586097','B1 KNEOC479','A1 C148','A2 0451103074','A1 J1313020HB','B1 HENH14W23','A1 WOF123','B7 H14W36','A2 SF OF0036','C9 0451103074','A9 UFI 23.473.00','A2 0451103363','A1 OC479','B7 H14W23','A3 FLT OP526/1','A3 BOS 0451103304','A2 FI OP526/1','A3 VAC V10-0325','B7 W719/27/AG','B7 A210014/DKM','A3 MHL OC460','A9 W719/36','C9 W719/27','A9 N1313034','A2 N1313034','C9 OF-1244','A9 0451103259','C9 H14W23','A2 UFI 23.440.00','B7 SM179','C4 S 3473 R','A3 MNN W719/36','A8 393 166','A5 44219','B7 1518500500/JP','C4 N1313034','B7 OP 526/1/IP','A8 313 510','C9 W719/36','A1 LS907PU','B1 MANW7008','A2 FI OP532/1','A9 W7008','C9 W7008','B7 10913/JAPKO','B1 HENH14W27','B1 BOS0451103259','A1 OC606','B7 OP532/1/AG','A2 0451103259','A8 365 951','C4 W 719/27','C9 7143220002','A3 BOS 0451103074','B7 A210102/DKM','A2 SF OF0033','B1 MANW719/36','A2 SF OF0039','B1 VAL586030','A2 H14W23','C4 H14W38','C4 OC 460','C4 W 7008','A2 UFI 23.473.00','A3 JAP FO-913S','A8 316 261','C9 300092756','A1 0451103074','C4 S 0320 R','B1 KNEOC460','C4 0451103074','B7 OP 532/1/IP','C4 H14W23','A5 24734','A1 WOF112','C4 OC 606','A9 OC460','B1 HENH14W38','A8 319 339','C4 LS907PU','A1 OC460','A8 318 324','A3 MNN W719/27','C9 0451103304','C9 FO-913S','A1 10-09-913ASK','B7 H14W27','A8 370 407','C9 DO893','A8 338 885','A8 305 553','B1 VAI10-0325','A8 332 595','C9 SP-1244','B1 CHACOF102106S','A9 FI OP532/1','A9 SF OF0039','A8 370 400','A5 337787','C4 0451103363','A1 0451103304','C9 DO1802','C4 W 719/36','A1 WOF259','B1 BOS0451103074','A1 E106','A2 OC606','A2 W719/27','C9 0451103363','C4 O0615DREIS','B1 KAMF124001','A1 OC1051','A1 W712/43','A1 WOF147','A2 OC1051','A2 W712/43','A3 MHL OC1051','A5 206430','A8 305 890','A9 OC1051','A9 W712/43','B1 KNEOC1051','B1 MANW712/43','C4 O0572DREIS','C4 OC 1051','C4 W 712/43','C9 W712/43')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #