Confirmed users
764
edits
Firefox/Projects/Places DB Creation Scripts: Difference between revisions
Jump to navigation
Jump to search
Firefox/Projects/Places DB Creation Scripts (view source)
Revision as of 21:37, 25 February 2009
, 25 February 2009→Design
(→Design) |
(→Design) |
||
| Line 169: | Line 169: | ||
WHERE IFNULL(h_t.url, h.url) NOTNULL | WHERE IFNULL(h_t.url, h.url) NOTNULL | ||
ORDER BY rank DESC, IFNULL(h_t.frecency, h.frecency) DESC | ORDER BY rank DESC, IFNULL(h_t.frecency, h.frecency) DESC | ||
</pre> | |||
mDBKeywordQuery: | |||
<pre> | |||
SELECT IFNULL( | |||
(SELECT REPLACE(url, '%s', ?2) FROM moz_places_temp WHERE id = b.fk), | |||
(SELECT REPLACE(url, '%s', ?2) FROM moz_places WHERE id = b.fk) | |||
) AS search_url, | |||
IFNULL(h_t.title, h.title), | |||
COALESCE( | |||
f.url, | |||
(SELECT f.url FROM moz_places_temp | |||
JOIN moz_favicons f ON f.id = favicon_id | |||
WHERE rev_host = IFNULL( | |||
(SELECT rev_host FROM moz_places_temp WHERE id = b.fk), | |||
(SELECT rev_host FROM moz_places WHERE id = b.fk) | |||
) | |||
ORDER BY frecency DESC LIMIT 1), | |||
(SELECT f.url FROM moz_places | |||
JOIN moz_favicons f ON f.id = favicon_id | |||
WHERE rev_host = IFNULL( | |||
(SELECT rev_host FROM moz_places_temp WHERE id = b.fk), | |||
(SELECT rev_host FROM moz_places WHERE id = b.fk) | |||
) | |||
ORDER BY frecency DESC LIMIT 1) | |||
), | |||
b.parent, | |||
b.title, | |||
NULL, | |||
IFNULL(h_t.visit_count, h.visit_count), | |||
IFNULL(h_t.typed, h.typed) | |||
FROM moz_keywords k | |||
JOIN moz_bookmarks b ON b.keyword_id = k.id | |||
LEFT JOIN moz_places AS h ON h.url = search_url | |||
LEFT JOIN moz_places_temp AS h_t ON h_t.url = search_url | |||
LEFT JOIN moz_favicons f ON f.id = IFNULL(h_t.favicon_id, h.favicon_id) | |||
WHERE LOWER(k.keyword) = LOWER(?1) | |||
ORDER BY IFNULL(h_t.frecency, h.frecency) DESC") | |||
</pre> | </pre> | ||