An unexpected error has occured!

If this error persits, please report it to the administrator.

Go back to home page

Additional information about this error:

MySQL error!

Expression #1 of ORDER BY clause is not in SELECT list, references column 'skunkwo_b2evolution.b2e_items__item.post_datestart' which is not in SELECT list; this is incompatible with DISTINCT(Errno=3065)

Your query: ItemList2::Query() Step 1: Get ID list

SELECT DISTINCT post_ID 
FROM b2e_items__item INNER JOIN b2e_postcats ON post_ID = postcat_post_ID INNER JOIN b2e_categories ON postcat_cat_ID = cat_ID
WHERE (cat_blog_ID = 4)
  AND (( post_ptyp_ID IS NULL
  OR post_ptyp_ID NOT IN (1000) ))
  AND (EXTRACT(YEAR
FROM post_datestart)=2018)
  AND (EXTRACT(MONTH
FROM post_datestart)=8)
  AND (post_datestart <= '2024-03-28 08:56:22')
  AND ( ( post_status IN ('published') ) )
ORDER BY post_datestart DESC, post_ID DESC
LIMIT 5