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 ('A2 80.55.700','B1 MOZL10830','C9 985239','B1 ABS210931','C9 MGZ-110013','C4 716 610 0004MY','C9 MGZ-414012','B1 FAG821072210','A8 483 198','C9 MGZ-114005','C4 VKDS 324003 B','B1 FAG821062310','A1 RU985239','C9 00396625','B1 ABS211107','B1 GSP516567','B1 FAG821078510','A9 TD652W','C9 00226623','A8 470 240','B7 T405344/STC','A8 445 509','C9 850050531','C9 MGZ-405011','C9 829031110','B7 00746626/IP','C4 514 610 0003MY','B7 829 0311 10','A2 20.47.700','A2 S867617','A2 TD652W','A1 JBU747','B1 FAG829031210','A8 445 510','A3 NKS 5102535','A3 VAC V25-0834','B1 KAM9040028','A9 20.47.701','C4 VKDS 324058 B','C4 VKDS 814009','C4 DSS1166DY','B7 D120294/DKM','C9 829031210','C4 VKDS 334010','B1 VAI25-0834','C4 829031110','A9 20.47.710','A9 20.47.711','B1 GSP514447','B1 FAG821072110','C9 MGZ-414016','C9 QS4527/HQ','C9 QS7106/HQ','C4 VKDS 314027','B1 KAM9040168','B7 D300169/DKM','C9 00226628','C4 VKDS 334024','B1 ABS210932','C4 DSS2395DY','C4 DSS2187DY','B7 D300170/DKM','B1 TED00226628','B7 1540300600/JP','B1 ABS211326','C9 MGZ-405019','C9 MGZ-105027','A8 452 579','C4 850050531T','B1 FAG821089810','A8 425 798','B1 HP304 029','C9 7166100005','A8 483 197','B1 FAG821090110','B1 ABS211191','C4 VKDS 324027 B','B1 KAM8800457','B7 1540100670/JP','C9 QS0856/HQ','C4 DSS2968DY','B1 KAM9050287','C4 JBU747','C4 850010830T','B7 985239','C4 DSS1053DY','A3 DLP TD652W','A9 80.55.701','A8 435 148','B1 MOZL50815','B1 FAG821061710','A1 867617 SID','A2 AK.230301','B1 KAM9040029','C9 MGZ-405018','A2 20.47.701','C4 VKDS 324002 B','C4 JBU660','A9 80.55.700','C9 MGZ-505017','A9 JBU660','C4 TD652W','C9 MGZ-110014','B1 KAM9040112','B1 VAI95-0314','B1 TRWJBU660','B1 FAG821078610','A9 S867617','C4 VKDS 314026','C9 5102535','A3 NKS 5104831','B7 00228493/IP','C9 MGZ-505016','A9 20.47.700','B1 ABS211192','C9 MGZ-405012','A9 20.47.703','B7 00226623/IP','A2 20.47.702','A5 188303','B1 TED00396625','A1 TD652W','B1 GSP517914','C9 5104831','C4 VKDS 324059 B','A8 461 094','B1 RTS017.90618','C4 52011708','C4 716 610 0005MY','C4 DSS3039DY','A2 80.55.701','A8 461 458','C4 DSS3040DY','A5 354221','B1 KAM9050286','B7 1540100680/JP','A1 829 0311 10','B1 ABS211325','A9 20.47.702','C4 VKDS 324026 B','B1 SAS2256020','C9 7166100004','A2 50 92 7912','B7 00226628/IP','C9 MGZ-105028','B1 KAM8800458','A2 JBU660','B1 FAG829031110','C9 5146100003','A9 50 92 7912','A2 20.47.744','A1 JBU660','B1 TED00746626','B1 RTS017.00697','C4 VV-SB-3647','B1 TED00220109','A1 829 0312 10','B1 TRWJBU747','A1 VV-SB-3647','B7 D120293/DKM','A2 20.47.703','B1 GSP516436','B7 T405343/STC','C4 DSS1162DY','A2 20.47.711','A1 3184 SID','A2 20.47.710','C9 00228493','C9 MGZ-114006','A3 MOG VV-SB-3647','B1 TED00226623','A1 JTC1244','A3 LEM 3370601','A3 NKS 5012562','A3 NKS 5012563','A3 NKS 5012571','A3 NKS 5012572','A3 NKS 5013225','A3 NKS 5042526','A3 NKS 5102536','A3 NKS 5102536PRO','A5 86493','A8 439 880','A9 3370601','A9 JTC1244','B1 LMI33706 01','B1 TRWJTC1244','C4 33706 01','C4 52011818','C4 58038702','C4 58038801','C4 58042902','C4 58043001','C4 58051202','C4 58051301','C4 58077202','C4 58077301','C4 JTC1244','C9 5012562','C9 5012563','C9 5012571','C9 5012572','C9 5013225','C9 5042526','C9 5102536','C9 LMI33706')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #