gistfile1.txt

<h1>India from 20050000 to 20100000</h1>

query = select *,(select shortname from datasets where datasets.url = database_url) as shortname from data where region = ? and odate between ? and ? and metric = ? having not (shortname REGEXP '^ted')
<br/>parameters to query: region = India, start_date = 20050000, end_date = 20100000, metric = GDP
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>Reading a row from data
<br/>data is as follows:
<br/>Array
(
    [maddison2010 (1990 international dollar)] => Array
        (
            [20050000] => 2649687064576
            [20060000] => 2909355900928
            [20070000] => 3182835007488
            [20080000] => 3415182934016
        )

    [wdi201709 (constant 2010 US dollar)] => Array
        (
            [20050000] => 1111202070528
            [20060000] => 1214143528960
            [20070000] => 1333146025984
            [20080000] => 1385018163200
            [20090000] => 1502464704512
            [20100000] => 1656617041920
        )

    [wdi201709 (constant LCU)] => Array
        (
            [20050000] => 54952370110464
            [20060000] => 60043135287296
            [20070000] => 65928180006912
            [20080000] => 68493420527616
            [20090000] => 74301516546048
            [20100000] => 81924823449600
        )

    [wdi201709 (current LCU)] => Array
        (
            [20050000] => 35812964040704
            [20060000] => 41643864489984
            [20070000] => 48357598822400
            [20080000] => 54592230391808
            [20090000] => 62812625829888
            [20100000] => 75479117725696
        )

    [wdi201709 (current US dollar)] => Array
        (
            [20050000] => 808901083136
            [20060000] => 920316542976
            [20070000] => 1201111826432
            [20080000] => 1186952773632
            [20090000] => 1323940315136
            [20100000] => 1656617041920
        )

)
csv = Year|maddison2010 (1990 international dollar)|wdi201709 (constant 2010 US dollar)|wdi201709 (constant LCU)|wdi201709 (current LCU)|wdi201709 (current US dollar)
20050000|2649687064576|1111202070528|54952370110464|35812964040704|808901083136
20060000|2909355900928|1214143528960|60043135287296|41643864489984|920316542976
20070000|3182835007488|1333146025984|65928180006912|48357598822400|1201111826432
20080000|3415182934016|1385018163200|68493420527616|54592230391808|1186952773632
20090000|NA|1502464704512|74301516546048|62812625829888|1323940315136
20100000|NA|1656617041920|81924823449600|75479117725696|1656617041920

<br/>permalinkUrl = https://???/region.php#GDPno_include_private???
<br/>fileName = 2c3b0158f308b603dde637b7e9c3f2b9
<br/>output = maddison2010 (1990 international dollar)|3039265226752.0
wdi201709 (constant 2010 US dollar)|1367098589184.0
wdi201709 (constant LCU)|67607240987989.336
wdi201709 (current LCU)|53116400216746.664
wdi201709 (current US dollar)|1182973263872.0

======
maddison2010 (1990 international dollar)|0.290526289274
wdi201709 (constant 2010 US dollar)|0.470261096956
wdi201709 (constant LCU)|0.47026122245
wdi201709 (current LCU)|1.12719567984
wdi201709 (current US dollar)|0.976803295525

<br/>outlist is as follows:
<br/>Array
(
    [0] => maddison2010 (1990 international dollar)|3039265226752.0
wdi201709 (constant 2010 US dollar)|1367098589184.0
wdi201709 (constant LCU)|67607240987989.336
wdi201709 (current LCU)|53116400216746.664
wdi201709 (current US dollar)|1182973263872.0


    [1] => 
maddison2010 (1990 international dollar)|0.290526289274
wdi201709 (constant 2010 US dollar)|0.470261096956
wdi201709 (constant LCU)|0.47026122245
wdi201709 (current LCU)|1.12719567984
wdi201709 (current US dollar)|0.976803295525

)
avg = Array