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