# Which sites are using multiple JS frameworks, how many?

**URL:** <https://discuss.httparchive.org/t/which-sites-are-using-multiple-js-frameworks-how-many/8>\
**Category:** Analysis\
**Created:** [June 27, 2013, 5:29am UTC](https://discuss.httparchive.org/t/which-sites-are-using-multiple-js-frameworks-how-many/8 "2013-06-27T05:29:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![igrigorik](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/igrigorik/32/925_2.png) [@igrigorik](https://discuss.httparchive.org/u/igrigorik)\
**Post date:** [June 27, 2013, 5:29am UTC](https://discuss.httparchive.org/t/which-sites-are-using-multiple-js-frameworks-how-many/8/1 "2013-06-27T05:29:44Z")

</div>

```sql
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… 😄