# Who does not track you

**URL:** <https://discuss.httparchive.org/t/who-does-not-track-you/660>\
**Category:** Analysis\
**Created:** [January 4, 2016, 9:22pm UTC](https://discuss.httparchive.org/t/who-does-not-track-you/660 "2016-01-04T21:22:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ebuildy](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/ebuildy/32/580_2.png) [@ebuildy](https://discuss.httparchive.org/u/ebuildy)\
**Post date:** [January 4, 2016, 9:22pm UTC](https://discuss.httparchive.org/t/who-does-not-track-you/660/1 "2016-01-04T21:22:38Z")

</div>

I want to know who is not using Javascript trackers (such as google-analytics, piwik …). I am not sure if this is the right way to query it:

```
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'(piwik|google-analytics|getclicky|xiti|googletagmanager|criteo|webtrends|s_code|ntpagetag|tagcommander).*\.js') type,
      pageid
    FROM
      [httparchive:runs.2013_06_01_requests]
    WHERE
      REGEXP_MATCH(url, r'piwik|google-analytics|getclicky|xiti|googletagmanager|criteo|webtrends|s_code|ntpagetag|tagcommander.*\.js')
    GROUP BY
      pageid,
      type )
  GROUP BY
    pageid
  HAVING cnt = 0) AS lib
ON
  lib.pageid = pages.pageid
WHERE
  rank IS NOT NULL
  AND TLD(url) = ".fr"
ORDER BY
  rank
```
