SELECT Images.*,(IF(EXISTS(SELECT Actions.* FROM Actions,Items,Models,Activities WHERE Actions.itemId = Items.id AND Models.id = Items.modelId AND Items.entityId = Images.id AND Activities.modelId = Models.id AND Actions.activityId = Activities.id AND Models.model = :Models_model AND Activities.action = :Activities_action AND Actions.userId = :Actions_userId), TRUE, FALSE)) AS isBookmark FROM Images,Models,Items WHERE Images.id IN (:Images_id,:Images_id_1,:Images_id_2,:Images_id_3,:Images_id_4,:Images_id_5,:Images_id_6,:Images_id_7,:Images_id_8,:Images_id_9,:Images_id_10,:Images_id_11,:Images_id_12,:Images_id_13,:Images_id_14,:Images_id_15,:Images_id_16,:Images_id_17,:Images_id_18,:Images_id_19,:Images_id_20,:Images_id_21,:Images_id_22,:Images_id_23,:Images_id_24,:Images_id_25,:Images_id_26,:Images_id_27,:Images_id_28,:Images_id_29,:Images_id_30,:Images_id_31) AND Models.id = Items.modelId AND Items.entityId = Images.id AND Items.warnings = :Items_warnings AND Images.status = :Images_status AND Images.consent = :Images_consent ORDER BY FIELD(id,32400,64941,102443,18047,44738,179502,32408,8,25791,1285,2567,135431,82574,129879,218999,89765,7713,245258,20029,48551,74835,225104,133455,24572,31492,64335,131250,31181,58664,29209,129932,124440) LIMIT 32 Array ( [:Images_id] => 32400 [:Images_id_1] => 64941 [:Images_id_2] => 102443 [:Images_id_3] => 18047 [:Images_id_4] => 44738 [:Images_id_5] => 179502 [:Images_id_6] => 32408 [:Images_id_7] => 8 [:Images_id_8] => 25791 [:Images_id_9] => 1285 [:Images_id_10] => 2567 [:Images_id_11] => 135431 [:Images_id_12] => 82574 [:Images_id_13] => 129879 [:Images_id_14] => 218999 [:Images_id_15] => 89765 [:Images_id_16] => 7713 [:Images_id_17] => 245258 [:Images_id_18] => 20029 [:Images_id_19] => 48551 [:Images_id_20] => 74835 [:Images_id_21] => 225104 [:Images_id_22] => 133455 [:Images_id_23] => 24572 [:Images_id_24] => 31492 [:Images_id_25] => 64335 [:Images_id_26] => 131250 [:Images_id_27] => 31181 [:Images_id_28] => 58664 [:Images_id_29] => 29209 [:Images_id_30] => 129932 [:Images_id_31] => 124440 [:Items_warnings] => 0 [:Images_status] => 1 [:Images_consent] => 1 [:Models_model] => Images [:Activities_action] => bookmark [:Actions_userId] => )
Fatal error: Uncaught Exception: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in order clause is ambiguous in /var/www/vhosts/superbe.co/httpdocs/Library/System/Server/Debug/Console.php:43 Stack trace: #0 /var/www/vhosts/superbe.co/httpdocs/Library/System/Server/ORM/Query.php(56): System\Server\Debug\Console::error() #1 /var/www/vhosts/superbe.co/httpdocs/Library/System/Server/MVC/Model.php(2713): System\Server\ORM\Query->build() #2 /var/www/vhosts/superbe.co/httpdocs/Library/System/Server/MVC/Model.php(1051): System\Server\MVC\Model->fetch() #3 /var/www/vhosts/superbe.co/httpdocs/Library/System/Server/DAM/DAM.php(400): System\Server\MVC\Model->all() #4 /var/www/vhosts/superbe.co/httpdocs/Library/System/Packages/Content/Publishing/Controllers/Portfolio.php(130): System\Server\DAM\DAM->display() #5 /var/www/vhosts/superbe.co/httpdocs/Library/System/Server/Kernel/PubSub.php(160): System\Packages\Content\Publishing\Controllers\Portfolio->onDisplayTrendingImages() #6 /var/www/vhosts/superbe.co/httpdocs/Li in /var/www/vhosts/superbe.co/httpdocs/Library/System/Server/Debug/Console.php on line 43