If this error persits, please report it to the administrator.
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)=2020)
AND (EXTRACT(MONTH
FROM post_datestart)=9)
AND (post_datestart <= '2024-03-29 11:39:42')
AND ( ( post_status IN ('published') ) )
ORDER BY post_datestart DESC, post_ID DESC
LIMIT 5