Solar circuits

From solab
Revision as of 08:17, 22 November 2009 by 127.0.0.1 (talk)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 '%circuit%'
 or
 h.title like '%circuit%'
or
b.title like '%circuit%'
)
order by h.id

|yes }} --127.0.0.1 08:15, 22 November 2009 (UTC)