Skip to content
Snippets Groups Projects

Supplemented missing condition to get account posts by blog

Merged Bartek Wrona requested to merge bw_get_account_posts_by_blog_fix2 into develop
1 file
+ 1
1
Compare changes
  • Side-by-side
  • Inline
@@ -67,7 +67,7 @@ BEGIN
@@ -67,7 +67,7 @@ BEGIN
WHERE hfc.account_id = __account_id AND (__post_id = 0 OR hfc.created_at <= __created_at)
WHERE hfc.account_id = __account_id AND (__post_id = 0 OR hfc.created_at <= __created_at)
AND NOT EXISTS (SELECT NULL FROM hive_posts hp
AND NOT EXISTS (SELECT NULL FROM hive_posts hp
WHERE hp.id = hfc.post_id AND hp.counter_deleted = 0 AND hp.depth = 0 AND hp.community_id IS NOT NULL
WHERE hp.id = hfc.post_id AND hp.counter_deleted = 0 AND hp.depth = 0 AND hp.community_id IS NOT NULL
AND NOT EXISTS (SELECT NULL FROM hive_reblogs hr WHERE hr.blogger_id = __account_id)
AND NOT EXISTS (SELECT NULL FROM hive_reblogs hr WHERE hr.blogger_id = __account_id AND hr.post_id = hp.id)
)
)
ORDER BY created_at DESC
ORDER BY created_at DESC
LIMIT _limit
LIMIT _limit
Loading