Confirmed users
95
edits
Telemetry/LongitudinalExamples: Difference between revisions
Simplifying examples
(added some blocklist examples) |
Gfritzsche (talk | contribs) (Simplifying examples) |
||
| Line 28: | Line 28: | ||
SELECT bl, COUNT(bl) | SELECT bl, COUNT(bl) | ||
FROM | FROM | ||
(SELECT | (SELECT element_at(settings, 1).user_prefs['extensions.blocklist.url'] AS bl | ||
FROM longitudinal_v20160229) | FROM longitudinal_v20160229) | ||
GROUP BY bl | GROUP BY bl | ||
| Line 36: | Line 35: | ||
SELECT bl, COUNT(bl) | SELECT bl, COUNT(bl) | ||
FROM | FROM | ||
(SELECT | (SELECT element_at(settings, 1).blocklist_enabled AS bl | ||
FROM longitudinal_v20160229) | FROM longitudinal_v20160229) | ||
GROUP BY bl | GROUP BY bl | ||