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 ('A3 DLP LP710','C4 LP710','A9 13.04705405.2','C9 23032-15,5','A1 FSL725','C4 21925.175.1','A1 16343 FE','A1 13.0460-7109.2','A2 05P331','C4 08.35.006','C9 13.0470-5405.2','B7 23287.175.2','A8 229 431','C4 0986494015','C9 VAL598555','A9 GDB1348DTE','A3 FER FDB725','C9 2193402','A2 LP647','A3 TEX 2193481','A9 FE FDB1300','A8 200 140','A2 0986495229','C9 0252328717/PD','C4 2328702TX','C4 605405','C9 21934-17,3','C4 23287.175.2','A9 BP06024','C4 GDB1348DTE','C4 FSL725','A1 0986495229','A1 P06024','C9 0986424483','A1 LP647','B1 VAI20-8115','C9 0252164317','E1 20 91 6002','B1 ZIM23287.175.9','A1 FDB725','A1 WBP115','A9 13.04605405.2','B7 23287.175.1','B1 BOS0986494015','A2 LP1421','A1 13.0470-5405.2','E7 126.0','C9 FE16343','C9 13.0460-5405.2','C9 0986460952','A2 0986494015','C9 2193481','B7 23287.175.9','C9 221525','A1 0986494015','A9 0986494015','C9 0252328717','C4 2193402TX','C9 0986494015','C4 23287.175.1','A3 BOS 0986495229','A8 203 505','A1 FSL1300-PROMO','A1 13.0463-5405.2','B1 ZIM23287.175.2','A3 BOS 0986424483','A2 13.04705405.2','A2 05P757','E1 20 91 6343','B7 21925.175.1','B1 ABS36678','A1 LP1421','A5 119502','A1 0986424483','A3 TEX 2303201','A1 F026000014','A8 234 057','A2 23032 155 05','B7 0384.00/REM','C4 16343F','A8 229 585','A1 16002 FE','C9 23287-17,8 EPAD','A8 203 504','C9 GDB1348DTE','A1 FQT725','A2 FE FDB725','C4 05P331','C9 0252192517','B1 VAI20-8115-1','B7 0384.40/REM','A2 GDB1348DTE','B1 ATE13.0470-5405','C9 VAL301018','B1 ZIM21925.175.1','A3 FER FDB1300','A2 21934 173 05','C4 LP1421','A1 FDB1300-PROMO','C4 FDS1300','C9 VAL598018','A2 23287 178 05','A1 WBP113','C9 2328702','A5 72864','B1 TRU08.35.006','B1 ZIM23287.175.1','A9 21934 173 05','A3 TEX 2193402','A3 TRU 08.35.006','A3 DLP LP1421','C4 0986495229','A8 217 140','B7 SP 164','C9 23287-17,8','A2 LP710','C4 FDS725','B1 LUCGDB1348DTE','B1 FEB16343','C4 FDB1300','A2 RH 8384.02','B1 BREP06024','A2 13.04605405.2','B7 0296.02/REM','C4 LD5405','A1 LP710','B1 ATE13.0460-5405','C9 2328781','B1 VAL301018','A1 FSL1300','A2 FE FDB1300','C9 21934-17,3 EPAD','A9 23287 178 05','A2 BP06024','C9 221510','A1 FDB1300','A3 TEX 2328702','A1 13.0460-5405.2','A3 BOS 0986494015','A1 0986460952','A3 VAC V20-8115-1','C4 FDB725','A9 T 2328781','A1 598018','C4 FSL1300','A3 VAC V20-8115','C9 FDB1300','A3 DLP LP647','A1 GDB1348DTE','A9 FE FDB725','A8 206 204','A3 TEX 2328781','A2 T 2328781','C4 05P757','B1 FEB16002','A1 FQT1300','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')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #