1 ----------- ERROR : ------------
ERROR: SELECT indicator_def, cat_id, per_capita FROM uneplive_replica.indicators WHERE indicator_id = mpx_6
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_6
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_6
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_6
ORDER BY
t.year_start,
a.country_id
UNEP Global Environmental Goals (GEGs) Tracker