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 KC373','C9 FE17660','A9 FI PP837','A3 MNN WK724/3','A3 MNN WK842','A1 1457434320','A2 UFI 24.351.01','A1 WK8051','B7 30L08/JAPKO','A2 0451103101','C4 H70WK02','C9 2123190001','B1 FEB17660','A9 KC38','A9 WK8051','B1 KAMF106701','B1 VAI10-0340-1','B1 VAL587742','A9 CU2951','B1 MANWK724/3','C9 WK842','A1 WK842/2','B1 KNEKC43','C9 50013075','B7 PP 968/5/IP','A8 370 582','A3 BOS 1457434105','A3 FLT PP845/1','A9 SF OF0078','C4 WK 842','A2 UFI 24.394.00','C9 WK724/3','A1 H70WK02','C9 PF-966','A3 JAP FC-695S','A3 MHL KC38','B1 VAI24-0312','C9 KC18','A3 MHL KC373','B1 HENH70WK02','A8 914 101','C9 H70WDK13','A1 WK716/2X','C4 S 4394 NR','A5 80419','A3 MNN CU2951','C4 KC 68','B7 PP 837/IP','C9 DO232','C9 DN301','A3 TRU 04.18.006','C4 S 8500 NR','B1 KNEKC102','B1 VAI40-0127','C9 DN919','A5 324888','C4 KC 487','C4 1457434105','C9 1457434105','A3 DLP HDF496','A1 1457434422','C9 DO223','A1 J1336039HB','C4 ELG5214','A2 KC68','A2 WK842','B7 H70WK','B1 MANWK8051','A1 30-06-695ASK','C4 0451103101','A8 371 110','C4 H70WK','A1 WFF934','B1 KNEKC32','B1 BOS1457434105','A2 WK8051','A9 WK842/2','A2 H70WK02','A1 WK724/3','B7 PP845/1/AG','C9 FC-L08S','C9 71760560','A1 KC487','B1 VEM24-30-1101','A8 373 621','B1 KAMF300301','A1 WFF101','A3 BOS 1457434320','C4 S 4529 NR','C9 F026402094','A1 KC68','B1 HENH699WK','C4 KC 43','A3 MNN WK842/2','A1 F026402176','A9 F026402176','A9 0451103101','B7 M110046/DKM','A2 UFI 24.529.00','A3 BOS F026402127','A2 KC17D','B1 KNEKC68','A1 KC17D','B1 TRU04.18.006','A9 SF PF7003','A1 F026402094','A8 331 275','A2 FI PP968/5','B1 KNEKC38','C9 50013001','A2 H70WK','A1 KC18','A3 FLT PP968/5','A9 FI PP845/1','C4 KC 373','C4 KC 18','C4 WK 716/2 X','C4 KC 17D','A3 MHL KC487','A2 CU2951','A2 UFI 24.378.00','C9 71758006','C4 F026402094','A2 FI PP845/1','C4 17660F','A1 WFF169','A2 WK842/2','C4 F0565DREIS','A9 KC487','C9 PF-5180','A2 KC43','C4 F026402127','B7 30695/JAPKO','A1 1457434105','C9 DO271','A1 WFF201','B7 PP 845/1/IP','B1 VAL587733','A9 KC68','A1 CU2951','B1 CHACFF100111','C9 1001270005','B1 HENH70WK','A5 372184','A1 30-0L-L08ASK','A2 KC487','A9 UFI 24.351.00','C9 101460IT6','A8 327 958','C9 CU2951','A2 1.12120','A1 KC38','A3 VAC V24-0312','A8 366 059','C9 WK716/2X','B1 FTRPP968/5','A1 F026402127','A3 BOS F026402094','B1 BOSF026402127','A2 UFI 24.351.00','A3 FLT PP837','B1 BOSF026402176','A3 MNN WK716/2X','B1 HP101 460','A1 WFF245','C4 S 4378 NR','B7 PP837/AG','B7 A120271/DKM','A2 F026402176','A8 300 158','B1 FTRPP845/1','C4 CU 2951','A8 318 284','E2 101 460 756','B1 DELHDF496','A9 WK724/3','C9 WK8051','A3 VAC V40-0127','C9 H70WK','A1 L111','A5 148916','A3 JAP FC-L08S','B1 VAL587700','A1 WK842','B1 MANWK842','B1 KNEKC373','A1 0451103101','B1 BOS0451103101','C4 WK 8051','C4 J1336038','A8 320 557','A2 SF OF0078','C9 DN323','B1 MANWK716/2X','A9 H70WK02','A3 MHL KC18','A8 300 149','C9 FC-695S','A2 40 91 7660','A2 1457434105','B1 KAMF302001','C9 H70WK02','B1 KNEKC18','A2 WK724/3','C4 WK 842/2','B7 H70WK02','B7 PP968/5/AG','A1 FT5240','A2 WK716/2x','C9 WK842/2','A2 J1336038','A2 F026402127','A9 WK716/2x','C4 P550588','A2 SF PF7003','C4 WK 842 SD','C4 HDF496','C9 71760647','B7 ST353','A9 UFI 24.529.00','A9 KC17D','A9 UFI 24.351.01','A1 CS490','C4 WK 724/3','C4 S 8501 NR','A2 KC38','C9 F026402176','A2 FI PP837','B7 ST302','A3 DLP HDF601','A2 KC18','A3 MHL KC68','B7 SM102','A1 17660 FE','C4 WK 842/2 (10)','B7 1118702400/JP','A1 CS490PU','C4 F0555DREIS','A2 F026402094','A9 UFI 24.394.00','C9 CS490','A8 909 052','C9 PF-1370','B1 KNEKC18/1','B1 PURCS490','A9 UFI 24.378.00','B7 WK842/2/AG','A1 KC43','C4 KC 38','B1 MANCU2951','C9 SP-966','B1 BOSF026402094','A9 KC18','A1 FP5493/A','C9 HDF496','C9 F026402127','A9 WK842','A9 H70WK','C4 CFF100111','A3 MHL KC43','A2 0S 8501 NR','C9 0451103101','B7 A120002/DKM','C9 SP-1370','A3 BOS 0451103101','A3 MHL KC17D','B1 KAMF315501','B1 FTRPP837','B1 MANWK842/2','A8 931 627','C4 F0381DREIS','A1 H70WK','C9 101460756','A3 VAC V10-0340-1','C6 100849','A1 HDF496D','C9 FC-H04S','A1 CS701PU','A5 80413','A8 315 273','B1 PURCS701','A3 JAP FC-H04S','D2 PP837')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #