1 ----------- ERROR : ------------
ERROR: SELECT indicator_def, cat_id, per_capita FROM uneplive_replica.indicators WHERE indicator_id = mpx_2


1 ----------- ERROR : ------------
ERROR: SELECT uneplive_replica.source.source_name, uneplive_replica.source.source_url, uneplive_replica.orgs.org_short FROM uneplive_replica.indicators JOIN uneplive_replica.source ON uneplive_replica.indicators.source_id = uneplive_replica.source.source_id JOIN uneplive_replica.orgs ON uneplive_replica.orgs.org_id = uneplive_replica.source.org_id WHERE indicator_id = mpx_2


1 ----------- ERROR : ------------
ERROR: SELECT REPLACE(REPLACE(REPLACE(country_name, '(MDG=M49)', ''), 'M49 group:', ''), '(M49)', ''), a.data_value, t.year_start FROM uneplive_replica.time_id AS t JOIN uneplive_replica.agg_data AS a ON t.time_id = a."time_ID" JOIN uneplive_replica.country AS c ON c.country_id = a.country_id WHERE a.country_id = 1 AND a."Indicator_ID" = mpx_2 ORDER BY t.year_start, a.country_id


1 ----------- ERROR : ------------
ERROR: SELECT REPLACE(REPLACE(REPLACE(country_name, '(MDG=M49)', ''), 'M49 group:', ''), '(M49)', ''), a.data_value, t.year_start FROM uneplive_replica.time_id AS t JOIN uneplive_replica.agg_data AS a ON t.time_id = a."time_ID" JOIN uneplive_replica.country AS c ON c.country_id = a.country_id WHERE a.country_id = 1 AND a."Indicator_ID" = mpx_2 ORDER BY t.year_start, a.country_id
UNEP Global Environmental Goals (GEGs) Tracker