SELECT * FROM npru_sdg_news AS A INNER JOIN npru_sdg_tag AS B ON A.npru_sdg_news_id = B.npru_sdg_id WHERE B.npru_sdg_tag LIKE 'SDG17-%' GROUP BY A.npru_sdg_news_id ORDER BY B.npru_sdg_priority DESC