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 ('A9 J1312015','C9 0986452044','A3 JAP FO-394S','A2 0986452044','C4 H90W27','A5 115502','C9 FO-279S','C4 H14W32','C4 27147F','A8 920 551','A1 10-02-215ASK','B1 VAI70-0016','A8 303 046','B1 BLPADM52118','B1 HENH90W27','B7 OP 618/IP','A9 FI OP532/2','B1 VAL586073','E6 FL1203','A3 JAP FO-279S','C9 ADT32108','C9 H90W27','B1 BOS0451103363','C4 O0583DREIS','B1 BLPADT32108','A2 OC1014','A5 136639','A2 UFI 23.413.00','A8 328 205','B7 H14W32','A3 MNN W712/83','C4 J1312021','A2 W712/83','A3 FLT OP532/2','C9 SP-994','B7 H90W30','B1 PURLS359','C9 DO911','A3 VAC V70-0016','A2 J1313021','A1 OC 478','A1 0451103363','A2 OC466','B1 FTROP618','D1 BP ADT32103','D1 BP ADM52118','C9 ADT32114','B7 OP 532/2/IP','A5 174740','A9 0451103363','A8 360 057','A9 OC478','A1 WOF1868','C9 71758791','A2 OC1063','C9 LS357','C9 FO-215S','C9 LS359','A3 MHL OC1014','B1 VAI25-0145','A3 BOS 0986452044','C9 50013919','C9 30-143220011','A5 62149','C4 J1312015','A1 OC1014','A2 UFI 23.253.00','A8 320 522','A2 UFI 23.477.00','A5 500318','A1 0986452044','C9 F026407085','B1 BLPADT32103','C4 S 3413 R','E6 FL1018','B7 OP532/2/AG','A9 0986452044','C9 DO910','B7 OP618/AG','C4 LS357PU','A8 365 937','A8 332 595','A8 920 093','C9 50013820','C9 FE27147','A9 UFI 23.477.00','A8 370 404','A1 J1312015HB','A9 OC988','B1 FTROP532/2','A9 J1313021','A3 MHL OC988','C4 F026407085','E6 FL1042','A5 432463','A1 WOF1862','A9 OC1063','A8 328 206','C4 J1313021','A2 OC478','A8 360 975','A8 365 896','A1 J1313021HB','A2 J1312015','C9 0451103363','A9 UFI 23.413.00','A3 BOS 0451103363','A5 174792','A9 W712/83','A5 250170','A1 OC478','A2 J1312021','A8 312 820','C4 OC 466','B1 PURLS357','B1 HENH319W','A9 FI OP618','C4 S 3253 R','A3 FLT OP618','A5 337785','C4 W 712/83','A3 MHL OC1063','A1 OC466','D1 BP ADT32114','A5 43729','A3 VAC V25-0145','B1 BOS0986452044','B1 FEB27147','C9 FO-394S','C9 ADT32103','B7 SM143','A9 UFI 23.253.00','B1 MANW712/83','C4 0451103363','C9 SP-1296','D1 BP ADT32108','C4 0986452044','A2 0451103363','A1 W712/83','B1 HENH14W32','B1 BLPADT32114','A2 FI OP532/2','A3 MHL OC478','A2 OC988','A1 OC235','A9 J1312021','A1 LS359PU','A1 J1312011HB','A1 OC244','A1 F026407085','B7 H90W27','A5 246884','A1 LS357PU','B1 VAL586083','A1 OC988','A5 206442','C4 OC 1063','C9 DO339','A8 333 082','A3 JAP FO-215S','C9 H14W32','C9 ADM52118','A1 27147 FE','A2 F026407085','A1 10-02-279ASK','A1 OC1063','A9 OC1014','A1 0986452002','C4 OC 988','A1 WOF259','B1 BOSF026407085','A2 FI OP618','A8 918 310','C9 W712/83','C4 H319W','A9 F026407085','B7 W712/83/AG','A1 W68/3','A1 W7015','A2 ADM52123','A2 W68/3','A2 W7015','A5 202449','A5 202450','A8 300 023','A8 365 575','A8 378 012','A9 W68/3','A9 W7015','B1 BLPADF122105','B1 BLPADJ132113','B1 BLPADM52111','B1 BLPADM52123','B1 FEB108977','B1 FEB109220','B1 KAMF119001','B1 KNEOC1063','B1 MANW68/3','B1 MANW7015','B7 A210414/DKM','B7 MO-534/KAVO','B7 SM196','B7 W7015/AG','C4 O0547DREIS','C4 O0550DREIS','C4 W 68/3','C4 W 7015','C9 ADJ132113','C9 ADM52123','C9 FE109139','C9 OF-223','C9 W68/3','C9 W7015','D1 BP ADM52111','D1 BP ADM52123','E6 FL1209')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #