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 VAL506488','C4 H9426','B1 VAI10-50041','C9 WPQ1172','A2 VP SK112','C4 H9464','A8 912 127','A2 SPA 1002A','B7 66532','C4 PK05748H','A8 911 543','C4 P536H','C4 WP6027CT','A9 VKMC 01265','B1 CNTWP6059','C4 113 012 0042/HDMY','C9 50005555','A8 925 671','A1 RU65426','A9 506488','C9 DP164','B1 DOLA280','C9 P574','A9 PA758','A2 VKMC 01258-1','C9 65426','B7 538 0045 10','A1 50005555','A9 AIR 9274R','A1 PK05748HEP','B1 SKFVKMC 01271','C9 538004510','A5 42086','C4 VKMC 01271','C9 VKMC01253','C4 VKMC 01270','B1 GRFKP758-1','B1 SKFVKMC 01253','A3 AIS WE-VW04','B7 A310034P/DKM','B1 VAL506488','B1 DOLA178','B1 FEB26429','C9 50005551','B7 1114107919/JP','C4 KP758-1G','A8 911 989','C4 9274RA','A5 256501','A9 538 0045 10','A1 RU65467','A1 VKPC 86620','A1 VKMC 01265','A9 VP SK132','A1 WWP011','C9 VKMC01244','B7 CP7130T/BGA','A2 SPA 1222','A1 VKMC 01270','A3 SKF VKMC01271','A1 506488','C9 PA898','A2 AIR 9274R','A1 VKMC 01258-1','A1 VKMC 01253','A2 538 0045 10','C4 07.19.155','A3 VAC V10-50041','A2 VKMC 01244','B1 INA538049910','C9 VKMC01271','A3 SKF VKMC01270','C4 538004510','A2 506488','C9 1130120042/HD','A3 VAL 506488','C4 07.19.081','A1 50005798','B1 SKFVKMC 01265','A3 VAC V95-50010','B1 MMAWPQ1172','C4 24-0758M','A1 PA758','B1 MMAWPQ1183','A8 912 126','A9 SPA 1222','B1 GRFPA758','B1 PIE7.07152.44.0','C9 50005798','C9 VKPC86619','B1 GRFPA898','C4 P616H','A3 MAR 352316171183','A1 22206 FE','A5 408965','C4 VKMC 01244','C9 5132200004','A3 TRU 07.19.155','A9 VKMC 01253','A3 GRA PA898','A3 NKS 10847035','C9 81701','A1 RU66532','C9 MGC-5467','B1 TRU07.19.155','A3 BGD BSP20042','B1 VAI95-50010','A1 VKMC 01244','C9 WPQ1183','A9 SPA 1002A','A1 VKPC 86619','A9 VKMC 01244','B1 INA538004510','B7 1114103400/JP','B7 A310033P/DKM','A9 VKMC 01270','B1 SKFVKMC 01270','A1 P574HEP','B1 CNTWP6027','B1 HPUP574','A8 314 947','B7 1114110409/JP','B7 1114103409/JP','B1 HPUP536','B7 CP18548/BGA','A1 VKMC 01271','C4 VKPC 86619','C9 MGC-5465','C9 FE22206','A1 PK05747HEP','C4 VKMC 01258-1','B1 HPUP616','A2 VKMC 01270','B1 DOLR303','A3 NKS 10847033','C9 538049910','A3 GRA KP758-1','A2 VKMC 01271','A1 P536HEP','A3 SKF VKMC01258-1','B7 1114107819/JP','C9 7.07152.44.0','A1 AQ-1586','C9 VKMC01270','C4 DP164DY','A1 AQ-1085','C9 VKMC01258-1','A9 VKMC 01271','C9 VKPC86620','A9 VKPC 86620','C9 66532','C9 538007910','C9 FE26429','B7 65467','B1 KAMT0042','A2 VKMC 01265','C4 VKPC 86620','B1 SKFVKMC 01244','A3 GRA PA758','A2 PA898','B1 SKFVKPC 86619','A5 111063','C9 VKMC01265','B1 KAMT0271','A3 SKF VKPC86620','B1 SKFVKMC 01258-1','C9 PA758','C4 860029025T','C4 P574H','A1 PA898','A2 VKPC 86620','A2 VKMC 01253','B1 HPUPK05748','B7 1114103300/JP','C4 PA758G','A9 VKMC 01258-1','C4 22206F','A3 SKF VKMC01253','A2 PA758','A8 917 402','B7 65426','A1 WP6408','A9 VKPC 86619','A3 SKF VKMC01265','A1 WP6065','A2 VP SK132','A3 SKF VKPC86619','A1 P616HEP','A8 305 762','B7 WP0424','A1 KP758-1','C9 1130120042','A8 332 585','A2 VKPC 86619','A1 26429 FE','A5 359864','A3 TRU 07.19.081','B1 SKFVKPC 86620','A4 113 012 0042','A3 SKF VKMC01244','B7 WP0289','A1 538 0045 10','B7 1114110309/JP','A5 427280','C9 P536','B1 FEB22206','B7 538 0499 10','B7 A310033/DKM','B7 CP13420/BGA','A3 MON L24540','C4 815029115T','C4 850024540T','C9 815029115')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #