Talks in Chronological Order (Videos)

get_results(
“SELECT SUM(CASE WHEN r = ‘r’ or s=’s’ or d=’d’ THEN 1 ELSE 0 END) AS c ,SUM(CASE WHEN r = ‘r’ or s=’s’ THEN 1 ELSE 0 END) AS rs ,SUM(CASE WHEN r = ‘r’ THEN 1 ELSE 0 END) AS r ,SUM(CASE WHEN s = ‘s’ THEN 1 ELSE 0 END) AS s ,SUM(CASE WHEN t = ‘t’ THEN 1 ELSE 0 END) AS t ,SUM(CASE WHEN a = ‘a’ THEN 1 ELSE 0 END) AS a ,SUM(CASE WHEN v = ‘v’ THEN 1 ELSE 0 END) AS v ,SUM(CASE WHEN v = ‘v’ or a = ‘a’ THEN 1 ELSE 0 END) AS m ,SUM(CASE WHEN d = ‘d’ THEN 1 ELSE 0 END) AS d ,SUM(CASE WHEN y = ‘y’ THEN 1 ELSE 0 END) AS y FROM r_posts_agreg where date<'2010-11-19' and q='' and l=''; "); foreach ( $q1 as $t ) { echo '

  • E – Events with or without a Recorded Speech – ‘ . $t->rs . ‘

    • ‘;
    echo ‘

  • R – Events with a Recorded Speech or Media – ‘ . $t->r . ‘

    • ‘;
    echo ‘

  • T – Events with English Transcript – ‘ . $t->t . ‘

    • ‘;
    echo ‘

  • A – Events with Audio – ‘ . $t->a . ‘

    • ‘;
    echo ‘

  • V – Events with Video – ‘ . $t->v . ‘

    • ‘;
    echo ‘

  • M – Events with Media (Audio or Video) – ‘ . $t->m . ‘

    • ‘;
    echo ‘
    ‘;

    }

    $q = $wpdb->get_results(
    ”
    SELECT
    year(date) as year, DATE_FORMAT(date, ‘%Y-%m%d’) as date2,permalink,title,if(place=’Place Unknown’,NULL, place) place,city,country, concat(‘[‘,concat_ws(‘, ‘, nullif(r,”),nullif(s,”),nullif(y,”),nullif(t,”),nullif(a,”),nullif(v,”),nullif(d,”)),’]’) AS cats
    FROM amruta5_amruta.r_posts_agreg where date<'2010-11-19' and r='r' and q='' and l='' and v='v' ORDER BY date " ); $c = $wpdb->get_results( “SELECT count(*) as count, year(date) as year FROM amruta5_amruta.r_posts_agreg where date<'2010-11-19' and v='v' and q='' and l='' group by year(date) "); $years = array(); echo "

    Links to Year

    “;
    echo “

    ‘;
    ?>