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 AH104','F4 UFI54.263.00','F4 VAL698885','C9 50013703','C9 1987431808','F4 DENDCF461P','D2 N113','B1 HENE900LI','C9 1987432808','B1 CHACCF0001','A3 BOS 1987432312','A3 MNN CUK2882','F4 MAD17082','A3 VAC V10-30-1013','C9 E900LI','F2 1000326561','C9 BCF122','F4 COR21651912','F4 COR80000817','A9 LAK31','F2 1002855535','C9 TSP0325004','A9 FI K1006','C4 LA 31','C4 S 3006 C','F2 1000713902','C9 VAL698160','F2 1002862455','C9 VAL698885','B1 CORCP1027','F4 VAL698160','A2 698159','A4 C300','B1 VAL698159','F2 1000403499','F4 PURAH104','C4 DCF461P','A8 914 761','F4 MAHLA31','B1 PURAH104','F4 KBS50013703','A3 DEN DCF461P','C4 E900LC','F4 MAHLAK31','B1 VAL698160','A9 FP2882','C9 21651912','B1 MMABCF122','F4 SCTSA1106','F2 1002918866','A8 327 198','C4 K0550DREIS','C4 FP 2882','A9 LA31','A2 1987432808','C4 AH104PU','B7 K 1006/IP','A8 367 274','B1 VEM10-30-1013','C9 VAL698679','C9 1987432012','C9 1123190001','B1 BOS1987432808','A2 698885','F4 FILK1005','F2 1001205443','F4 VAL698679','B7 E900LI','B9 FLT K1006','A3 FLT K1006','F4 MANCUK2882','D1 BP ADV182521','F4 BOF1987432808','B7 K 1005/IP','B1 VAL698679','A2 UFI 54.263.00','A5 230424','B7 K1006/AG','C4 1987432012','A3 MHL LA31','C9 1987431312','C4 1987432312','A9 UFI 53.006.00','B1 BOS1987431808','B1 MANCUK2882','F4 BLPADV182521','F2 1001138003','B1 MANFP2882','C9 K1006','F4 HENE900LI','A2 CP1027','A2 1987432012','A2 1987432312','B1 FEB09446','B9 MHL LA31','F4 WIXWP6812','C9 1123190029','A3 BOS 1987432012','F2 1000065266','F2 1000403531','F2 1003293600','C4 698159V','B7 SA1106','B1 VAL698885','C9 ADV182521','A2 30 90 9446','B1 BOS1987432012','A8 319 042','C9 NC2012','F4 UFI53.006.00','C9 FE09446','A5 44459','B1 FTRK1005','C9 21651912MX','A5 68840','C9 VAL698159','F4 BOF1987431808','F2 1009282716','A2 LA31','A9 1987432808','A2 UFI 53.006.00','C4 CCF0001','F2 1004044823','E9 09446','A2 FI K1005','A8 313 441','B7 E900LC','A9 E900LI','F2 1011484044','A2 LAK31','F4 BOF1987432012','F4 MANFP2882','C4 09446F','B1 DENDCF461P','F4 FILK1006','A2 CUK2882','A8 313 425','A2 FP2882','A8 370 285','F4 HENE900LC','A5 65842','A2 698679','C4 CUK 2882','A9 UFI 54.263.00','C4 E900LI','A5 40890','C9 E900LC','F2 1002870481','B1 BOS1987432312','F4 WIXWP6813','F4 BOF1987432312','A3 MHL LAK31','C9 FP2882','A2 698160','F4 FEB09446','A9 1987432312','F2 1000057293','A5 230432','C4 LAK 31','A5 264293','F4 MMABCF122','C9 1987432312','C4 TSP0325004','C9 CUK2882','F4 VAL698159','A2 E900LI','B1 BLPADV182521','B1 FTRK1006','E6 FC1195','C4 S 4263 CA','A8 370 286','A3 BOS 1987431012','A8 305 415','A9 CUK2882','A3 BOS 1987432808','A3 FLT K1005','B1 HENE900LC','A2 FI K1006','A9 1987432012','F2 1002908215','D1 BP ADV182522','A2 KC278/205.26','A2 698716','A2 K278/205.25','A2 KC280/205.30','A2 SF KF9003','A2 UFI 54.109.00','B7 SAK144','A3 FLT K1047A','C4 CU 2882','A9 SF KF9003','B1 JPN40F9005-JPN','B1 KAMF400101','B1 KAMF500201','B1 KNELA31','B1 PPF4F0003','B7 M110001/DKM','C4 07.59.019','C6 017804','C9 FE178586','C9 KF-6109','C9 KF-6109C','C9 KF-6109SC','C9 MS-6109','F4 BLPADBP250050','F4 DECM110001','F4 DLL180049710','F4 FEB178586','F4 KAOF400101','F4 KAOF500201','F4 KAVFCA-10052','F4 TOP108 407')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #