61
edits
User talk:Andyed: Difference between revisions
Jump to navigation
Jump to search
→Search Volume: & about:search, fix to remove false positives
(Search Volume query & link to about:search) |
(→Search Volume: & about:search, fix to remove false positives) |
||
| Line 4: | Line 4: | ||
== Search Volume == | == Search Volume == | ||
Demo adapted from about:me, Install about:search at http://surfmind.com/lab/mozilla/aboutsearch/aboutsearch_021.xpi | |||
SELECT rev_host as rev_host, SUM(visit_count) as visits | SELECT rev_host as rev_host, SUM(visit_count) as visits | ||
FROM moz_places WHERE url like '%q=%' GROUP BY rev_host | FROM moz_places WHERE (url like '%?q=%' OR url like '%&q=%') GROUP BY rev_host | ||
ORDER BY SUM(visit_count) DESC LIMIT 10 | ORDER BY SUM(visit_count) DESC LIMIT 10 | ||
== Search Efficacy Metrics == | == Search Efficacy Metrics == | ||