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 RTS95.05949.2','E9 33364','F2 1009352271','A9 12.22.701','A1 WSS126','F4 OPTG5529','A4 116 050 0048/HD','F4 FEB33366','B1 FEB21196','A2 32 92 1196','E9 21196','A3 VAC V10-0789','F2 1001963494','B1 HP107 838','A5 354023','E6 DA1193','C9 935752','C4 VKDS 321034 B','A3 FEB 21196','F2 1001963537','A2 TC769','F2 1011608160','F4 FEB33364','C4 TC769','C9 FE31277','A8 430 373','B1 FEB33366','A9 30 93 1281','B1 FEB31277','A9 32 92 1196','B7 D120011/DKM','C9 FE33364','F4 SKFVKDS321043B','F2 1000243968','A2 32 73 0019','A8 416 347','B1 ABS210048','F4 OPTG5528','F2 1001760159','C4 31277F','A3 RED 6-809','C4 33366F','A3 VAC V10-7011-1','C4 116 050 8299/HDMY','B7 935752','F4 SAS9005154','C4 JTC1313','A3 MON L29528','F4 GSPS060026','F4 SAS7476202','F4 FEB31277','F4 DELTC769','C9 MGZ-101051','E9 11352','F4 JPG1140106170','C4 VKDS 321043 B','F4 TOP107 838','C4 107838HP','C4 116 050 0073/HDMY','A3 TRU 07.30.025','F4 GSPS060055','C9 FE11352','C4 RW8044','E9 31277','B1 ABS210975','A3 TRI 850029580','A5 172918','A3 RED 6-819','C9 1160500048/HD','F4 SAS9005156','F2 1004022426','C4 11352F','F4 VIK44070060301','B7 L29528/MON','C6 014213','C9 1160508299/HD','A3 NKS 5014797','F2 1009352209','F4 FAISS620','A2 TC1956','C6 018046','B1 TRWJTC348','E2 107 838 755','A8 405 675','A5 140757','F2 1001963468','A2 32 73 0018','E9 33366','A3 TRI 850029528','A4 A-519','C9 FE33366','A3 DLP TC1956','A3 MEY 1160500048/HD','E3 A-519','A3 MEY 1160508299/HD','A9 30 93 3366','F4 FEB21196','F4 KAO9050150','F4 COR49398479','A9 S37676','A8 439 538','C9 5014719','C4 TC1956','C9 FE21196','F4 BGATRC0129','F4 COR49399290','C4 116 050 0211MY','A5 34490','B1 FEB11352','B1 RTS95.05985.2','C4 58009611','A5 353979','F4 DELTC1956','F4 SKFVKDS321034B','A2 S37676','F2 1009352210','B1 TRU07.30.025','C4 850029580T','C4 JTC348','C4 07.30.025','C9 5014719PRO','F4 FEB11352','A5 354014','F4 DECD120011','C4 33364F','B1 FEB33364','B1 VKA44070060301','A8 425 644','A2 30 93 3364','B1 MOZL29528','B1 VAI10-0789','C4 850029528T','B1 KAM9050122','F4 SKV04SKV102','A9 JTC348','A9 30 93 1277','A2 30 93 3366','C9 1160500073/HD','C4 21196F','C9 5014797','B1 VAI10-7011-1','A2 JTC348','F2 1000404640','B1 KAM9050150','F4 TOP110 755','A2 12.22.701','A5 231201','A3 MEY 1160500073/HD','A2 30 93 1277','A5 142629','F4 TRWJTC1313','F2 1000827760','C9 935726','B1 FASFT15506','F4 KAO9050122','F2 1001752682','A9 S37072','A3 NKS 5014719','C4 116 050 0048/HDMY','A1 21196 FE','F2 1000951550','A2 S37072','F4 MTC52025','F2 1001963483','C9 1160500211','A3 DLP TC769','F2 1009352270','F4 TRWJTC348','F4 FASFT15506','C9 MGZ-101009','A3 FEB 11352','B1 TRWJTC1313','A5 277389','A2 30 93 1281','F4 FAISS9936','A3 NKS 5014720','B1 OYO30Z9028-OYO','C4 AU-TC-4696','C4 VO-TC-8229','C4 VO-TC-8229P','C9 5014720','F2 1000348696','F4 ABA233-01-111')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #