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','C9 23287-17,8','A2 RH 2384.40','C4 23287.175.2','C9 GDB1348','C4 LP1421','C4 0986494015','A9 BD S153','C4 21925.175.1','B1 ZIM21925.175.1','C9 0252193417/PD','A1 FSL1300-PROMO','A2 13.04605405.2','A2 05P463','C4 2328702TX','C4 05P757','C9 23287 00 701 00','A3 ROA 238440','B1 ZIM21934.170.1','C9 QP5619C','A2 05P757','B1 CIF822-312-0','B7 B110054/DKM','A9 21934.970.1','B1 ZIM21934.970.1','A1 WBP113','A2 21934.970.1','B1 ABS36678','C4 FDB1300','B7 23287.175.9','A2 LP1421','A1 16343 FE','A2 GDB1100','C9 0252328717','B1 TOM1317','C9 PP-0009AF','B1 ZIM21934.170.9','B1 BREP06024','A3 CIF 822-312-0','E7 126.0','B1 VAL301018','C9 QP5619','A8 234 057','A2 GDB1348DTE','A3 BOS 0986495060','A8 200 140','A3 FER FDB1300','B1 CIF822-260-0','A8 206 204','A3 TEX 2328781','C9 PF0154','C4 05P331','B1 BOS0986494015','C9 2328702','C4 KRO1348','A2 RH 2384.00','A9 13.04605405.2','B7 1463600610/JP','A8 217 140','B7 B111092/DKM','A1 LP710','B7 0384.00/REM','A3 FER FDB725','C9 0252328717/PD','C9 FDB1300','A2 23287 178 05','C4 21934.170.1','C4 GDB1348','A5 165419','C9 23287-17,8 EPAD','A1 GDB1348','B7 21934.170.1','A9 23287.975.1','C4 GDB1348DTE','A1 GDB1348DTE','A2 21934.170.9','B7 21925.175.1','B1 ATE13.0470-5405','B1 ZIM23287.175.2','C4 16343F','A1 FSL1300','C4 LD5405','A2 BD S153','A3 DLP LP1421','A3 BOS 0986494015','A1 WBP115','C9 PF0155','A9 FE FDB1300','A9 13.04705405.2','B1 ABS36824','C9 PA-0005AF','A1 598018','A3 CIF 822-260-0','C4 FSL1300','A2 05P331','C9 19-0526','B7 23287.175.2','C9 0986460952','C9 GDB1100','C4 21934.170.9','A3 ROA 229602','A9 RH 2384.00','A5 131294','B7 21934.170.9','C9 PF0157','C4 1170019','C4 0986495229','C9 QP2191C','A3 CIF 822-261-0','A3 VAC V20-8115','C4 05P463','A2 0986494015','A2 0986495229','A1 13.0470-5405.2','A3 TEX 2328702','A1 13.0460-5405.2','A3 DLP LP710','A2 13.04705405.2','C9 QP5332','C9 21643 00 701 00','A1 GDB1100','C9 PA-0006AF','C9 2328781','B1 ZIM23287.975.1','A1 0986495060','A1 LP1421','A9 GDB1348DTE','A1 FDB1300','B1 CIF822-261-0','A1 0986460952','B7 B110143/DKM','B1 ATE13.0460-5405','C4 FDB725','A2 T 2328781','C9 13.0470-5405.2','A1 0986495229','C9 19-0623','B1 ABS36140','A9 GDB1100','A3 BOS 0986495229','B1 VAI20-4117','A2 23287.975.1','A3 VAC V20-8115-1','A9 0986494015','A1 0986424483','A2 GDB1348','B1 CIF822-124-0','C9 GDB1348DTE','A3 BOS 0986424483','C9 FE16343','A2 FE FDB725','A9 GDB1348','A9 RH 2265.40','B7 1463700210/JP','A8 230 121','E1 20 91 6343','C9 VAL598018','A5 72864','A9 RH 2384.40','B1 ZIM23287.175.9','A3 ROA 238400','A1 P06024','A9 BP06024','B1 FEB16343','B1 TOM1316','A3 ROA 226540','A8 229 431','B1 VAI20-8115','A3 VAC V20-4117','A2 BP06024','B1 LUCGDB1348','A1 FDB725','A9 FE FDB725','B1 KAMJQ1011450','C4 605405','A1 0986494015','A2 LP710','B1 TRU08.35.006','A5 119502','C9 0986424483','A3 TRU 08.35.006','C9 QP5332C','A1 FDB1300-PROMO','C4 08.35.006','B1 TOM1205','C4 23287.175.1','C9 0986494015','B1 LUCGDB1100','A2 RH 2296.02','C9 VAL301018','C9 QP2191','A9 23287 178 05','C9 19-3665','B7 23287.175.1','C9 13.0460-5405.2','A8 203 504','A9 21934.170.9','B1 VAI20-8115-1','C4 KRO1100','B1 ZIM23287.175.1','B1 LUCGDB1348DTE','B7 B110055/DKM','C4 LP710','A2 FE FDB1300','A9 T 2328781','A2 RH 2265.40')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #