Template:Get bookmarks in dir
Jump to navigation
Jump to search
{{#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 'Get_bookmarks_in_dir' order by h.id
|{{{notrace}}} }}