1 ----------- ERROR : ------------
ERROR: SELECT indicator_def, cat_id, per_capita FROM uneplive_replica_gegs.indicators WHERE indicator_id = mpx_3
1 ----------- ERROR : ------------
ERROR: SELECT
uneplive_replica_gegs.source.source_name,
uneplive_replica_gegs.source.source_url,
uneplive_replica_gegs.orgs.org_short
FROM
uneplive_replica_gegs.indicators
JOIN
uneplive_replica_gegs.source ON uneplive_replica_gegs.indicators.source_id = uneplive_replica_gegs.source.source_id
JOIN
uneplive_replica_gegs.orgs ON uneplive_replica_gegs.orgs.org_id = uneplive_replica_gegs.source.org_id
WHERE
indicator_id = mpx_3
1 ----------- ERROR : ------------
ERROR: SELECT
REPLACE(REPLACE(REPLACE(country_name, '(MDG=M49)', ''), 'M49 group:', ''), '(M49)', ''),
uneplive_replica_gegs.agg_data.data_value,
uneplive_replica_gegs.time_id.year_start
FROM
uneplive_replica_gegs.time_id
JOIN uneplive_replica_gegs.agg_data ON uneplive_replica_gegs.time_id.time_id = uneplive_replica_gegs.agg_data."time_ID"
JOIN uneplive_replica_gegs.country ON uneplive_replica_gegs.country.country_id = uneplive_replica_gegs.agg_data.country_id
WHERE
uneplive_replica_gegs.agg_data.country_id = 1
AND uneplive_replica_gegs.agg_data."Indicator_ID" = mpx_3
ORDER BY
uneplive_replica_gegs.time_id.year_start,
uneplive_replica_gegs.agg_data.country_id
1 ----------- ERROR : ------------
ERROR: SELECT
REPLACE(REPLACE(REPLACE(country_name, '(MDG=M49)', ''), 'M49 group:', ''), '(M49)', ''),
uneplive_replica_gegs.agg_data.data_value,
uneplive_replica_gegs.time_id.year_start
FROM
uneplive_replica_gegs.time_id
JOIN uneplive_replica_gegs.agg_data ON uneplive_replica_gegs.time_id.time_id = uneplive_replica_gegs.agg_data."time_ID"
JOIN uneplive_replica_gegs.country ON uneplive_replica_gegs.country.country_id = uneplive_replica_gegs.agg_data.country_id
WHERE
uneplive_replica_gegs.agg_data.country_id = 1
AND uneplive_replica_gegs.agg_data."Indicator_ID" = mpx_3
ORDER BY
uneplive_replica_gegs.time_id.year_start,
uneplive_replica_gegs.agg_data.country_id
UNEP Global Environmental Goals (GEGs) Tracker