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