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