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] => 16513 [:id] => 16509 [:id_1] => 16510 [:id_2] => 16511 [:id_3] => 16512 [:id_4] => 16513 [:id_5] => 16514 [:id_6] => 16515 [:id_7] => 16516 [:id_8] => 16517 [:id_9] => 16518 [:id_10] => 16519 [:id_11] => 16520 [:id_12] => 16521 [:id_13] => 16522 [:id_14] => 16523 [:id_15] => 16524 [:id_16] => 16525 [:id_17] => 16526 [:id_18] => 16527 [:id_19] => 16528 [:id_20] => 16529 [:id_21] => 16530 [:id_22] => 16531 [:id_23] => 16532 [:id_24] => 18468 [:id_25] => 18732 [:id_26] => 20761 [:id_27] => 20762 [:id_28] => 20763 [:id_29] => 20764 [:id_30] => 20765 [: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