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]