1 ----------- ERROR : ------------ ERROR: SELECT indicator_def, cat_id, per_capita FROM uneplive_replica.indicators WHERE indicator_id = mpx_4
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_4
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_4
ORDER BY
t.year_start,
a.country_id
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 2
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 150
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 276
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 156
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 250
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 458
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 604
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 50
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 68
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 404
1 ----------- ERROR : ------------ ERROR: SELECT d.country_id FROM uneplive_replica.data AS d WHERE "Indicator_ID" = mpx_4 AND country_id = 288 UNEP Global Environmental Goals (GEGs) Tracker