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 isLike FROM Images,Models,Items WHERE Images.id <> :Images_id AND id IN (:id,:id_1,:id_2,:id_3,:id_4,:id_5,:id_6,:id_7,:id_8,:id_9,:id_10,:id_11,:id_12,:id_13,:id_14,:id_15,:id_16,:id_17,:id_18) 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 LIMIT 0,31 Array ( [:Images_id] => 27208 [:id] => 16120 [:id_1] => 16121 [:id_2] => 16122 [:id_3] => 16123 [:id_4] => 16820 [:id_5] => 17268 [:id_6] => 26245 [:id_7] => 27147 [:id_8] => 27148 [:id_9] => 27149 [:id_10] => 27150 [:id_11] => 27151 [:id_12] => 27206 [:id_13] => 27207 [:id_14] => 27208 [:id_15] => 27233 [:id_16] => 27234 [:id_17] => 27235 [:id_18] => 27236 [:Items_warnings] => 0 [:Images_status] => 1 [:Images_consent] => 1 [:Models_model] => Images [:Activities_action] => like [:Actions_userId] => )
Fatal error: Uncaught Exception: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in where 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(2706): 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(306): 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->onDisplaySimilarImages() #6 /var/www/vhosts/superbe.co/httpdocs/Lib in /var/www/vhosts/superbe.co/httpdocs/Library/System/Server/Debug/Console.php on line 43