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 ('A2 05P868','C9 VAL598180','C9 0986494516','A1 WBP275','A9 13.04602937.2','A9 13.04602820.2','C4 16422F','A1 GDB1973','A3 TEX 2096110','A3 DLP LP2255','C4 20961.160.1','A2 BP61088','C4 602984','C9 GDB1083','A1 16146 FE','A9 05P868','C9 FDB1083','A1 13.0460-2984.2','C9 0986461769','A9 BP85020','A5 165392','B1 BREP61088','C9 13.0460-2740.2','C4 GDB1973','C4 LP565','A9 23554 172 14','C9 0986424751','A3 FER FDB1083','A2 RH 2263.01','B1 ZIM23554.170.3','C4 602820','A1 FDB1083-PROMO','C4 602819','C4 16639F','A1 573032JC JRD','A1 598463','C4 0986494387','A5 206677','A5 386533','A2 GDB1813','A2 LP2255','B1 FEB16639','A1 0986494514','A1 LP2255','A1 598180','A9 GDB1973','A2 0986461769','C9 19-0428','B1 ATE13.0460-2842','A1 FDB4260','A9 0986494387','A1 13.0460-2819.2','A1 0986424751','A1 FDB4183','A1 16488 FE','A1 GDB1196','C4 23554.170.3','B1 BREP85020','A1 WBP272','C4 LP2254','A5 270841','A1 P61088','A2 13.04602819.2','B1 ATE13.0460-2984','B1 BOS0986494516','A2 BP85020','C4 KRO1330','C4 0986424751','C9 13.0460-2860.2','A9 13.04602819.2','A2 0986424751','B1 ZIM20961.160.1','B1 LUCGDB1813','B1 LUCGDB1973','A9 FE FDB1083','B1 FEB16488','A9 FE FDB4260','B1 FEB16457','A2 GDB1330','A9 BP23044','A2 23554 172 14','C9 PP-0018AF','A1 16527 FE','A9 13.04602984.2','B1 FEB16422','A3 TEX 2355406','C4 FDB4183','A2 13.04602984.2','A2 BP68024','C9 GDB1504','A1 GDB1813','B1 BOS0986461769','A2 FE FDB1083','C4 0986461769','A1 WBP1182','A9 T 2355406','B1 ATE13.0460-2937','C4 GDB1504','C4 FDB4260','A1 LP2254','A3 BOS 0986461769','A3 BOS 0986494514','C4 LP2255','C9 GDB1973','A9 0986461769','A3 BOS 0986494516','A8 219 787','A5 77648','B1 BOS0986494514','B1 VAL301474','A2 BP23044','A1 13.0460-2823.2','C4 FDB1083W','A5 17709','A8 230 114','A1 GDB1330','B1 BOS0986424751','A5 138171','A2 0986494387','C4 602823','A3 ROA 226305','C4 GDB1813','C9 23554-16,2','A1 13.0460-2820.2','C9 VAL598463','C4 16488F','A9 GDB1330','A1 13.0460-2860.2','D2 8671016188','A1 P68024','C4 602740','B1 ATE13.0460-2819','C9 VAL598474','B7 0263.74/REM','C9 13.0460-2819.2','A3 DLP LP2254','A9 GDB1813','B1 FEB16146','C9 GDB1330','A2 13.04602740.2','B1 ATE13.0460-2860','B7 20961.160.1','A2 LP2254','A1 0986461769','A9 13.04602860.2','A1 0986494516','C9 2355406','A1 16639 FE','C9 13.0460-2937.2','A1 13.0460-2740.2','A1 2355406 TEX','A5 42596','B1 LUCGDB1504','A9 GDB1504','A3 BOS 0986424751','A2 FE FDB4183','A8 241 413','C9 23554-17,2','A2 13.04602860.2','A2 13.04602842.2','B1 BREP68024','B1 LUCGDB1330','A2 FE FDB4260','C9 2355402','C9 VAL301474','A1 0986494387','C9 13.0460-2820.2','A8 217 810','A2 13.04602823.2','A3 BOS 0986494387','A1 598474','A2 T 2355406','A9 FE FDB4183','C9 0986494387','A1 GDB1504','A5 77328','A2 13.04602820.2','A1 P23044','A1 GDB1372','A2 GDB1504','A8 258 535','A3 TEX 2355402','A1 GDB1439','A1 16457 FE','C9 20961-17,4 1 4','C4 FDB1083','A9 BP68024','A9 0986424751','B1 BREP23044','A1 13.0460-2937.2','A8 220 133','B1 ATE13.0460-2820','A8 222 055','A2 RH 2263.05','C4 GDB1330','C9 13.0460-2823.2','A1 P85020','A1 2355402 TEX','A1 13.0460-2842.2','A9 13.04602740.2','A2 GDB1973','C4 05P868','B1 LUCGDB1083','C9 GDB1813','A8 254 312','B1 ATE13.0460-2823','A1 16422 FE','C4 2355406TX','A1 GDB1083','C4 602937','C4 16146F','A8 230 196','A3 DLP LP565','A3 ROA 226301','A2 LP565','B7 23554.170.3','B1 ABS36623/1','A1 FDB1083','A2 13.04602937.2','A3 FER FDB4260','C9 13.0460-2984.2','C9 VAL872960','C4 2355402TX','A8 238 970','A1 LP565','B1 ATE13.0460-2740','C9 0986494514','B1 BOS0986494387','A3 FER FDB4183','C4 0986494514','A1 13.0460-2623.2','A1 GDB1330DTE','A1 P85020X','A2 GDB1330DTE','A5 281792','A5 289249','A5 341384','A5 436237','A5 440754','A8 234 054','A9 GDB1330DTE','B1 ATE13.0460-2623','B1 ATE13.0460-2644','B1 ATE13.0470-2623','B1 ATE13.0470-2644','B1 BLPADR164201','B1 BLPADV184206','B1 BREP85020X','B1 KAMJQ1013576','B1 LUCGDB1330DTE','B1 ZIM20961.172.1','B7 20961.172.1','B7 B110041/DKM','C4 20961.172.1','C4 GDB1330DTE','C9 0252096115','C9 0252096115/PD','C9 0252096117','C9 0252096117/PD','C9 13.0460-2623.2','C9 13.0460-2644.2','C9 13.0470-2623.2','C9 13.0470-2644.2','C9 GDB1330DTE','C9 QP8078','C9 QP8078C','D1 BP ADR164201','D1 BP ADV184206')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #