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