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) 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] => 265926
[:id] => 265916
[:id_1] => 265917
[:id_2] => 265918
[:id_3] => 265919
[:id_4] => 265920
[:id_5] => 265921
[:id_6] => 265922
[:id_7] => 265923
[:id_8] => 265924
[:id_9] => 265925
[:id_10] => 265926
[:id_11] => 265927
[:id_12] => 265928
[:id_13] => 265929
[:id_14] => 265930
[:id_15] => 265931
[:id_16] => 265932
[:id_17] => 265933
[:id_18] => 265934
[:id_19] => 265935
[:id_20] => 265936
[: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