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 FE FDB1300','A3 CIF 822-312-0','B1 CIF822-260-0','C4 FDS725','B7 B110055/DKM','A2 FE FDB725','B1 ZIM23287.175.2','C9 13.0460-5405.2','A3 BOS 0986495229','A2 GDB1348DTE','A1 13.0470-5405.2','B1 ATE13.0460-5405','B1 LUCGDB1348','B1 VAI20-4117','B7 23287.175.2','C4 KRO1348','B7 0384.00/REM','C9 VAL598018','B1 BREP06024','A2 LP1421','C4 05P757','A9 GDB1100','A1 0986495060','A9 23287.975.1','C9 GDB1348DTE','A2 GDB1100','A2 T 2328781','B1 FEB16343','A1 0986424483','A8 206 204','A1 FDB1300','C4 0986495229','A3 TEX 2328781','B7 23287.175.9','C4 0986494015','A1 FSL1300','B1 CIF822-124-0','A1 0986494015','B7 0384.40/REM','A3 BOS 0986494015','C9 19-3665','E1 20 91 6002','A2 07.B314.31','A1 0986460952','C4 GDB1348DTE','B1 VAI20-8115','B7 B110143/DKM','A2 13.04605405.2','B1 CIF822-312-0','C9 VAL598555','C4 FDB725','C9 13.0470-5405.2','A3 BOS 0986424483','C9 FE16343','B1 ABS36678','A3 ROA 238400','A5 165419','A2 RH 2384.40','A2 0986494015','B7 21925.175.1','C4 16343F','C4 KRO1100','A2 BP06024','A9 T 2328781','A2 BD S153','B1 VAL301018','C9 0986494015','A9 GDB1348','A2 GDB1348','C4 LP710','A1 LP1421','E1 20 91 6343','C9 0986460952','B1 BOS0986494015','A9 GDB1348DTE','B1 LUCGDB1100','C9 0986424483','A2 05P331','B7 1463600610/JP','A2 RH 2384.00','A2 05P757','A1 16002 FE','D1 BP ADB114221','C9 PA-0005AF','A3 FER FDB725','A1 13.0460-7109.2','C9 0252328717','A3 VAC V20-8115','B1 TOM1205','C9 FDB1300','B1 ZIM23287.175.1','A1 FDB1300-PROMO','C9 VAL301018','A2 0986495229','C4 605405','C9 21643 00 701 00','A5 119502','A9 RH 2384.00','C4 FSL725','C9 GDB1348','A9 FE FDB1300','C4 LD5405','A1 GDB1100','C4 GDB1348','A1 GDB1348','A8 200 140','A1 FSL725','C4 1170019','A1 0986495229','C9 GDB1100','C4 21925.175.1','A3 DLP LP710','B1 BLPADB114221','A3 DLP LP1421','A5 72864','A8 234 057','B1 TOM1316','A1 FDB725','C9 PA-0006AF','C9 2328781','C9 23287 00 701 00','B1 ZIM23287.975.1','A9 BD S153','A8 230 121','B1 FEB16002','A1 16343 FE','A8 217 140','A1 GDB1348DTE','A1 13.0460-5405.2','C4 FSL1300','A3 VAC V20-4117','A1 598018','A3 FER FDB1300','C4 LP1421','A1 WBP113','C9 19-0623','A8 229 431','B1 LUCGDB1348DTE','B7 23287.175.1','A1 WBP115','A9 RH 2384.40','A2 LP710','A9 BP06024','A9 13.04605405.2','C4 23287.175.2','A2 13.04705405.2','B1 ATE13.0470-5405','A3 CIF 822-260-0','A1 LP710','C4 05P331','E7 126.0','B1 ZIM21925.175.1','A1 P06024','A1 FSL1300-PROMO','A3 BOS 0986495060','C4 FDB1300','C9 23287-17,8 EPAD','A9 13.04705405.2','A3 ROA 238440','B1 ZIM23287.175.9','A9 FE FDB725','A9 0986494015','C4 23287.175.1','A2 23287.975.1','A2 Q109-1148','A3 QUI 109-1148','A9 Q109-1148','B1 KAMJQ1011450','B1 TRU08.35.006','C4 08.35.006','C9 0252328717/PD','C9 QB109-1148','C9 QP5619','C9 QP5619C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #