Все записи

---

MySQL Query Error: SELECT DISTINCT P.ID as ID, P.BLOG_ID as BLOG_ID, P.TITLE as TITLE, P.DATE_PUBLISH as DATE_PUBLISH_X1, DATE_FORMAT(P.DATE_PUBLISH, '%d.%m.%Y %H:%i:%s') as DATE_PUBLISH, P.AUTHOR_ID as AUTHOR_ID, P.DETAIL_TEXT as DETAIL_TEXT, B.ACTIVE as BLOG_ACTIVE, B.URL as BLOG_URL, B.GROUP_ID as BLOG_GROUP_ID, BG.SITE_ID as BLOG_GROUP_SITE_ID, U.LOGIN as AUTHOR_LOGIN, U.NAME as AUTHOR_NAME, U.LAST_NAME as AUTHOR_LAST_NAME, U.SECOND_NAME as AUTHOR_SECOND_NAME, BU.ALIAS as BLOG_USER_ALIAS, B.OWNER_ID as BLOG_OWNER_ID, P.VIEWS as VIEWS, P.NUM_COMMENTS as NUM_COMMENTS, P.ATTACH_IMG as ATTACH_IMG, B.SOCNET_GROUP_ID as BLOG_SOCNET_GROUP_ID, P.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE, P.CATEGORY_ID as CATEGORY_ID, P.CODE as CODE FROM b_blog_post P INNER JOIN b_blog B ON (P.BLOG_ID = B.ID) INNER JOIN b_blog_group BG ON (B.GROUP_ID = BG.ID) LEFT JOIN b_user U ON (P.AUTHOR_ID = U.ID) LEFT JOIN b_blog_user BU ON (P.AUTHOR_ID = BU.USER_ID) INNER JOIN b_blog_user_group_perms UGP ON (P.ID = UGP.POST_ID AND P.BLOG_ID = UGP.BLOG_ID AND UGP.USER_GROUP_ID IN (0,1) AND UGP.PERMS_TYPE = 'P') WHERE ((((P.DATE_PUBLISH <= '2025-12-19 08:30:50')))) AND ((((P.PUBLISH_STATUS = 'P' )))) AND ((((B.ACTIVE = 'Y' )))) AND ((((BG.SITE_ID = 's1' )))) AND ((((UGP.PERMS > 'D' )))) AND ((((B.GROUP_ID = 2 )) OR ((B.GROUP_ID = 3 )) OR ((B.GROUP_ID = 4 )) OR ((B.GROUP_ID = 8 )) OR ((B.GROUP_ID = 5 )) OR ((B.GROUP_ID = 6 )) OR ((B.GROUP_ID = 7 )))) ORDER BY P.DATE_PUBLISH DESC, P.ID DESC LIMIT 200, 20[[3] Error writing file '/tmp/MYaQf2AX' (Errcode: 28 - No space left on device)]

DB query error. Please try later.