Which sites are using multiple JS frameworks, how many?

Analysis
1 
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'(jquery|dojo|angular|prototype|backbone|emberjs|sencha|scriptaculous).*\.js') type, pageid
        FROM [httparchive:runs.2013_06_01_requests]
        WHERE REGEXP_MATCH(url, r'jquery|dojo|angular|prototype|backbone|emberjs|sencha|scriptaculous.*\.js')
        GROUP BY pageid, type
      )
    GROUP BY pageid
    HAVING cnt >= 2
) as lib ON lib.pageid = pages.pageid
WHERE rank IS NOT NULL
ORDER BY rank asc

Replace the regexp contents with your own list of favorite frameworks… :smile:

2 Likes