='${start_time}' AND DATA_YEAR <='${end_time}' AND INDEX_EN_NAME = '${index_name}'and INDEX_ID = ${index_id} AND COUNTRY_CN_NAME in(${country_list}))p on p.COUNTRY_CN_NAME = gs.CN_NAME
WHERE gs.CN_NAME in (${country_list})order by p.DATA_YEAR asc;]]>
='${start_time}' AND DATA_YEAR <='${end_time}' AND INDEX_EN_NAME = '${index_name1}'and INDEX_ID = ${index_id1} AND COUNTRY_CN_NAME in(${country_list}))p on p.COUNTRY_CN_NAME = gs.CN_NAME
WHERE gs.CN_NAME in (${country_list})order by p.DATA_YEAR asc;]]>
='${start_time}' AND DATA_YEAR <='${end_time}' AND INDEX_EN_NAME = '${index_name2}'and INDEX_ID = ${index_id2} AND COUNTRY_CN_NAME in(${country_list}))p on p.COUNTRY_CN_NAME = gs.CN_NAME
WHERE gs.CN_NAME in (${country_list})order by p.DATA_YEAR asc;]]>
= '${start_time}' AND DATA_YEAR <= '${end_time}' AND INDEX_EN_NAME = '${index_name3}' and INDEX_ID = ${index_id3} AND COUNTRY_CN_NAME in(${country_list}))p on p.COUNTRY_CN_NAME = gs.CN_NAME
WHERE gs.CN_NAME in (${country_list})
order by p.DATA_YEAR asc;]]>
= '${start_time}' AND DATA_YEAR <= '${end_time}' AND INDEX_EN_NAME = '${index_name4}' and INDEX_ID = ${index_id4} AND COUNTRY_CN_NAME in(${country_list}))p on p.COUNTRY_CN_NAME = gs.CN_NAME
WHERE gs.CN_NAME in (${country_list})
order by p.DATA_YEAR asc;]]>
0, "WORLD BANK", "") || if(find("iea", $table_name1) > 0, "IEA", "") || if(find("eia", $table_name1) > 0, "EIA)", "") || if(find("bp", $table_name1) > 0, "BP", "")) + ")"]]>
0, "WORLD BANK", "") || if(find("iea", $table_name1) > 0, "IEA", "") || if(find("eia", $table_name1) > 0, "EIA)", "") || if(find("bp", $table_name1) > 0, "BP", "")) + ")"]]>
0, "WORLD BANK", "") || if(find("iea", $table_name1) > 0, "IEA", "") || if(find("eia", $table_name1) > 0, "EIA)", "") || if(find("bp", $table_name1) > 0, "BP", "")) + ")"]]>
0, "WORLD BANK", "") || if(find("iea", $table_name1) > 0, "IEA", "") || if(find("eia", $table_name1) > 0, "EIA)", "") || if(find("bp", $table_name1) > 0, "BP", "")) + ")"]]>
0, "WORLD BANK", "") || if(find("iea", $table_name1) > 0, "IEA", "") || if(find("eia", $table_name1) > 0, "EIA)", "") || if(find("bp", $table_name1) > 0, "BP", "")) + ")"]]>