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 ('A1 WBP286','B7 B110631/DKM','C9 PA-0037AF','A2 05P349','C9 0252146318/W','C9 GDB1332','C4 2146306TX','A9 13.04602834.2','B1 CIF822-120-0','B1 CIF822-142-1','A9 GDB400','A9 05P349','A2 RH 2141.30','A9 RH 2141.30','C9 QP0910C','A8 217 476','C4 KRO1634','C9 GDB2012','A2 RH 2141.20','C9 PF0204','B7 0141.10/REM','C4 05P349','A8 230 502','C4 20772.180.1','A5 15945','C9 19-0459','C4 602834','C4 GDB1332','C9 QP0910','A3 BOS 0986495212','A1 GDB400','C4 GDB1635','A8 223 099','A1 FDB845B','A1 GDB2012','A3 ROA 214132','C4 GDB400','A9 BD S025','A2 13.04602834.2','A3 FER FDB845','A8 230 115','A2 LP885','A9 BP68038','C9 GDB1465','B7 B110905/DKM','B7 T482957/STC','C9 FDB845','A3 FER FDB845B','C4 05P220','C9 PA-035AF','A3 VAC V46-4101','D1 BP ADR164203','B1 CIF822-120-0K','A3 TRW GDB1332','C4 FDB845B','A2 21463 182 34','B1 KAMJQ1011690','C9 21463 00 702 10','A2 05P220','A1 P68008','A1 2146304 TEX','C9 GDB1634','A9 GDB1634','B1 LUCGDB1635','A3 CIF 822-120-0K','A8 201 640','B1 ZIM20772.180.1','B1 ABS36174','A9 GDB1332','C9 19-0470','A1 598775','A2 0986467720','C4 GDB1465','A3 TEX 2146303','A2 T 2146306','B7 0141.30/REM','A1 0986495212','A8 201 279','C4 0986495212','A1 WBP442','A9 0986467720','C4 FDB1781','C4 KRO400','C4 2146304TX','A9 FE FDB1781','A1 GDB1465','B1 TOM1047','A1 FDB1781','B1 KAM105078','A5 77579','A9 FE FDB845','B7 21463.180.2','C9 GDB1635','C9 GDB400','B1 LIN35.30.01','A3 FER FDB1781','A1 GDB1634','C4 T6088','B1 ZIM20905.180.1','B1 TOM1034','B1 VAI46-4101','A8 215 139','A1 GDB809','B7 B110904/DKM','A3 CIF 822-120-0','B1 ZIM21463.180.2','A9 T 2146306','A2 BD S025','B1 LUCGDB2012','C9 VAL598002','A2 FE FDB845B','A8 235 192','C9 PA-0602AF','A2 GDB400','A1 FDB845','C4 21463.180.2','C9 PF0203','A3 DLP LP885','B1 LUCGDB1465','B1 ABS36881','B1 VAL302259','A1 FDB845-PROMO','C1 RH 2141.20','A2 FE FDB845','A1 GDB1332','A5 42731','B1 LUCGDB1332','C9 VAL598084','E1 60 91 6191','A9 GDB1635','E3 21463.180.2','A9 21463 182 34','B1 TOM1048','A9 RH 2141.20','A1 598002','C9 0986467720','A2 0986495212','A2 05P1107','A2 BP68038','A2 GDB2012','C4 05P1107','A1 FSL845','C4 T5077','C4 KRO1332','A1 GDB1635','A9 GDB1465','B1 LUCGDB1634','B7 B110944/DKM','A3 TEX 2146304','B1 VAL301002','A3 ROA 214120','B1 LUCGDB400','A9 05P220','A5 40472','A2 RH 2141.32','C4 0986467720','A2 GDB1465','B1 BREP68038','B7 05P220/SUZ','A1 13.0460-2834.2','C9 0252146318/PD','A2 BP68008','A2 GDB1332','A3 ROA 214130','A1 P68038','C4 GDB1634','A9 BP68008','A2 RH 2141.10','A1 FSL1781','A1 LP885','A1 598084','B1 ATE13.0460-2834','B7 0141.32/REM','C9 2146306','A2 GDB1634','A9 RH 2141.32','C9 21463-18,2','C9 VAL301002','A1 0986467720','B1 ABS36583','A3 ROA 214110','B7 20905.180.1','B7 SP 189','C9 13.0460-2834.2','C9 2146304','A8 236 212','A2 FE FSL845','B7 B110590/DKM','B1 BREP68008','A3 BOS 0986467720','B7 0141.20/REM','A8 217 218','C9 21463-18,2 1 4','B1 BLPADR164203','A9 FE FDB845B','B7 20772.180.1','C4 FDB845','B1 TOM1178','A2 FE FDB1781','B1 BOS0986467720','A9 GDB2012','A3 TEX 2146306','A2 GDB1635','C4 LP885','A2 RH 2208.02','A3 ROA 214102','A3 ROA 220802','A5 194984','A9 GDB807','A9 GDB968','B1 LUCGDB807','B7 0141.02/REM','C4 GDB425','C4 GDB807','C4 GDB968','C4 V46-1228','C9 GDB807','C9 GDB968','D3 RE 24102-AF')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #