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