PostgreSQL: error in SQL statement
Created by: ingoj
2018-04-16T07:29:02Z:LOG_ERR:e4tf54800fr2r2snk5a19dfku4:dba_driver.php:459:db_logger: dba_pdo: ERROR: SELECT distinct parent AS item_id from item left join abook on ( item.owner_xchan = abook.abook_xchan and abook.abook_channel = 2 ) WHERE uid = 2 and item.item_hidden = 0 and item.item_type = 0 and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.obj_type != 'http://purl.org/zot/activity/file' AND item_wall = 1 AND (( item_unseen = 1 AND item.changed > '2018-04-16 07:27:41' ) OR item.changed > '2018-04-16 07:27:41' ) and author_xchan = '' AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item_private = 0 ORDER BY created DESC; SQLSTATE[42P10]: Invalid column reference: 7 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 9: ORDER BY created DESC;