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