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