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 ('C9 13.0470-5405.2','C4 2193402TX','C4 LP710','E7 126.0','A2 BP06024','A1 FSL1300-PROMO','A2 23287 178 05','B1 TRU08.35.006','A1 FSL725','A1 13.0460-5405.2','C9 23287-17,8 EPAD','C4 LP1421','C9 0252192517','B1 VAI20-8115','C9 FDB1300','C4 LD5405','C4 23287.175.2','C4 FDB1300','A3 TEX 2328781','C4 FSL725','B1 ZIM23287.175.1','A2 23032 155 05','A3 VAC V20-8115-1','C9 0252164317','A3 TEX 2303201','A1 WBP113','A2 13.04705405.2','C9 0986494015','C4 2328702TX','C4 FSL1300','C9 VAL598555','A3 TEX 2193481','A9 FE FDB725','C4 23287.175.1','C4 16343F','B1 VAI20-8115-1','A9 BP06024','A1 F026000014','A3 VAC V20-8115','A1 0986460952','A1 LP1421','A8 203 504','A1 0986494015','C4 05P757','A8 206 204','B1 BOS0986494015','B1 BREP06024','A1 16002 FE','B7 23287.175.2','B1 ZIM23287.175.9','C9 13.0460-5405.2','A9 GDB1348DTE','A3 TEX 2193402','A9 FE FDB1300','A3 FER FDB725','B1 ABS36678','A9 T 2328781','C4 GDB1348DTE','C9 23032-15,5','C9 21934-17,3','A2 RH 8384.02','C4 0986495229','C4 0986494015','C4 FDB725','B7 SP 164','A2 05P331','C9 23287-17,8','A1 FQT1300','A5 72864','A9 13.04605405.2','B1 ATE13.0470-5405','C4 21925.175.1','A2 FE FDB725','C9 221510','A2 FE FDB1300','B7 0384.40/REM','A3 BOS 0986495229','C9 0252328717/PD','A8 203 505','A1 13.0460-7109.2','A1 FSL1300','A1 FQT725','E1 20 91 6002','A2 05P757','C9 2328702','A2 LP647','C4 FDS725','C9 FE16343','C9 0986460952','A3 BOS 0986424483','A2 GDB1348DTE','A3 FER FDB1300','A2 0986494015','B1 ATE13.0460-5405','A8 200 140','A3 DLP LP710','B1 FEB16343','B7 0296.02/REM','A8 229 431','B1 ZIM23287.175.2','A1 13.0470-5405.2','C4 FDS1300','A8 234 057','A1 LP710','A5 119502','A1 LP647','A9 0986494015','A2 T 2328781','C4 05P331','C9 VAL301018','A2 21934 173 05','C9 0252328717','A1 FDB1300-PROMO','C9 221525','A1 16343 FE','A8 229 585','A1 WBP115','A1 0986495229','A1 598018','C4 08.35.006','A3 DLP LP1421','A3 BOS 0986494015','E1 20 91 6343','B7 23287.175.1','C4 605405','C9 2193402','C9 2193481','B7 21925.175.1','C9 0986424483','A1 GDB1348DTE','A3 DLP LP647','A2 0986495229','A1 P06024','B1 VAL301018','A9 13.04705405.2','C9 2328781','A8 217 140','A9 21934 173 05','A1 13.0463-5405.2','A9 23287 178 05','A3 TEX 2328702','C9 GDB1348DTE','B7 23287.175.9','A2 13.04605405.2','A1 FDB1300','B7 0384.00/REM','B1 FEB16002','C9 21934-17,3 EPAD','A2 LP1421','A1 FDB725','B1 ZIM21925.175.1','C9 VAL598018','A2 LP710','A3 TRU 08.35.006','A1 0986424483','B1 LUCGDB1348DTE','A2 QWS0105A','A2 QWS0191A','A2 QWS0191B','A2 QWS0199A','A2 RH 2384.40','A3 CIF 822-260-0','A3 PEX WK220','A3 QUI 109-1221','A3 QUI WS0105A','A3 QUI WS0152A','A3 QUI WS0191A','A3 QUI WS0199A','A3 ROA 238440','A8 502 526','A9 Q109-1221','A9 QWS0105A','A9 QWS0191A','A9 QWS0191B','A9 QWS0199A','A9 RH 2384.40','B1 BLPADB114221','B1 CIF822-260-0','B1 KAMJQ1011450','B1 QB109-1221','B1 QBWS0191A','B1 QBWS0199A','B7 B110055/DKM','B7 B110143/DKM','C9 19-0623','C9 19-3665','C9 PA-0006AF','C9 QB109-1221','C9 QBWS 0199 A','C9 QP5332','C9 QP5332C','C9 QP5619','C9 QP5619C','C4 GDB1348')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #