Remove old query version from bi-12
@@ -24,21 +24,3 @@ HAVING count(*) > :likeThreshold
ORDER BY likeCount DESC, m.ps_postid
LIMIT 100
;
-select
- ps_postid,
- p_firstname,
- p_lastname,
- ps_creationdate,
- count(*) as likeCount
-from post, person, likes
-where ps_postid in (select l_postid from likes group by l_postid having count(*) > :likeThreshold)
- and p_personid = ps_creatorid
- and l_postid = ps_postid
- and ps_creationdate > :date
-group by ps_postid, p_firstname, p_lastname, ps_creationdate
-order by
- likeCount desc,
- ps_postid asc
-limit 100;
-/*
-*/
