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 MNN W712/21','C9 H90W05','A9 OC501','A5 200755','C9 LS245','A2 UFI 23.172.00','C4 LI 779/43','A3 FLT OP616/2','B1 BOS0451102056','D1 BP ADV182127','C9 H90W06','B7 H12W05','A1 0451203151','B7 H90W24','A2 H14W13','A9 UFI 23.117.00','A1 OC314','A5 373222','A3 MNN W811/84','C4 O0577DREIS','A8 365 824','A2 OC501','B7 OP616/2/AG','A5 43700','A8 360 057','A1 OC231','A3 BOS 0451103351','A2 UFI 23.477.00','A3 MHL OC314','A1 LS245PU','A1 WOF435','C9 LS194','A1 WOF227','C9 LS922','A2 0451102056','C9 W718','A3 BOS 0451103271','C4 H90W24','A9 W714/3','A1 0451103096','A2 UFI 23.448.00','C9 0451103351','A3 BOS 0451103337','A2 OC58','A1 WOF1847','C9 DO261','E6 FL1018','B1 MANW712/21','A3 MHL OC58','B1 BLPADT32108','A8 370 602','A9 UFI 23.175.00','A8 314 318','C4 0451103337','C4 0451102056','A8 370 614','B1 MANW7015','A2 W718','B1 BLPADG02104','A8 389 804','A2 UFI 23.175.00','A9 UFI 23.435.00','A1 OC501','A9 W712/54','A2 UFI 23.188.00','A2 FI OP616/2','C9 W712/21','C4 OC 981','A2 0451103271','A3 MHL OC136','C9 H12W05','A2 UFI 23.128.00','A3 MHL OC133','B1 PURLS245','A1 OC52','C9 DO238','A2 UFI 23.435.00','A1 W712/54','A1 W7015','A3 MNN W712/54','A1 OC136','A3 MHL OC198','A1 OC58','C4 S 8540 R','A1 WOF149','A1 OC74','A1 0451103011','C9 W811/84','B1 HENH90W24','A9 UFI 23.172.00','C9 DO232','A1 0451103351','A1 10-02-279ASK','A9 OC981','A1 LS188BPU','A9 UFI 23.298.00','C9 W712/54','A1 W714/3','C4 W 712/54','C9 0451103271','A1 0451103271','C9 ADT32108','C9 0451103337','A1 WOF209','A2 OC198','B1 HENH90W02','A8 318 714','A3 MHL OC52','A3 MHL OC55','A1 0451103337','A8 314 355','B1 HENH14W13','C9 H14W10','C4 OC 501','A3 MHL OC981','A9 FI OP616/2','A9 W712/21','A1 H90W02','A9 0451103337','A8 378 012','A8 308 725','B7 W7015/AG','A8 307 715','B1 BLPADV182127','B1 HENH14W10','A9 UFI 23.477.00','A1 OC96','B1 HENH12W05','C9 ADV182127','B1 MISZ127','A1 OC133','C9 ADG02104','B1 BOS0451103271','B7 H90W02','A1 OC198','A3 MHL OC74','B1 BOS0451103351','C9 DO240','A2 0451103351','C4 W 712/54 SD','A9 W718','A2 OC52','C9 DO215','A2 W712/21','A3 MHL OC501','B7 H14W13','C4 S 2327 R','A2 0451103337','A5 202450','C4 W 714/3','A5 372615','C4 LS922PU','C4 OC 314','A3 BOS 0451102056','C4 LS188BPU','C4 H14W13','B1 PURLS188B','A2 W712/54','C9 LS188B','A1 0451103080','C9 H90W02','A2 H90W02','A1 WOF256','C9 W714/3','C4 H90W02','C9 0451102056','A1 0451103052','A2 UFI 23.131.00','C4 0451103351','A8 365 924','A5 372493','A5 169850','A2 W714/3','D1 BP ADT32108','A8 312 830','B7 OP 616/2/IP','C4 O0550DREIS','C4 OC 198','A1 W718','A1 OC55','A8 365 946','A5 50035','A2 OC981','C9 DO217','A8 321 209','A9 W7015','A9 H90W02','A1 HC7','B1 MANW718','C9 F026407256','A9 0451103351','A2 UFI 23.117.00','A9 UFI 23.128.00','A1 OC106','B1 BOS0451103337','C4 W 7015','B1 MANW714/3','C9 W712/38','A9 UFI 23.188.00','C4 W 712/21','A1 0451102056','A1 WOF351','A9 UFI 23.448.00','B1 VAL586086','C9 H14W13','A5 43661','B1 PURLS194','B1 PURLS922','A9 UFI 23.131.00','A2 UFI 23.216.00','A1 OC183','C4 W 811/84','A2 OC314','A2 OC133','A2 OC55','C9 H90W24','A1 C104','A1 W712/21','A1 W712/38','A2 W7015','A1 0451103262','A1 0451103073','A1 W811/84','A1 OC981','A9 0451103271','A9 OC133','C4 451103298','A9 OC198','A3 MNN W718','A1 0451103075','A9 0451102056','A1 J1311021HB','C4 0451103271','A1 LS922PU','A2 UFI 23.298.00','A1 0451203155','C4 H12W05','A1 LS194PU','B1 MANW712/54','A1 J1312015HB','C9 W7015','A3 MNN W714/3','A1 OC82','D2 16510-60B11','A1 0451103110','A1 W713/4','B1 BOSF026407256','B1 FTROP616/2','D1 BP ADG02104','A1 0451103298','A1 38813 FE','A1 C106','A1 J1312011HB','A1 J1313021HB','A1 W68/3','A1 W7035','A1 W712/4','A1 W712/43','A1 W719/4','A2 0451103298','A2 F026407225','A2 FI OP534','A2 FI OP629','A2 SF OF0126','A2 W68/3','A2 W7035','A2 W712/4','A2 W712/43','A2 W719/4','A3 BOS 0451103298','A3 FLT OP534','A3 FLT OP629','A3 FLT OP629T','A3 HEN H90W20','A3 JAP FO-279S','A5 110506','A5 202449','A5 40940','A5 43729','A5 477543','A8 300 023','A8 300 076','A8 305 890','A8 313 810','A8 318 321','A8 338 888','A8 920 093','A9 0451103272','A9 0451103298','A9 F026407225','A9 SF OF0126','A9 W68/3','A9 W7035','A9 W712/4','A9 W712/43','A9 W719/4','B1 BLPADF122105','B1 BLPADJ132113','B1 BLPADM52111','B1 BLPADM52122','B1 BOS0451103272','B1 BOS0451103298','B1 BOSF026407225','B1 CHACOF100106S','B1 FEB108977','B1 FEB109220','B1 FEB38564','B1 FEB38813','B1 FEB39763','B1 FTROP534','B1 FTROP629','B1 HENH14W02','B1 HENH90W19','B1 HENH90W20','B1 KNEOC198','B1 MANW68/3','B1 MANW712/4','B1 MANW712/43','B1 MANW719/4','B1 VAL586023','B1 VAL586073','B7 A210006/DKM','B7 H90W19','B7 SM107','B7 SM110','B7 SM111','C4 0451103272','C4 0451103298','C4 F026407225','C4 H90W19','C4 H90W20','C4 O0547DREIS','C4 O0572DREIS','C4 S 3435 R','C4 W 68/3','C4 W 7035','C4 W 712/4','C4 W 712/43','C4 W 719/4','C9 0451103298','C9 ADJ132113','C9 ADM52122','C9 F026407225','C9 FE109139','C9 FE38564','C9 FE38813','C9 FO-279S','C9 OF-845','C9 OF-994','C9 W68/3','C9 W7035','C9 W712/4','C9 W712/43','C9 W719/4','D1 BP ADM52111','D1 BP ADM52122','D9 16510-60B11','D9 16510-60B11 10db','D9 16510-60B11 50db','E6 FL1209')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #