SELECT
`posts`.`id`,
`posts`.`created_at`,
`posts`.`content`,
`posts`.`replies`,
`groups`.`id` AS `group_id`,
`groups`.`name` AS `group_name`,
`users`.`id` AS `user_id`,
`users`.`name`,
`users`.`surname`,
`users`.`avatar`,
`posts`.`link`,
`posts`.`event_id`,
`events`.`name` AS `event_name`,
`docs`.`id` AS `attachment_id`
FROM `posts`
JOIN `groups`
ON (`groups`.`id` = `posts`.`group_id`)
JOIN `users`
ON (`users`.`id` = `posts`.`user_id`)
LEFT JOIN `events`
ON (`events`.`id` = `posts`.`event_id`)
LEFT JOIN `docs`
ON (`docs`.`post_id` = `posts`.`id`)
WHERE `posts`.`post_id` = 0
AND `posts`.`group_id` = '28'
ORDER BY `posts`.`id` DESC
LIMIT 4
OFFSET 0
SELECT
`posts`.`id`,
`posts`.`created_a