Solare: Difference between revisions
Jump to navigation
Jump to search
(Created page with '==Bookmark== {{get_bookmarks_in_dir |notrace=yes}}') |
(No difference)
|
Latest revision as of 18:17, 4 November 2009
Bookmark
{{#gu_sqlite: sqlite| /var/www/llg/mediawiki/extensions/gio/bb |root |
select h.id, b.parent bp, c.parent cp , b.type, c.title ctitle , h.title histitle , b.title btitle , h.visit_count, h.url, 'Bookmark::'||h.url|| Bookmark, datetime(substr(h.last_visit_date,0,11),'unixepoch', 'localtime'), h.favicon_id from ( moz_places h left join moz_bookmarks b on h.id =b.fk ) left join moz_bookmarks c on c.id = b.parent where c.id is not null and c.title like 'Solare' order by h.id
|yes }}