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