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 ('A1 WFF201','C9 FC-695S','A9 KC68','A3 FLT PP837','A9 WK842/2','A1 H159WK','A8 370 710','A1 H70WK02','C9 ADJ132307','A1 WFF864','C9 DN323','A3 BOS 0450133009','C4 KC 68','A1 1457434121','C4 KC 373','A9 SF PF7123','B1 FTRPP850/2','A3 FLT PP850/2','A9 FI PP845/1','A1 CS701PU','C4 WK 824/2 SD','B1 FTRPP837','A3 BOS 1457434107','A8 312 678','A3 BOS 1457434320','A3 BOS 1457434174','A1 1457434107','A5 50369','C4 1457434329','A3 MHL KC18','A1 J1330511HB','C4 CS701PU','C4 F0536DREIS','B1 MANWK842/2','A9 KC17D','C9 1457434329','A9 FI PP850/2','B7 PP850/2/AG','A1 KC66/1','A1 0450133009','A3 MHL KC373','B1 VAL587742','B1 BLPADG02348','C4 H288WK','C4 F026402094','A2 0450133013','A1 1457434329','C9 WK724/3','A1 CS469PU','A1 WFF189','B7 PP845/1/AG','A9 UFI 24.414.00','A3 MNN WK724/3','B7 WK842/2/AG','D1 BP ADZ92302','A2 KC68','A9 KC18','C9 0450133013','A3 BOS 0450133071','A8 315 273','B7 PP 850/2/IP','A2 UFI 24.414.00','A5 397011','A2 1457434329','A1 WK724/3','A2 H70WK02','A1 0450133013','A3 MNN WK842/2','A8 300 149','A3 BOS 1457434106','B1 BOS1457434329','A1 WFF101','A8 359 551','C9 H70WK02','B1 BLPADJ132307','A5 372184','A1 0450133071','A9 1457434106','B1 VAL587715','A3 JAP FC-L08S','B7 PP837/AG','E6 FF1158','D1 BP ADJ132307','A8 371 110','A1 KC18','C4 1457434106','A2 1457434105','A2 0450133009','A2 WK824/2','A2 0S 4414 NR','A5 80413','A3 MNN WK824/2','A2 WK842/2','A1 WK842/11','A5 37582','C9 HDF532','C9 WK824/2','A9 KC80','C9 F026402094','A1 WK842/1','A2 UFI 24.394.00','A1 KC17D','B1 BOS1457434106','A2 WK842/11','A9 FI PP837','B1 PURCS701','A1 1457434106','C4 1457434105','D1 BP ADV182347','A5 9131','A3 BOS F026402094','B1 BLPADV182347','A8 327 958','A1 KC74','B1 FTRPP845/1','A1 KC68','A3 JAP FC-695S','B1 MANWK724/3','A1 1457434174','B1 HENH70WK02','A9 UFI 24.351.00','C4 H159WK','A3 BOS 0450133013','A5 148916','C9 KC18','A9 1457434329','A3 BOS 1457434329','A2 KC17D','C9 CS454','A2 FI PP837','C9 CS469','C4 KC 18','B7 H159WK','A1 1457434105','B1 HENH159WK','A1 WK824/2','A2 F026402094','A1 1457434099','C9 CS701','A1 KC373','B7 PP 845/1/IP','A2 1457434106','B1 DELHDF496','B7 PP 837/IP','A3 MHL KC68','A2 FI PP850/2','C4 HDF496','C4 KC 17D','A2 KC18','A3 FLT PP845/1','C9 1457434166','A1 L263','A1 WFF125','C9 H288WK','D1 BP ADG02365','C4 WK 842/2','A2 0450133071','B1 BLPADZ92302','A3 DLP HDF496','C9 WK842/11','C9 FC-L08S','A3 DLP HDF532','A3 MHL KC80','C9 HDF496','A9 WK842/11','C9 FC-H04S','C9 H159WK','A1 KC80','A2 WK724/3','A8 329 279','B1 VAL587700','A1 WK842/2','C4 ELG5258','A1 CS701','C4 WK 842/11 SD','B1 MANWK824/2','A8 366 083','A8 316 960','A2 KC80','C4 WK 724/3','B1 DELHDF532','A9 WK724/3','B1 MANWK842/11','A1 1457434166','A1 0450133070','B1 BOS1457434105','A8 318 853','C9 DN914','A1 WFF245','A8 370 582','B1 BLPADG02365','C4 KC 80','A3 MHL KC17D','C4 F0565DREIS','A5 324888','A5 44111','C4 WK 842/2 (10)','C4 WK 842/11','B1 HENH288WK','C4 WK 824/2','C4 S 8500 NR','C9 1457434105','B1 BOS0450133013','A3 BOS 1457434105','A2 SF PF7123','C9 ADG02365','C4 F0557DREIS','C4 S 4378 NR','A1 30-06-695ASK','A2 UFI 24.351.00','C4 0450133013','C4 S 4414 NR','A8 320 557','A1 F026402094','A2 FI PP845/1','A3 JAP FC-H04S','A9 WK824/2','C4 H70WK02','B7 H288WK','C9 WK842/2','B1 BOSF026402094','A1 1457434320','A3 MNN WK842/11','C4 WK 842/1','C9 ADZ92302','A9 H70WK02','C9 1457434106','A9 UFI 24.394.00','C4 F0381DREIS','A8 318 284','A1 1457434198','A1 J1336039HB','A1 KC102','A1 KC32','A1 KC38','A1 KC43','A1 L111','A1 L120','A1 WFF242','A2 J1330511','A2 J1330514','A2 KC102','A2 KC38','A2 KC43','A2 SF PF7003','A3 KAP HF-638','A3 MHL KC102','A3 MHL KC43','A8 931 627','A9 1457434198','A9 J1330511','A9 J1330514','A9 KC102','A9 KC32','A9 KC38','A9 SF PF7003','B1 BOS1457434198','B1 CHACFF100111','B1 DELHDF570','B1 HP101 460','B1 HP109 045','B1 KAMF300301','B1 KAMF302101','B1 KNEKC18','B1 KNEKC38','B7 ST302','C4 1457434198','C4 J1330511','C4 J1330514','C4 KC 102','C4 KC 38','C9 1457434198','C9 PF-1277','E2 109 045 756')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #