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 94774-DY','A9 GAT KP65323XS','C9 VKPC86620','A2 VKMC 01271','A1 RU55446701','C4 RL368965770','B1 DOLA178','C4 CT939','C9 VKM11257','A9 VKMC 01271','A1 RU55446711','A1 VKPC 86619','A1 531 0342 30','B1 SKFVKMC 01270','A5 125804','C4 VKM 11257','A3 SKF VKPC86619','A2 GAT KP15323XS','A1 RU65426','A5 116182','A3 HUT 122AH26','B7 55446711','B1 INA531034230','C9 94774','C9 1987949452','A1 WP6065','A1 1987949452','B7 CT939/AG','A5 427280','C4 VKPC 86619','B1 HP101 575','A1 VKPC 86620','B1 VAL506488','B1 BOS1987949452','C9 1130120015','A1 RU5547770','A3 GAT T43067','A1 530 0173 30','C9 VAL506488','A1 CT939','A2 VKM 11073','A9 VKPC 86619','C4 PA758G','C9 GAT5323XS','C4 5323XS','C9 GATKP15323XS','B7 530 0175 10','C9 VKPC86619','A2 GAT 5323XS','A9 531 0342 30','A2 SPA 1222','A3 GAT KP65323XS','A8 313 651','A3 SKF VKMC01271','A9 AIR 9274R','A9 506488','C9 55477','B7 55446701','B1 GATT43067','A1 VKMC 01271','A3 INA 531034230','B7 531 0342 30','B1 INA530017330','A1 50005555','C9 5547770','B7 530 0173 30','A3 SKF VKM11257','B7 CP13420/BGA','C4 VKMC 01270','B1 GATKP15323XS','C9 1130120042','A9 1987949452','A2 AIR 9274R','C9 530017510','C4 860029025T','A9 530 0173 30','A9 GAT KP15323XS','C4 24-0758M','C4 KP15323XS','A1 VKMC 01270','A8 305 762','A4 113 012 0015','B7 65426','B1 GATKP65323XS','C9 55446','A9 DAY 94774','A9 0CT939','C4 H9464','B7 55446721','B1 SKFVKM 11073','A9 VKPC 86620','A9 0CT939WP2','C9 PA758','C9 GATKP65323XS','A2 VKPC 86620','B7 55446','C9 81701','A2 531 0342 30','A9 VKM 11257','C9 1132200022','B1 TRU07.19.155','B1 SKFVKPC 86619','B1 SKFVKPC 86620','A2 GAT KP65323XS','A3 GRA PA758','C4 530017510','C4 530017330','A3 GRA PA593A','A1 506488','A9 PA758','C9 VKM11073','C4 VKM 11073','C4 531034230','A2 PA758','A2 1987949452','A3 SKF VKPC86620','B7 5547770','A1 RU65467','B1 SKFVKM 11257','A8 357 153','A2 VKM 11257','A2 506488','C9 530017330','B7 55477','A5 38663','C9 50005551','A1 KP65323XS','B1 MMAWPQ1183','A9 SPA 1222','C4 H9426','A1 5323XS','B7 WP0289','A2 GAT T43067','A2 DAY 94774','A1 RU55446721','A9 VKMC 01270','C9 5132200004','A8 907 082','A1 WP6408','A1 PA758','A2 VKMC 01270','C9 MGC-5467','A3 NKS 10847033','C4 CT939WP2','A3 SKF VKMC01270','B1 GAT5323XS','A3 DAY 94774','A5 42086','A8 907 080','B1 HUT122 AH 26','B1 DOLA280','A1 RU55446','A4 113 012 0042','B1 GRFPA758','C4 07.19.081','A2 0CT939','C4 VKMC 01271','A2 530 0173 30','B1 SNRGT365.04','A3 MAR 352316171183','A1 VKM 11073','C9 CT939WP2','A2 0CT939WP2','B1 CNTCT939','A1 AQ-1085','A1 CT939WP2','A3 OPB ZRK1301','C4 94774DY','C9 VKMC01270','C9 55446711','A8 314 947','A2 530 0175 10','A8 376 197','C9 55446721','A3 TRU 07.19.155','C4 VKPC 86620','C4 07.19.155','A1 KP15323XS','A3 GAT 5323XS','A3 VAC V10-50041','B1 SKFVKMC 01271','A9 530 0175 10','B7 A310033/DKM','B7 CT939WP2/AG','A3 SKF VKM11073','B7 65467','A3 BGD BSP20042','C9 50005555','B7 CP18548/BGA','A3 BOS 1987949452','A3 VAL 506488','A2 VP SK132','C9 531034230','C9 CT939','A3 TRU 07.19.081','A9 GAT T43067','C9 VKMC01271','A2 VKPC 86619','A5 274958','B1 INA530017510','C9 WPQ1183','A3 GAT KP15323XS','A8 322 854','C9 55446701','B1 CNTCT939WP2','A1 RU55477','A1 0CT939','C9 65426','A1 530 0175 10','A8 300 720','B1 VAI10-50041','A9 GAT 5323XS','C4 9274RA','A5 64683','A8 358 357','A9 VP SK132','A1 22206 FE','A1 WWP011','B1 FEB22206','C4 22206F','C9 FE22206')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #