阅读背景:

一个帖子不止一个文件...任何想法?

来源:互联网 
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



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: