Asian Development Bank
Asia Regional Integration Center
Notice: Undefined variable: mode in /opt/rh/httpd24/root/var/www/vhosts/aricv7/content/db/dbmacroresult.php on line 54
Notice: Undefined variable: arr_countries in /opt/rh/httpd24/root/var/www/vhosts/aricv7/content/db/dbmacroresult.php on line 55
Notice: Undefined variable: frequency in /opt/rh/httpd24/root/var/www/vhosts/aricv7/content/db/dbmacroresult.php on line 256
SELECT
c.country_name,
ix.name,
s.`source`,
DATE_FORMAT(i.date,'%Y-%m') AS `date`,
ix.currency_type AS `currency`,
FORMAT(i.value,3) AS `value`,
ix.unit_code AS `unit`,
c.currency_name AS `local`,
n.note_text AS `note`,
ix.category_code AS category
FROM indicator_value_fp i
INNER JOIN country2_fp c ON i.country_code = c.country_code
INNER JOIN indicator_fp ix ON i.indicator_code = ix.code
LEFT JOIN ( SELECT country_code, indicator_code, GROUP_CONCAT(description SEPARATOR '***') AS `source`
FROM source_fp
GROUP BY country_code, indicator_code
) s ON i.indicator_code = s.indicator_code AND i.country_code = s.country_code
LEFT JOIN ( SELECT country_code, indicator_code, GROUP_CONCAT(note_text SEPARATOR '***') AS `note_text`
FROM notes_fp
GROUP BY country_code, indicator_code
) n ON i.indicator_code = n.indicator_code AND i.country_code = n.country_code ORDER BY c.country_name, CAST(ix.category_code AS CHAR(2)), ix.name, i.date DESC
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 256 bytes) in /opt/rh/httpd24/root/var/www/vhosts/aricv7/components/library/Db.php on line 50