gistfile1.sql

    SELECT REGEXP_EXTRACT(url, r'(yui|jquery|dojo|angular|prototype|backbone|emberjs|sencha|scriptaculous).*\.js') type, count(distinct(pageid)) count, 
    FROM [httparchive:runs.2013_06_01_requests]
    WHERE REGEXP_MATCH(url, r'yui|jquery|dojo|angular|prototype|backbone|emberjs|sencha|scriptaculous.*\.js')
    GROUP BY type
    ORDER BY count DESC


    SELECT pages.pageid, url, cnt, libs, pages.rank rank FROM [httparchive:runs.2013_06_01_pages] as pages JOIN (
      SELECT pageid, count(distinct(type)) cnt, GROUP_CONCAT(type) libs FROM (
        SELECT REGEXP_EXTRACT(url,
          r'(yui|jquery|dojo|angular|prototype|backbone|emberjs|sencha|scriptaculous).*\.js') type, pageid
        FROM [httparchive:runs.2013_06_01_requests]
        WHERE REGEXP_MATCH(url, r'yui|jquery|dojo|angular|prototype|backbone|emberjs|sencha|scriptaculous.*\.js')
        GROUP BY pageid, type
      )
      GROUP BY pageid
    ) as lib ON lib.pageid = pages.pageid
    WHERE rank IS NOT NULL
    ORDER BY rank sac


    SELECT pages.pageid, url, cnt, libs, pages.rank rank FROM [httparchive:runs.2013_06_01_pages] as pages JOIN (
      SELECT pageid, count(distinct(type)) cnt, GROUP_CONCAT(type) libs FROM (
        SELECT REGEXP_EXTRACT(url,
          r'(yui|jquery|dojo|angular|prototype|backbone|emberjs|sencha|scriptaculous).*\.js') type, pageid
        FROM [httparchive:runs.2013_06_01_requests]
        WHERE REGEXP_MATCH(url, r'yui|jquery|dojo|angular|prototype|backbone|emberjs|sencha|scriptaculous.*\.js')
        GROUP BY pageid, type
      )
      GROUP BY pageid
    ) as lib ON lib.pageid = pages.pageid
    WHERE rank IS NOT NULL AND REGEXP_MATCH(libs, 'yui')
    ORDER BY rank asc