590
edits
Firefox/Projects/about:me: Difference between revisions
Jump to navigation
Jump to search
→Design
Comrade693 (talk | contribs) (→Design: Adding query) |
Comrade693 (talk | contribs) (→Design) |
||
| Line 24: | Line 24: | ||
History & Bookmarks | History & Bookmarks | ||
* number of history visits | * number of history visits | ||
SELECT COUNT(1) | |||
FROM ( | |||
SELECT 1 | |||
FROM moz_historyvisits_temp | |||
UNION ALL | |||
SELECT 1 | |||
FROM moz_historyvisits | |||
WHERE id NOT IN (SELECT id FROM moz_historyvisits_temp) | |||
) | |||
* number of unique URLs | * number of unique URLs | ||
SELECT COUNT(1) | |||
FROM ( | |||
SELECT 1 | |||
FROM moz_places_temp | |||
UNION ALL | |||
SELECT 1 | |||
FROM moz_places | |||
WHERE id NOT IN (SELECT id FROM moz_places_temp) | |||
) | |||
* fav sites (top 5-10, total visits, avg visits per day) | * fav sites (top 5-10, total visits, avg visits per day) | ||
* day of week stats (eg: "sat broader, sun has more revisits"), would need total visits, and number of unique URLs for each day of the week | * day of week stats (eg: "sat broader, sun has more revisits"), would need total visits, and number of unique URLs for each day of the week | ||
* 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) | ||