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 ('A9 13.04605405.2','C4 KRO1100','A1 16002 FE','A2 13.04605405.2','B1 ZIM23287.175.1','A2 LP1687','A2 RH 2384.00','C4 23287.175.1','C4 FDB1300','A1 16343 FE','B1 BOS0986494015','C9 GDB1100','A8 229 431','A1 0986460952','B1 ZIM23287.175.2','A3 BOS 0986424483','A8 217 140','A9 BD S153','B1 LUCGDB1100','A5 165419','C9 23287-17,8','C9 GDB1348','A9 FE FDB725','A2 GDB1348','C4 FDB725','A3 DLP LP710','A2 BD S153','C4 LP710','A1 WBP113','A3 ROA 238440','C4 605405','C9 19-3665','A2 0986495229','A2 23287 178 05','C9 21643 00 701 00','B7 21925.175.1','B7 23287.175.9','B7 0384.00/REM','A9 0986494015','A1 FDB1300','A3 TEX 2328702','A2 05P331','C4 05P757','A3 DLP LP1687','B1 BLPADB114221','A1 GDB1348','C9 VAL301018','A3 BOS 0986494015','A3 FER FDB725','A2 FE FDB725','C4 23287.175.2','A2 FE FDB1300','A1 0986495229','C4 2328702TX','B1 LUCGDB1348','B1 FEB16343','E7 126.0','B1 VAL301018','C9 PA-0006AF','A9 23287 178 05','C9 0986494015','A1 FSL1300-PROMO','A1 598018','A9 FE FDB1300','C9 13.0460-5405.2','C4 0986494015','C4 FSL725','A1 WBP115','B1 CIF822-312-0','C9 2328781','C9 2328702','A2 05P757','B7 0384.40/REM','A9 23287.975.1','B1 CIF822-124-0','C4 GDB1348','A1 LP1421','E1 20 91 6002','A9 GDB1348','A2 LP710','B1 CIF822-260-0','A2 23287.975.1','C9 VAL598018','A3 ROA 238400','C9 0986424483','B7 23287.175.1','C9 0986460952','C4 05P331','B1 FEB16002','A3 FER FDB1300','D1 BP ADB114221','A1 LP710','A3 DLP LP1421','C9 0252328717','B7 23287.175.2','C4 16343F','A9 GDB1100','A2 RH 8384.02','A2 0986494015','A5 119502','A1 GDB1100','B1 ZIM21925.175.1','C4 21925.175.1','A3 BOS 0986495060','A1 FDB1300-PROMO','A1 FSL1300','C4 KRO1348','A5 72864','A1 LP1687','A9 RH 2384.40','A8 230 121','A9 T 2328781','B1 ZIM23287.975.1','E1 20 91 6343','C9 FDB1300','A8 206 204','A1 0986494015','A9 RH 2384.00','C9 FE16343','A1 0986424483','A3 BOS 0986495229','A1 FDB725','A3 TEX 2328781','A2 T 2328781','C4 FSL1300','C9 PA-0005AF','A1 13.0460-7109.2','C9 VAL598555','A2 RH 2384.40','C9 23287 00 701 00','C4 1170019','C9 23287-17,8 EPAD','A8 200 140','C4 0986495229','A3 CIF 822-312-0','C4 LP1421','B1 ABS36678','B1 ATE13.0460-5405','A8 203 504','A2 LP1421','A1 13.0460-5405.2','A2 GDB1100','C9 19-0623','A3 CIF 822-260-0','A1 0986495060','A1 FSL725','B1 ZIM23287.175.9','A1 13.0470-5405.2','A2 13.04705405.2','A2 Q109-1148','A2 QWS0105A','A2 QWS0191A','A2 QWS0191B','A2 QWS0199A','A3 PEX WK220','A3 QUI 109-1148','A3 QUI WS0105A','A3 QUI WS0152A','A3 QUI WS0191A','A3 QUI WS0199A','A8 234 057','A8 502 526','A9 13.04705405.2','A9 GDB1348DTE','A9 Q109-1148','A9 QWS0105A','A9 QWS0191A','A9 QWS0191B','A9 QWS0199A','B1 ATE13.0470-5405','B1 LUCGDB1348DTE','B1 QBWS0191A','B1 QBWS0199A','B7 B110055/DKM','B7 B110143/DKM','C4 GDB1348DTE','C4 LD5405','C9 0252328717/PD','C9 13.0470-5405.2','C9 GDB1348DTE','C9 QB109-1148','C9 QBWS 0199 A','C9 QP5332','C9 QP5332C','C9 QP5619','C9 QP5619C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #