climate-l.iisd.orgSDG Knowledge Hub | Daily SDG News | IISD

facebook googleplus pinterest twitter quote chevron chevron-small search close_x close menu SDG Knowledge Hub A project by IISD NEWS COMMENTARY GUEST ARTICLES POLICY BRIEFS GENERATION 2030 EVENTS ACTORS REGIONS SDGs SDG Knowledge Hub Select a goal to start exploring the 2030 Agenda for Sustainable Development MORE 874 news 134 guest articles 874 policy briefs 874 events featured Partnerships for the Goals Transforming Private Sector Contributions to the Decade of Action: Evolving North-South Partnerships 16 March 2021 0 THEN 4 ELSE u.ID END AS user_id , u.user_email AS user_email , CASE WHEN u.user_nicename LIKE '%-account' THEN '' WHEN LEFT(u.user_login,2) = 'z_' OR u.ID=64 THEN 'guest-authors' ELSE 'thematic-experts' END AS user_link_role , CASE WHEN u.user_nicename LIKE '%-account' THEN '' ELSE u.user_nicename END AS user_link_slug , p.pid, p.uid FROM wp_2_posts_authors p JOIN wp_users u ON u.ID=CASE WHEN FIND_IN_SET(p.post_author,'228,8,9,22,421,373') 0 THEN 4 ELSE p.post_author END WHERE p.ID IN (407047) ) pu JOIN wp_usermeta fn ON pu.user_id = fn.user_id JOIN wp_usermeta ln ON pu.user_id = ln.user_id JOIN wp_usermeta dl ON pu.user_id = dl.user_id JOIN wp_usermeta ur ON pu.user_id = ur.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'description_short') ds ON pu.user_id = ds.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_prefix') px ON pu.user_id = px.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_suffix') sx ON pu.user_id = sx.user_id WHERE fn.meta_key = 'first_name' AND ln.meta_key = 'last_name' AND dl.meta_key = 'description' AND ur.meta_key = 'wp_capabilities' ORDER BY pu.pid DESC, pu.uid ASC;-- | Partnerships for the Goals Transforming Private Sector Contributions to the D... 16 March 2021 0 THEN 4 ELSE u.ID END AS user_id , u.user_email AS user_email , CASE WHEN u.user_nicename LIKE '%-account' THEN '' WHEN LEFT(u.user_login,2) = 'z_' OR u.ID=64 THEN 'guest-authors' ELSE 'thematic-experts' END AS user_link_role , CASE WHEN u.user_nicename LIKE '%-account' THEN '' ELSE u.user_nicename END AS user_link_slug , p.pid, p.uid FROM wp_2_posts_authors p JOIN wp_users u ON u.ID=CASE WHEN FIND_IN_SET(p.post_author,'228,8,9,22,421,373') 0 THEN 4 ELSE p.post_author END WHERE p.ID IN (407047) ) pu JOIN wp_usermeta fn ON pu.user_id = fn.user_id JOIN wp_usermeta ln ON pu.user_id = ln.user_id JOIN wp_usermeta dl ON pu.user_id = dl.user_id JOIN wp_usermeta ur ON pu.user_id = ur.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'description_short') ds ON pu.user_id = ds.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_prefix') px ON pu.user_id = px.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_suffix') sx ON pu.user_id = sx.user_id WHERE fn.meta_key = 'first_name' AND ln.meta_key = 'last_name' AND dl.meta_key = 'description' AND ur.meta_key = 'wp_capabilities' ORDER BY pu.pid DESC, pu.uid ASC;-- | 7 SDGs Responsible Co... Climate Action... Life on Land Good Health & W... Quality Educati... Gender Equality... Industry, Innov... Europe Debuts Anticipated Progress Index to Measure SDG Advances, Shortfalls 16 March 2021 0 THEN 4 ELSE u.ID END AS user_id , u.user_email AS user_email , CASE WHEN u.user_nicename LIKE '%-account' THEN '' WHEN LEFT(u.user_login,2) = 'z_' OR u.ID=64 THEN 'guest-authors' ELSE 'thematic-experts' END AS user_link_role , CASE WHEN u.user_nicename LIKE '%-account' THEN '' ELSE u.user_nicename END AS user_link_slug , p.pid, p.uid FROM wp_2_posts_authors p JOIN wp_users u ON u.ID=CASE WHEN FIND_IN_SET(p.post_author,'228,8,9,22,421,373') 0 THEN 4 ELSE p.post_author END WHERE p.ID IN (407040) ) pu JOIN wp_usermeta fn ON pu.user_id = fn.user_id JOIN wp_usermeta ln ON pu.user_id = ln.user_id JOIN wp_usermeta dl ON pu.user_id = dl.user_id JOIN wp_usermeta ur ON pu.user_id = ur.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'description_short') ds ON pu.user_id = ds.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_prefix') px ON pu.user_id = px.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_suffix') sx ON pu.user_id = sx.user_id WHERE fn.meta_key = 'first_name' AND ln.meta_key = 'last_name' AND dl.meta_key = 'description' AND ur.meta_key = 'wp_capabilities' ORDER BY pu.pid DESC, pu.uid ASC;-- | 7 SDGs Responsible Co... Climate Action... Life on Land Good Health & W... Quality Educati... Gender Equality... Industry, Innov... Europe Debuts Anticipated Progress Index to Measur... 16 March 2021 0 THEN 4 ELSE u.ID END AS user_id , u.user_email AS user_email , CASE WHEN u.user_nicename LIKE '%-account' THEN '' WHEN LEFT(u.user_login,2) = 'z_' OR u.ID=64 THEN 'guest-authors' ELSE 'thematic-experts' END AS user_link_role , CASE WHEN u.user_nicename LIKE '%-account' THEN '' ELSE u.user_nicename END AS user_link_slug , p.pid, p.uid FROM wp_2_posts_authors p JOIN wp_users u ON u.ID=CASE WHEN FIND_IN_SET(p.post_author,'228,8,9,22,421,373') 0 THEN 4 ELSE p.post_author END WHERE p.ID IN (407040) ) pu JOIN wp_usermeta fn ON pu.user_id = fn.user_id JOIN wp_usermeta ln ON pu.user_id = ln.user_id JOIN wp_usermeta dl ON pu.user_id = dl.user_id JOIN wp_usermeta ur ON pu.user_id = ur.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'description_short') ds ON pu.user_id = ds.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_prefix') px ON pu.user_id = px.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_suffix') sx ON pu.user_id = sx.user_id WHERE fn.meta_key = 'first_name' AND ln.meta_key = 'last_name' AND dl.meta_key = 'description' AND ur.meta_key = 'wp_capabilities' ORDER BY pu.pid DESC, pu.uid ASC;-- | Partnerships for the Goals Afghanistan, Niger, Saudi Arabia Join 2021 VNR Countries 16 March 2021 0 THEN 4 ELSE u.ID END AS user_id , u.user_email AS user_email , CASE WHEN u.user_nicename LIKE '%-account' THEN '' WHEN LEFT(u.user_login,2) = 'z_' OR u.ID=64 THEN 'guest-authors' ELSE 'thematic-experts' END AS user_link_role , CASE WHEN u.user_nicename LIKE '%-account' THEN '' ELSE u.user_nicename END AS user_link_slug , p.pid, p.uid FROM wp_2_posts_authors p JOIN wp_users u ON u.ID=CASE WHEN FIND_IN_SET(p.post_author,'228,8,9,22,421,373') 0 THEN 4 ELSE p.post_author END WHERE p.ID IN (407035) ) pu JOIN wp_usermeta fn ON pu.user_id = fn.user_id JOIN wp_usermeta ln ON pu.user_id = ln.user_id JOIN wp_usermeta dl ON pu.user_id = dl.user_id JOIN wp_usermeta ur ON pu.user_id = ur.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'description_short') ds ON pu.user_id = ds.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_prefix') px ON pu.user_id = px.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_suffix') sx ON pu.user_id = sx.user_id WHERE fn.meta_key = 'first_name' AND ln.meta_key = 'last_name' AND dl.meta_key = 'description' AND ur.meta_key = 'wp_capabilities' ORDER BY pu.pid DESC, pu.uid ASC;-- | Partnerships for the Goals Afghanistan, Niger, Saudi Arabia Join 2021 VNR Cou... 16 March 2021 0 THEN 4 ELSE u.ID END AS user_id , u.user_email AS user_email , CASE WHEN u.user_nicename LIKE '%-account' THEN '' WHEN LEFT(u.user_login,2) = 'z_' OR u.ID=64 THEN 'guest-authors' ELSE 'thematic-experts' END AS user_link_role , CASE WHEN u.user_nicename LIKE '%-account' THEN '' ELSE u.user_nicename END AS user_link_slug , p.pid, p.uid FROM wp_2_posts_authors p JOIN wp_users u ON u.ID=CASE WHEN FIND_IN_SET(p.post_author,'228,8,9,22,421,373') 0 THEN 4 ELSE p.post_author END WHERE p.ID IN (407035) ) pu JOIN wp_usermeta fn ON pu.user_id = fn.user_id JOIN wp_usermeta ln ON pu.user_id = ln.user_id JOIN wp_usermeta dl ON pu.user_id = dl.user_id JOIN wp_usermeta ur ON pu.user_id = ur.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'description_short') ds ON pu.user_id = ds.user_id LEFT JOIN (SELECT * FROM wp_usermeta WHERE meta_key = 'user_prefix') px ON pu.user_id = px.user_id LEFT JOIN (SELECT * FROM wp_u...