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,:id_19,:id_20,:id_21,:id_22,:id_23,:id_24,:id_25,:id_26,:id_27,:id_28,:id_29,:id_30) 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] => 17389 [:id] => 16869 [:id_1] => 16870 [:id_2] => 16871 [:id_3] => 17379 [:id_4] => 17380 [:id_5] => 17381 [:id_6] => 17382 [:id_7] => 17383 [:id_8] => 17384 [:id_9] => 17385 [:id_10] => 17386 [:id_11] => 17387 [:id_12] => 17388 [:id_13] => 17389 [:id_14] => 17390 [:id_15] => 17391 [:id_16] => 17392 [:id_17] => 17393 [:id_18] => 17394 [:id_19] => 17395 [:id_20] => 17396 [:id_21] => 17397 [:id_22] => 17398 [:id_23] => 17399 [:id_24] => 17400 [:id_25] => 17401 [:id_26] => 17402 [:id_27] => 17403 [:id_28] => 17404 [:id_29] => 20152 [:id_30] => 20153 [: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