In file actions/favorited.php function showContent() $qry for pgsql should be
$qry = ' select * from notice where id in
(SELECT fave.notice_id FROM fave
GROUP BY fave.notice_id
ORDER BY sum(exp(-extract(epoch from
(now()-fave.modified))/864000)) DESC)';Can someone help me check this sql command correct or not ? Dome C. _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
