Ris

SELECT i.*, COUNT(e.id) AS `replies_count`, u.nickname AS `user_nickname`, u.is_deleted AS `user_is_deleted`, u.avatar AS `user_avatar`, IF(online.date_created IS NOT NULL AND TIMESTAMPDIFF(SECOND, online.date_created, NOW()) <= 180, 1, 0) AS `is_online`
FROM cms_wall_entries i
LEFT JOIN cms_wall_entries AS e ON e.parent_id = i.id
INNER JOIN cms_users AS u ON u.id = i.user_id
LEFT JOIN cms_sessions_online AS online ON online.user_id = u.id
WHERE (i.profile_id = '25') AND (i.parent_id = '0') AND (i.profile_type = 'group')
GROUP BY i.id
ORDER BY i.date_pub DESC
LIMIT 0, 15