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) 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] => 91555
[:id] => 91534
[:id_1] => 91535
[:id_2] => 91536
[:id_3] => 91537
[:id_4] => 91538
[:id_5] => 91539
[:id_6] => 91540
[:id_7] => 91541
[:id_8] => 91542
[:id_9] => 91543
[:id_10] => 91544
[:id_11] => 91545
[:id_12] => 91546
[:id_13] => 91547
[:id_14] => 91548
[:id_15] => 91549
[:id_16] => 91550
[:id_17] => 91551
[:id_18] => 91552
[:id_19] => 91553
[:id_20] => 91554
[:id_21] => 91555
[:id_22] => 91556
[:id_23] => 91557
[:id_24] => 91558
[: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