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 H70WDK14','A2 KC38','C9 H70WDK14','A3 MHL KC38','C9 50013075','A2 1457434322','A2 KC17D','C4 KC 18','C4 S 4378 NR','D1 BP ADJ132307','C4 KC 43','A3 BOS 1457434447','C4 WDK 725','A1 1457434447','C9 DN914','C4 H70WK02','A2 FI PP837','C9 SP-966','A3 BOS 1457434107','A1 WFF934','A3 BOS 1457434105','C4 1457434106','C4 1457434105','A5 80413','A9 KC32','A1 WDK725','A1 1457434320','A1 J1336039HB','C9 H70WK02','C4 CFF100111','A2 KC102','A1 KC 17','A3 MHL KC17D','A1 1457434150','A1 KC32','B1 FEB17660','C4 F026402094','A1 CS498PU','B1 PURCS701','A2 1457434105','A3 MHL KC43','A8 315 273','B1 CHACFF100111','A1 WFF159','C9 FC-695S','A3 MHL KC68','B1 HENH70WK','B1 BOS1457434105','B1 MANWK842','A3 MHL KC32','A1 WFF169','C4 CS701PU','A3 BOS 1457434295','B1 VAI10-0340-1','A1 WFF864','A5 372184','B1 HENH70WDK14','A1 KC74','A3 VAC V10-0340-1','B1 BOS1457434106','A5 9131','A2 1457434150','B1 BOSF026402094','A2 KC32','A1 0450133070','C4 J1336038','C9 CS454','C9 1457434150','A3 BOS 1457434106','A3 MNN WDK725','A2 WK842','C9 CS498','A1 CS701PU','A3 JAP FC-695S','C4 CS498PU','A1 0450133013','A9 H70WK02','A1 1457434322','A1 F026402094','A8 931 627','C9 ADZ92302','A1 1457434061','C9 DN323','A1 WK842','B1 FTRPP837','A1 WFF101','A9 1457434447','A8 331 483','A1 1457434156','A8 318 284','A2 UFI 24.351.00','A3 BOS 1457434174','A2 0450133071','A2 40 91 7660','C9 CS469','A1 H70WK02','B1 BLPADJ132307','A8 370 582','A1 KC17','A2 0S 8501 NR','A1 CS701','A3 VAC V40-0127','A8 371 110','C9 1457434295','A9 H70WDK14','C4 F0178DREIS','C9 0450133013','A2 WDK725','B1 DELHDF496','A1 1457434422','A9 KC17D','A9 H70WK','A3 BOS 1457434150','C4 H70WDK14','A1 KC66/1','A9 KC102','C9 1457434166','A9 UFI 24.351.00','A2 F026402094','C9 HDF496','A2 KC18','C9 H70WK','B7 H70WK','A3 DLP HDF496','C4 F0555DREIS','A2 0450133013','C9 1001270005','C4 0450133013','A1 1457434099','A2 1457434106','A9 KC38','C9 KC18','B1 MANWDK725','A1 CS469PU','A9 KC68','A8 323 789','A3 MHL KC102','A2 J1336038','C4 KC 38','A1 FP5493/A','B7 H70WK02','B1 BOS0450133013','C9 1457434447','C9 WDK725','C4 P550588','C4 S 8500 NR','B7 H70WDK14','B1 BOS1457434150','A3 FLT PP837','A1 1457434105','C9 H70WDK06','C9 ADJ132307','B1 BLPADZ92302','C9 1457434105','A5 148916','C9 1457434106','A3 JAP FC-L08S','C4 17660F','B7 PP 837/IP','C4 1457434150','C4 H70WK','A9 1457434106','A1 1457434174','A3 BOS 1457434322','B1 PURCS498','B1 BOS1457434447','A2 1457434447','A3 MHL KC18','A1 WFF201','C9 FC-L08S','A1 1457434164','C4 KC 102','C4 KC 32','D1 BP ADZ92302','C4 HDF496','C4 WK 842','A1 1457434106','A9 FI PP837','A1 KC43','A1 KC38','B1 VAI40-0127','C9 1457434322','C9 FE17660','A1 WFF245','A1 KC68','A9 WDK725','B7 ST302','A2 5.45081','A3 BOS 0450133071','A1 1457434295','B1 HENH70WK02','A1 KC18','A9 WK842','A9 KC18','B1 BOS1457434295','A1 1457434107','A5 148898','A3 DLP HDF601','B7 H70WK07','B7 PP837/AG','C4 1457434447','A1 KC17D','A3 MNN WK842','A2 H70WK02','C4 KC 17D','A2 KC43','A2 H70WK','A1 1457434159','A8 312 678','A8 300 158','A1 L111','A1 H70WK','A1 FP5833','A1 17660 FE','C4 KC 68','A1 H70WDK14','A3 BOS 1457434320','C9 71760560','A1 30-0L-L08ASK','A1 KC102','C9 DO342','A1 1457434053','A3 BOS F026402094','A3 BOS 0450133013','A1 0450133071','A1 1457434121','A1 1457434166','C4 S 8501 NR','A2 1457434295','B1 VAL587700','C9 F026402094','C9 H70WDK13','C9 CS701','A1 30-06-695ASK','C4 WK 842 SD','C9 WK842','A2 KC68','A1 1457434158','A1 WK842/2','C4 WK 842/2','A2 SF PF7003','A9 SF PF7003','B1 FEB35350','B1 HP101 460','B1 KNEKC18','B1 KNEKC38','B1 VAL587507')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #