Template:Get bookmarks in dir

From solab
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}}} }}