63
edits
Firefox/Projects/about:me: Difference between revisions
→History & Bookmarks
(→Design) |
|||
| Line 102: | Line 102: | ||
* number of unique URLs for each day of the week (sunday is 0) | * number of unique URLs for each day of the week (sunday is 0) | ||
SELECT COUNT(*) as num_visits, | |||
strftime('%w', visit_date/1000000, 'unixepoch', 'localtime') as day | |||
FROM moz_historyvisits v LEFT JOIN moz_places h ON v.place_id = h.id | |||
WHERE v.visit_type NOT IN (0, 4) | |||
GROUP BY day ORDER BY day | |||
* graph of history volume over time (visits per week since start of history accumulation) | * graph of history volume over time (visits per week since start of history accumulation) | ||