sqlite> SELECT DISTINCT habari__posts.id AS id, habari__posts.slug AS slug, habari__posts.title AS title, habari__posts.guid AS guid, habari__posts.content AS content, habari__posts.cached_content AS cached_content, habari__posts.user_id AS user_id, habari__posts.status AS status, habari__posts.pubdate AS pubdate, habari__posts.updated AS updated, habari__posts.modified AS modified, habari__posts.content_type AS content_type, hipi1.value AS info_views_value 
FROM habari__posts
LEFT JOIN habari__postinfo hipi1 ON habari__posts.id = hipi1.post_id AND hipi1.name = 'views' 
WHERE ( (habari__posts.content_type = 1 AND (hipi1.name <> '')) )
&nbsp;AND ( ((1=1)) ) 
ORDER BY info_views_value DESC LIMIT 5;

1|habari|Habari|tag:slashee.com,2009:habari/1260834637|This site is running <a href="http://habariproject.org/">Habari</a>, a state-of-the-art publishing platform!  Habari is a community-driven project created and supported by people from all over the world.  Please visit <a href="http://habariproject.org/">http://habariproject.org/</a> to find out more!||1|2|1260834637|1260834637|1260834637|1|4
2|eggplant|Eggplant|tag:slashee.com,2009:eggplant/1260836542|Foobar.||1|2|1260836532|1260836542|1260836542|1|14
3|test|test|tag:slashee.com,2009:test/1260851401|||1|2|1260851394|1260851401|1260851401|1|1