- Code: Select all
1054
UNKNOWN COLUMN 'T.ID' IN 'WHERE CLAUSE' SQL=SELECT CONTENT.ID AS IID, CONTENT.CATID AS CAT_ID, CONTENT.TITLE AS TITLE, CONTENT.INTROTEXT AS TEXT, CONTENT.CREATED AS DATE, CONTENT.PUBLISH_UP AS DATE_PUBLISH, CONTENT.ALIAS AS ALIAS, CONTENT.HITS AS HITS, CONTENT.PLUGINS AS PLUGINS FROM XXXX_K2_ITEMS AS CONTENT WHERE CONTENT.TRASH = 0 AND CONTENT.ACCESS <= 5 AND CONTENT.PUBLISHED = 1 AND ( CONTENT.PUBLISH_UP = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_UP <= '2014-11-19 00:00:00' ) AND ( CONTENT.PUBLISH_DOWN = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_DOWN >= '2014-11-19 00:00:00' ) AND ( T.ID = 87 ) ORDER BY CONTENT.CREATED DESC LIMIT 0,4;