Important Kunena 1.5.10 Withdrawn, unofficial Kunena 1.5.10-2 HOTFIX

SELECT u.id, u.name, u.username, u.email, IF( s.thread IS NOT NULL, 1, 0 ) AS subscription, IF( c.moderated=1 AND p.moderator=1 AND ( m.catid IS NULL OR m.catid=2), 1, 0 ) AS moderator, IF( u.gid IN (24, 25), 1, 0 ) AS admin FROM jos_users AS u LEFT JOIN jos_fb_users AS p ON u.id=p.userid LEFT JOIN jos_fb_moderation AS m ON u.id=m.userid LEFT JOIN jos_fb_categories AS c ON m.catid=c.id LEFT JOIN jos_fb_subscriptions AS s ON u.id=s.userid AND s.thread=XXXXX WHERE u.block=0 AND ( ( s.thread IS NOT NULL ) ) GROUP BY u.id

id name username email subscription moderator admin 74 Atest User atestuser [email protected] 1 0 0 149 Anothertest User atestuser2 [email protected] 1 0 0