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 ('A2 WK845/1','A9 H70WK','A1 CS456PU','C4 F0555DREIS','C4 WDK 725','A1 WK724','C9 WK724/3','A2 UFI 24.381.00','A8 366 059','A9 FI PP837/1','A2 WDK725','C4 WK 842/1','A1 FT5353','C4 WK 842/2','A2 FI PP837/1','B1 MANWK724/3','C4 CS456PU','A9 WK842/2','A9 WDK725','A8 357 431','C9 H70WK','A2 UFI 24.379.01','B1 FTRPP850','A9 UFI 24.379.00','A1 WDK725','A1 WK854','B7 PP845/1/AG','A9 WK842','C4 P550588','A2 UFI 24.378.00','A2 H119WK','C4 WK 842','A2 H70WK02','B1 FTRPP837/1','C4 WK 842 SD','B1 KNEKC43','C4 WK 842/2 (10)','A3 MNN WDK725','A1 WFF159','A2 H70WK','A3 MNN WK724','A8 370 582','B7 H70WK03','B1 FTRPP850/2','B7 H119WK','A5 324888','A8 371 110','A3 FLT PP850','B7 PP 850/IP','A1 WK842','C9 CS454','C9 WK842/2','B7 H70WK02','A3 FLT PP837/1','C4 WK 724','A3 MNN WK842/2','B1 HENH70WK03','A9 UFI 24.351.01','C4 ELG5214','B1 KNEKC68','B1 KNEKC32','B1 KNEKC25','B7 PP850/2/AG','B7 PP 850/2/IP','A2 WK724/3','B1 KNEKC102','C4 F0565DREIS','C4 P550498','C9 WDK725','A9 WK724/3','B1 MANWK724','A9 WK724','B1 HENH70WK02','A1 WFF169','A5 148916','A5 372184','A2 SF PF7123','C9 DN301','A2 WK842','A8 303 345','A9 FI PP837','C4 H70WK','A1 WK842/1','C4 WDK 724','C9 H119WK','A2 FI PP845/1','A2 UFI 24.351.00','A2 UFI 24.414.00','A8 327 958','A2 UFI 24.379.00','A8 318 400','B7 WK842/2/AG','B7 PP 837/IP','A9 FI PP850/2','B1 FTRPP837','A1 H70WK','A9 WK845/1','A2 FI PP837','A8 366 061','A3 MNN WK842','A9 UFI 24.414.00','A3 MNN WK845/1','A9 H70WK03','C9 WK845/1','C9 WK724','A8 370 362','B1 BLPADZ92302','A2 FI PP850/2','A9 UFI 24.381.00','B1 MANWK842/2','B1 HENH70WK','C4 WK 845/1','C4 FI 8186/1','A3 MNN WK845/5','C9 CS469','A1 CS469PU','C4 H70WK02','C9 ADZ92302','B7 PP837/AG','A9 UFI 24.351.00','D1 BP ADZ92302','C4 H119WK','B1 KNEKC17','A8 318 411','C4 F0178DREIS','A2 WK842/2','A3 FLT PP845/1','C9 H117WK','A1 FT5240','A3 MNN WK724/3','A1 WK842/2','B1 HENH119WK','B7 PP 845/1/IP','A1 WK724/3','B7 H70WK','A3 FLT PP837','A9 UFI 24.378.00','A8 320 557','A1 WK845/1','A8 366 083','C9 H70WK02','A1 H70WK02','B7 PP850/AG','C9 WK842','A9 FI PP850','A2 UFI 24.351.01','A2 H70WK03','B1 MANWDK725','B1 KNEKC18','B1 KNEKC69','C4 F0381DREIS','A5 75302','A9 FI PP845/1','B1 KNEKC112','B7 PP837/1/AG','A9 SF PF7123','A9 UFI 24.379.01','C4 F0578DREIS','A9 H70WK02','A3 FLT PP850/2','A8 318 284','B7 PP 837/1/IP','A8 331 483','A8 300 158','C9 CS456','B1 FTRPP845/1','A2 FI PP850','B1 MANWK842','A8 300 149','B1 PURCS456','B1 MANWK845/1','C4 WK 724/3','C9 SP-966','A8 318 853','A2 WK724','A1 1457434447','A1 CS701PU','A1 J1336039HB','A1 KC18','A1 KC38','A1 KC43','A1 WFF125','A1 WK842/11','A2 KC18','A2 KC38','A2 KC43','A2 SF PF7003','A2 WK842/11','A3 MHL KC18','A3 MHL KC43','A3 VAC V10-0345','A5 80413','A8 315 273','A8 316 960','A8 931 627','A9 1457434447','A9 KC18','A9 KC38','A9 SF PF7003','A9 WK842/11','B1 BOS1457434447','B1 FEB100360','B1 FEB17660','B1 FEB35350','B1 FEB35367','B1 HP100 316','B1 HP101 460','B1 KAMF300701','B1 KNEKC38','B1 MANWK842/11','B1 PURCS701','B1 VAI10-0345','B1 VAL587700','B1 VAL587715','B7 A120002/DKM','B7 A120007/DKM','B7 A120069/DKM','B7 ST302','B7 ST353','C4 1457434447','C4 17660F','C4 35367F','C4 F0557DREIS','C4 KC 18','C4 KC 38','C4 WK 842/11','C9 3121332002','C9 FE17660','C9 PF-1264','C9 PF-966','C9 WK842/11')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #