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 M110007/DKM','B1 BOS1987432312','A5 35770','A1 WCF103','B7 K 1006/IP','A8 326 781','A5 202313','C4 LAK 31','C4 FP 2882','C4 1987432312','B1 PURAHC178','C9 MS-6109','B1 CHACCF0112C','B1 MANCUK2882','C4 E900LC','B1 PURAHA178','B1 VEM10-31-1040-1','A8 370 285','A1 CUK2862','A1 WCFA129','C4 CUK 2882','A8 930 347','A2 CC1027','A2 SF KF9051C','C4 CCF0112C','A1 FP2862','C9 108407015','B1 VKA18190184201','C6 014060','A9 FP2862','B1 VEM10-31-1013','A1 AHC104PU','C9 TSP0325004','C9 CUK2862','C6 007131','C4 V10-31-1040-1','A1 WCF129','A1 LAK63','C9 21651955','A3 BOS 1987432300','C4 TSP0325027C','A1 LAK31','A3 FLT K1006','A8 360 850','C4 07.59.023','A8 325 219','A8 319 043','B1 BOS0986628509','B7 E900LC','B7 1128101900/JP','C9 1987432300','A2 CC1028','A1 698716','C6 007006','A8 319 334','B7 E900LB','A1 CUK2882','A1 LAO31','C4 592','C4 E900LB','B7 K1047A/AG','C9 VAL698885','A9 SF KF9051C','C9 0986628509','A2 FI K1006A','B1 HENE900LC','A5 65843','B1 COR21651955','C4 TSP0325004','A3 MNN CUK2882','B1 FEB11566','A9 CUK2862','A2 FI K1047A','D2 N113','C9 108407755','A1 1987432300','C9 50013725','C9 VAL698716','A9 UFI 54.263.00','C9 FP2862','B7 M110001/DKM','A3 FLT K1047A','A2 701016','A5 272983','A8 319 042','A9 LAK63','A2 0986628509','B7 SA1144','A9 UFI 54.109.00','A2 UFI 54.263.00','B1 BOS1987432300','B7 SAK144','C4 DCF225K','C9 AHC178','B1 MANCUK2862','A8 358 152','C9 BCF122','A3 MNN CUK2862','C9 FP2882','B1 TRU07.59.023','A2 1987432300','B1 MMABCF122','C4 LAK 63','C4 CUK 2862','A2 FP2862','C9 NC2082CA','A1 FP2882','C9 VAL701016','A2 698716','B1 VEM10-30-1013','B1 CORCP1545','C9 FE11566','A1 DCF002K','C9 1987432312','A8 367 442','A2 FI K1006','C9 KF-6228SC','A8 914 761','A2 30 91 1566','B1 KNELAK31','C9 TSP0325004C','B1 MANFP2882','A5 192503','A2 698885','B1 VAL701016','A2 CUK2862','C4 LAO 31','C4 1987432300','A9 FI K1047A','C9 MS-6109C','C4 S 4109 CA','C4 FP 2862','C9 1123201001','B7 K1006/AG','A2 1987432312','A3 MHL LAK31','B1 HENE900LB','A5 210586','A8 314 124','C9 BCF340','A9 FI K1006A','C4 AHC178PU','A3 BOS 1987432312','C9 21651967','C9 CUK2882','C9 B12796','A1 AHC178PU','B1 FTRK1047A','A8 380 591','C4 DCF002K','B1 CORCC1028','B1 KAM6080002','B1 PURAHH178','B7 K 1006A/IP','A1 1987432312','A1 698885','A2 FP2882','C9 E900LC','A8 313 441','A2 UFI 54.109.00','A2 LAK31','A1 701016','B1 KNELAK63','A2 LAO63','B1 PURAHC104','C4 TSP0325004C','B1 DENDCF225K','C4 AHC104PU','B1 DENDCF002K','A9 LAK31','A5 44459','B1 MANFP2862','C6 017804','B1 FTRK1006','C9 K1006','B7 K 1047A/IP','C4 LAO 63','C4 K0549DREIS','B7 K1006A/AG','C9 AHC104','A3 FLT K1006A','A1 CCF0112C','B1 VKA18190186801','C4 0986628509','A9 1987432312','A1 11566 FE','A9 FI K1006','B1 FTRK1006A','A9 FP2882','C4 11566F','B1 VAL698716','C4 K0550DREIS','B1 VAL698885','A3 TRU 07.59.023','A8 305 415','A2 CUK2882','A5 394106','A1 DCF225K','B1 KAMF500201','C9 KF-6228C','A9 LAO63','B1 MMABCF340','A1 LAO63','A3 MHL LAK63','A9 1987432300','A3 VAC V10-31-1040-1','B1 KNELAO31','A2 LAK63','A9 CUK2882','A5 68840','B1 KAMF500401','A1 WCF100','A2 K278/205.25','A2 KC278/205.26','A2 KC280/205.30','A2 SF KF9003','B7 SA1106','C4 CU 2882','D1 BP ADV182521','E6 FC1195','D2 K1006','A8 927 759','B1 VAI10-3149','B1 VAI10-3153','B1 VAI10-3190','C9 1123200001')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #