DB Error: unknown error.
SELECT ### Core item properties i.id, i.guid, IFNULL(id_link.value_long, i.link) AS link, IFNULL(id_title.value_long, i.title) AS title, IFNULL(id_content.value_long, i.content) AS content, i.author, i.category, i.modified, # use the timestamp of the most recent read or publish action IF(UNIX_TIMESTAMP(id.timestamp) < UNIX_TIMESTAMP(id_published.timestamp), UNIX_TIMESTAMP(id_published.timestamp), UNIX_TIMESTAMP(id.timestamp)) AS `timestamp`, ### Original item properties i.link AS original_link, i.title AS original_title, i.content AS original_content, ### Core feed properties f.id AS feed_id, f.url AS feed_url, f.title AS feed_title, f.link AS feed_link, f.description AS feed_description, fd.value_long AS feed_metadatum_tags, ### Extra item properties id0.value_long AS `metadatum_comment`, id1.value_long AS `metadatum_tags`, id2.value_numeric AS `metadatum_self`, id_published.value_numeric AS published, id.value_numeric AS `read` FROM `items_userdata` AS id LEFT JOIN `items` AS i ON i.id = id.item_id LEFT JOIN `feeds` AS f ON f.id = i.feed_id LEFT JOIN `items_userdata` AS id_published ON id_published.item_id = i.id AND id_published.user_id = 1 AND id_published.label = 'published' LEFT JOIN `items_userdata` AS id_self ON id_self.item_id = i.id AND id_self.user_id = 1 AND id_self.label = 'self' LEFT JOIN `items_userdata` AS id_title ON id_title.item_id = i.id AND id_title.user_id = 1 AND id_title.label = 'title' LEFT JOIN `items_userdata` AS id_content ON id_content.item_id = i.id AND id_content.user_id = 1 AND id_content.label = 'content' LEFT JOIN `items_userdata` AS id_link ON id_link.item_id = i.id AND id_link.user_id = 1 AND id_link.label = 'link' LEFT JOIN `feeds_userdata` AS fd ON fd.feed_id = f.id AND fd.user_id = 1 AND fd.label = 'tags' LEFT JOIN `items_userdata` AS id0 ON id0.item_id = i.id AND id0.user_id = 1 AND id0.label = 'comment' LEFT JOIN `items_userdata` AS id1 ON id1.item_id = i.id AND id1.user_id = 1 AND id1.label = 'tags' LEFT JOIN `items_userdata` AS id2 ON id2.item_id = i.id AND id2.user_id = 1 AND id2.label = 'self' WHERE id.user_id = 1 AND id.label = 'read' AND 1 AND 1 AND (id_published.value_numeric = 1) AND 1 AND ((UNIX_TIMESTAMP(id.timestamp) >= 1728014400 AND UNIX_TIMESTAMP(id.timestamp) < 1728100800) OR (UNIX_TIMESTAMP(id_published.timestamp) >= 1728014400 AND UNIX_TIMESTAMP(id_published.timestamp) < 1728100800)) AND 1 AND 1 AND 1 AND i.id IS NOT NULL GROUP BY id.item_id ORDER BY `timestamp` DESC, i.modified DESC # Context: RF_Controller:getUserItems() /web/turok/phpprod/docs/oni_refeed/library/RF/Controller.class.php:784 [nativecode=1055 ** Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'refeed_opennet.id_link.value_long' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]