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