generate.inc.php 415 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
<?php
$queries[] = array(
  'file' => 'sourceforge-by-country.json',
  'query' => "
      SELECT label AS country, value
        FROM sourceforge_download
       WHERE type='C'
       ORDER BY value DESC
   ",
);
$queries[] = array(
  'file' => 'sourceforge-by-month.json',
  'query' => "
      SELECT label AS month, value
        FROM sourceforge_download
       WHERE type='M'
       ORDER BY month ASC
   ",
);