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,31634,48654,27697,119438,246506,125656,48859,62169,39,97261,202922,41,18298,252958,33736,130476,281,101,11134,210200,49647,44711,58619,11637,71,444,11490,16956,17775,243454,16426,49989) LIMIT 32 Array ( [:Images_id] => 31634 [:Images_id_1] => 48654 [:Images_id_2] => 27697 [:Images_id_3] => 119438 [:Images_id_4] => 246506 [:Images_id_5] => 125656 [:Images_id_6] => 48859 [:Images_id_7] => 62169 [:Images_id_8] => 39 [:Images_id_9] => 97261 [:Images_id_10] => 202922 [:Images_id_11] => 41 [:Images_id_12] => 18298 [:Images_id_13] => 252958 [:Images_id_14] => 33736 [:Images_id_15] => 130476 [:Images_id_16] => 281 [:Images_id_17] => 101 [:Images_id_18] => 11134 [:Images_id_19] => 210200 [:Images_id_20] => 49647 [:Images_id_21] => 44711 [:Images_id_22] => 58619 [:Images_id_23] => 11637 [:Images_id_24] => 71 [:Images_id_25] => 444 [:Images_id_26] => 11490 [:Images_id_27] => 16956 [:Images_id_28] => 17775 [:Images_id_29] => 243454 [:Images_id_30] => 16426 [:Images_id_31] => 49989 [: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