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) >= 1762405200 AND UNIX_TIMESTAMP(id.timestamp) < 1762491600)
OR (UNIX_TIMESTAMP(id_published.timestamp) >= 1762405200 AND UNIX_TIMESTAMP(id_published.timestamp) < 1762491600))
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]