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