sdg.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 17 SDGs No Poverty Reduced Inequa... Sustainable Ci... Responsible Co... Climate Action... Life Below Wat... Life on Land Peace, Justice... Partnerships f... Zero Hunger Good Health & W... Quality Educati... Gender Equality... Clean Water & S... Affordable & Cl... Decent Work & E... Industry, Innov... Let’s Get the SDGs Back on Track: Insights from Latin America and Asia 1 October 2020 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 (403817) ) 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;-- | 17 SDGs No Poverty Reduced Inequa... Sustainable Ci... Responsible Co... Climate Action... Life Below Wat... Life on Land Peace, Justice... Partnerships f... Zero Hunger Good Health & W... Quality Educati... Gender Equality... Clean Water & S... Affordable & Cl... Decent Work & E... Industry, Innov... Let’s Get the SDGs Back on Track: Insights from ... 1 October 2020 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 (403817) ) 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;-- | 2 SDGs Life Below Wat... Partnerships f... Assessing Baselines and Coordinating Actions for the SDGs Decade of Action 1 October 2020 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 (403827) ) 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;-- | 2 SDGs Life Below Wat... Partnerships f... Assessing Baselines and Coordinating Actions for t... 1 October 2020 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 (403827) ) 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;-- | 2 SDGs No Poverty Partnerships f... The 2030 Agenda as Blueprint for a Post-COVID World 1 October 2020 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 (403722) ) 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;-- | 2 SDGs No Poverty Partnerships f... The 2030 Agenda as Blueprint for a Post-COVID Worl... 1 October 2020 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 (403722) ) pu JOIN wp_usermeta fn ON pu.user_id = fn...