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