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 FE FDB845','C4 0986467720','A8 201 640','B7 0141.32/REM','A8 215 139','C9 21463-18,2','A1 LP838','C9 VAL301002','A2 GDB968','C4 GDB1465','B1 LUCGDB1332','C9 13.0460-2955.2','A1 GDB1332','C9 GDB1634','A9 BD S025','A1 GDB1428','A3 TRW GDB807','C4 GDB1634','A2 RH 2141.20','B1 FEB16241','A1 598002','A2 T 2146306','B1 LUCGDB1465','B1 LUCGDB1634','B1 LUCGDB1873','C4 KRO1634','A3 FER FDB845B','A8 230 115','A2 GDB1634','A1 WBP287','A9 GDB1634','A8 230 502','A3 TEX 2146304','A1 16241 FE','A3 TEX 2146303','A1 WBP364','A8 236 212','C4 2146306TX','C9 VAL598002','A9 05P349','C9 GDB1428','C9 GDB1332','A5 40472','B7 0141.02/REM','A1 GDB1634','A1 FDB845','A1 GDB1465','A3 ROA 214110','C9 2146306','A9 RH 2141.30','C4 2146304TX','A8 201 279','B1 LUCGDB400','A3 ROA 214102','A9 13.04602955.2','A9 T 2146306','C4 602955','C4 GDB400','A5 77579','A2 RH 2141.10','C4 21463.180.2','B1 VAL301002','A9 13.04602834.2','A2 GDB1873','C9 GDB968','C4 GDB1873','A2 FE FDB845','A3 TRW GDB1332','A1 GDB968','B1 ZIM21463.180.2','A5 15945','A2 LP885','C9 GDB1465','A1 GDB807','A9 GDB807','A1 598084','A2 05P349','B1 ATE13.0460-2955','C9 VAL598084','A5 294757','A3 ROA 214120','A1 FDB845B','B1 BLPADR164203','A2 GDB1332','B1 BREP68008','B1 ATE13.0460-2834','B1 LUCGDB807','B7 0141.10/REM','A2 13.04602955.2','A2 BD S025','A3 ROA 214130','C4 T5077','E3 21463.180.2','A5 42731','B1 ABS36881','A9 RH 2141.20','A1 2146304 TEX','A1 13.0460-2955.2','D1 BP ADR164203','C9 0986494522','A1 0986495212','A2 GDB807','A2 13.04602834.2','A2 21463 182 34','A1 GDB809','C1 RH 2141.20','C9 13.0460-2834.2','A1 LP885','A9 GDB1332','C9 PA-0037AF','B7 0141.30/REM','C4 LP885','B1 BOS0986467720','B7 21463.180.2','C9 FDB845','A2 0986495212','C4 0986495212','A3 BOS 0986494522','C9 GDB400','A3 BOS 0986467720','A2 RH 2141.30','A1 WBP286','C9 2146304','A1 GDB1873','C4 GDB968','A9 0986467720','A1 P68008','C9 21463-18,2 1 4','A8 233 607','A9 GDB400','C4 GDB1332','A9 GDB1873','A1 0986467720','A9 21463 182 34','A1 WBP442','A2 RH 2141.32','A3 ROA 214132','A9 BP68008','C4 KRO1332','C4 KRO400','A2 GDB1465','A1 0986494522','A3 FER FDB845','A9 GDB968','C9 0986467720','A1 GDB400','A3 DLP LP885','C4 05P349','A2 0986467720','B1 LUCGDB968','A9 RH 2141.32','A5 194984','A9 FE FDB845B','A2 RH 2141.02','A8 223 099','B1 BOS0986494522','C4 FDB845','C4 GDB807','A9 GDB1465','C9 GDB807','A1 13.0460-2834.2','A2 BP68008','A2 FE FDB845B','C9 GDB1873','A3 BOS 0986495212','C4 602834','B1 LUCGDB1428','A2 GDB400','A3 TEX 2146306','C4 FDB845B','A1 FDB845-PROMO','A1 16191 FE','A2 Q109-1835','A2 RH 2192.12','A2 RH 2208.02','A3 CIF 822-120-0K','A3 QUI 109-1835','A3 ROA 219212','A3 ROA 220802','A9 Q109-1835','B1 CIF822-120-0K','B1 FEB16191','B1 KAMJQ1011690','B1 QB109-1835','B7 0192.12/REM','B7 B110590/DKM','B7 B110631/DKM','B7 B110905/DKM','B7 B110944/DKM','C4 V46-1228','C9 0252146318/PD','C9 0252146318/W','C9 19-0459','C9 21463 00 702 10','C9 QB109-1835','C9 QP0910','C9 QP0910C','D3 RE 24102-AF')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #