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 ('A3 RUV 985451','A8 451 313','A3 TRU 07.32.051','B1 VAI10-0798','A1 TD843W','A3 RUV 985444','A9 42.37.741','A3 TRU 07.31.229','C4 100 610 0008MY','B1 FAG829043110','C4 100 710 0035MY','B1 KAM8800441','B1 FAG829010310','A1 26573 FE','C9 00725611','C4 108148HP','A1 F8-5303','C9 985444','C9 5104731','B7 985444','C9 MGZ-501020','A3 DLP TD843W','A1 TD605W','A1 33725 FE','C9 5104796','B1 FEB26573','B7 1140205800/JP','B1 HP108 148','B1 TED00725611','B1 KAM8800490','B1 SAS2256067','C4 VKDS 331017','C4 TD843W','B1 SAS2256065','A5 353883','B1 VAI10-6071','B7 510359/GSP','A2 30 93 3725','A3 NKS 5104783PRO','A1 863625 SID','A8 432 841','B7 D300145/DKM','B1 TRWJBU450','C4 VO-SB-4452','C9 MGZ-501039','B1 MOZL29C47','A3 NKS 5104731','C4 07.32.106','A3 MOG VO-SB-2318','A2 AK.23333','B7 829 0431 10','A9 30 60 0026','A3 TRI 850029879','A8 458 027','A1 F8-6707','B1 TRU07.31.229','B1 GSP510359','B1 FEB33725','A8 441 253','A1 RU985451','A2 S863640','A3 COR 80005460','A3 MON L29879','A1 TD502W','B1 ABS270842','E2 108 148 755','A9 S864611','B1 GSP516063','A4 100 407 0053','B7 D300030/DKM','A8 410 563','A1 JBU450','A3 VAC V10-6071','C9 2256050','A3 MOG VO-SB-5623','A2 MYL 100 710 0035','A3 DLP TD605W','A1 WRM1121','A8 482 429','A1 VO-SB-5623','A2 TD843W','A2 30 92 6573','B7 829 0103 10','C4 JBU450','A3 FEB 26573','B1 RTS017.00903','B7 52031408/MTZ','A2 42.37.741','C9 1004070053','C4 VO-SB-5623','A3 COR 80001280','A8 461 076','B1 KAM8800114','A2 MYL 100 610 0008','B1 RTS017.00185','C4 850029824T','C4 52006708','B1 GSP510159','C4 100 407 0053MY','B1 GSP516090','B7 1140203500/JP','A9 30 93 3725','B1 HP112 006','B1 SAS2256050','A3 FEB 05290','A1 RU985444','C9 1007100035','B7 00725611/IP','C9 FE26573','A9 MYL 100 610 0008','C4 52031408','A5 59345','C9 FE05290','A3 VAC V10-0798','C9 5104783','B1 FEB05290','A9 30 92 6573','A5 211054','C4 DSS2063DY','C4 05290F','C6 019138','C4 52005908','C9 5104783PRO','C9 FE33725','A8 429 547','C9 829030310','C4 33725F','C9 1006100011','C4 DSS2192DY','B7 829 0303 10','B7 T406593/STC','B1 MOZL29879','B1 TRU07.32.051','A8 433 079','A3 NKS 5104783','A3 VAC V10-1379','A9 TD605W','A1 863640 SID','C4 TD605W','A1 829 0103 10','C4 100 610 0011MY','A9 MYL 100 710 0035','A3 MOG VO-SB-4452','C9 108148CN5','B1 ABS270647','A2 S864611','A1 5290 FE','A5 501610','B1 VAI10-1379','A8 445 793','A2 TD502W','B1 VKA44071707101','B7 T405414/STC','A8 448 101','B7 T404305/STC','C4 TD502W','B1 FAG829030310','C4 VKDS 331049','C4 07.32.051','A8 416 531','C4 VKDS 339000','A2 S863625','C9 985451','A1 F8-4039','B7 1140203200/JP','A3 DLP TD502W','A1 864611 SID','A2 30 60 0026','C9 829010310','C9 1006100008','A1 WRM235','A1 VO-SB-2318','A3 NKS 5104796','C4 26573F','B1 MOZL29824','C4 VO-SB-2318','A2 JBU450','A9 TD502W','E2 111 468 755','A9 S863625','B7 985451')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #