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 F8-7468','A8 417 334','A4 721 070 755','A5 38967','A1 814 0118 10','A8 477 017','C9 671910','A8 441 247','A9 SA801 037','A2 62 54 0012','A2 KYBMB1905','C4 VKD 35017','A1 WSM137','A3 FEB 12028','C9 FE12028','A3 FEB 12030','A8 404 213','A1 801037','A2 62 55 0007','C9 825820','B1 HP721 205','A1 RU825891','C9 MA-7488','C9 VKD35017T','A5 127950','A2 MONMK047','B1 HUT594182','A9 KYBMB1905','C9 0355395','B7 865806','B1 SNRM259.05','A1 814 0158 10','C9 72-2603','A9 VKD 35017 T','A3 HUT 590120','A1 814 0117 10','A2 VKD 35017 T','C4 12028F','B1 VAI22-0306','C9 72-3411','B1 HUT590120','B1 FEB12031','B1 MONMK148L','A8 405 576','A9 VKDA 35321 T','C4 VKDA 35313 T','A3 FEB 12031','C4 6490190','A1 RU825820','C4 47319F','B1 GSP510730','A2 AK.7488','B1 FEB47319','A1 MMK148L','B7 825890','B1 FAG814011710','A8 405 575','A3 VAC V42-0145','A1 12028 FE','A8 460 328','A3 COR 80001632','A1 M259.05','A8 477 008','C4 12031F','A9 AK.15336','B1 SKFVKDA 35313 T','C4 814011710','A1 12027 FE','B1 SAS0355395','B7 MK047/MON','B1 RUV865806','A8 415 348','B1 FAG713040020','C4 850010907T','C9 VKDA35313T','C9 VKDA35321T','C4 VKD 35017 T','C9 0385285','B1 SKFVKD 35017 T','B7 T405974/STC','A8 435 000','A3 MOG CI-SB-9684','B7 T404570/STC','A2 KBLF41116','C4 11-14 641 1001MY','A8 438 639','A5 250727','A3 SKF VKDA35321T','A9 VKDA 35313 T','A3 VAC V42-0506','A1 RU865806','A3 HUT 594182','C9 11-146410001','A3 MAR 030607010006','B1 FAG814011810','A9 SA802 164','B1 MONMK047','A1 47319 FE','C9 11-146410001/S','C9 801 037','A1 VKDA 35313 T','B1 SAC802 406','C9 KYBMB1905','A3 NKS 661903','A2 AK.15386','A8 900 840','A8 480 203','C9 72-3219','B7 T404182/STC','A1 VKDA 35321 T','C9 72-3526','A8 481 371','A1 713 0400 20','C4 801 023S','A5 14976','C4 814011810','C4 88-723-L','A8 455 620','C9 713040020','C4 850010902T','B1 KYBMB1905','A1 12030 FE','A8 440 494','B1 HUT594183','C9 802 164','C4 6490174','A1 F8-6306','C9 11-146410016','A1 801023','C9 0385185','A9 AK.7488','A1 F8-6611','C4 814015810','E2 721 070 755','A9 AK.15386','A1 VKD 35017 T','A9 VKD 35017','A8 434 277','A8 405 802','B1 SKFVKDA 35321 T','A3 JAP SM0157','A1 VKD 35017','C9 FE12027','B1 COR80000480','A1 MMK047','C4 MB1905K','A3 HUT 594183','B7 T402918/STC','B1 FEB12028','A3 JAP SM0161','C9 12-248957','A3 MON MK148L','B7 825820','C4 12027F','C9 801 023','C4 MK047MON','C9 0385195','A5 91851','C9 72-2105','E3 11-14 641 0004','C9 825891','B7 814 0158 10','A9 MONMK047','B1 FAG814015810','A1 KYMB1905','A3 SKF VKD35017T','B7 713 0400 20','C9 72-2606','A2 AK.15336','A2 VKDA 35321 T','C4 VKDA 35321 T','A2 SA802 164','A9 KBLF41116','B1 FEB12027','A1 RU825890','A3 COR 80000480','C9 11-146410004','A3 SKF VKDA35313T','A1 802406','A2 VKDA 35313 T','A2 SA801 023','A9 SA802 406','C9 FE47319','A1 F8-3023','B7 825891','C9 MA-15386','C9 865806','B1 SAS0385195','A1 12031 FE','A2 62 55 0011','B1 SAS0385285','C4 801 037S','A2 VKD 35017','A8 410 592','A3 SKF VKD35017','C9 825890','C9 FE12030','C4 850010901T','C4 802 406S','A2 SA802 406','B1 SAS2650034','A1 F8-5353','A5 195816','A1 F8-8066','A8 410 593','A3 MON MK047','B1 SNRKBLF41116','A1 F8-5354','B1 VAI42-0145','A2 62 54 0009','B1 SKFVKD 35017','B7 510730/GSP','A8 440 495','B1 FEB12030','A8 480 604','C4 850010919T','C9 72-2137','C4 713040020','B1 VAI42-0506','A3 FEB 12027','A2 SA801 037','A8 480 000','C9 VKD35017','A9 62 54 0012','C4 802 164S','A1 802164','C9 11-146411001','B1 SAS0385185','A9 62 55 0007','A3 JAP SM0162','C9 802 406','C4 12030F','A1 MMK308R','A2 KYBSM1920','A2 KYBSM1921','A9 KYBSM1920','A9 KYBSM1921','B1 KYBSM1920','B1 KYBSM1921','C4 MK308RMON','C4 SM1920K','C4 SM1921K','C9 KYBSM1920','C9 KYBSM1921')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #