Line: 619MySQL Query Error: SELECT DISTINCT C.ID as ID, C.BLOG_ID as BLOG_ID, C.POST_ID as POST_ID, C.PARENT_ID as PARENT_ID, C.AUTHOR_ID as AUTHOR_ID, C.AUTHOR_NAME as AUTHOR_NAME, C.AUTHOR_EMAIL as AUTHOR_EMAIL, C.AUTHOR_IP as AUTHOR_IP, C.AUTHOR_IP1 as AUTHOR_IP1, C.TITLE as TITLE, C.POST_TEXT as POST_TEXT, B.URL as BLOG_URL, DATE_FORMAT(C.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE, B.ACTIVE as BLOG_ACTIVE, B.GROUP_ID as BLOG_GROUP_ID, BG.SITE_ID as BLOG_GROUP_SITE_ID, B.OWNER_ID as BLOG_OWNER_ID, B.SOCNET_GROUP_ID as BLOG_SOCNET_GROUP_ID, BP.CODE as POST_CODE FROM b_blog_comment C INNER JOIN b_blog B ON (C.BLOG_ID = B.ID)
INNER JOIN b_blog BGS ON (C.BLOG_ID = BGS.ID)
INNER JOIN b_blog_group BG ON (BGS.GROUP_ID = BG.ID) INNER JOIN b_blog_post BP ON (C.POST_ID = BP.ID) INNER JOIN b_blog_user_group_perms UGP ON (C.POST_ID = UGP.POST_ID AND C.BLOG_ID = UGP.BLOG_ID AND UGP.USER_GROUP_ID IN (0,1) AND UGP.PERMS_TYPE = 'C') WHERE ((((B.ACTIVE = 'Y' )))) AND ((((BG.SITE_ID = 's1' )))) AND ((((UGP.PERMS > 'D' )))) AND ((((BP.PUBLISH_STATUS = 'P' )))) AND ((((C.PUBLISH_STATUS = 'P' )))) AND ((( BP.MICRO IS NULL OR NOT (BP.MICRO = 'Y' )))) ORDER BY C.DATE_CREATE DESC, C.ID DESC LIMIT 6
[The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
DB query error.
Please try later.