Error SQL

• SQLSTATE42883
• Driver code7
• MensajeERROR: operator does not exist: boolean = integer LINE 5: ...lesce(sub.mostrarweb2, 1) = 1 AND art.mostrarweb2 = 1 AND ar... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

Sentencia SQL

SELECT count(*) FROM articulos art LEFT JOIN familias fam ON fam.codigo = art.familia LEFT JOIN subfamilias sub ON sub.codigo = art.subfamilia WHERE fam.mostrarweb2 = 1 AND coalesce(sub.mostrarweb2, 1) = 1 AND art.mostrarweb2 = 1 AND art.obsoleto = 0 AND art.subfamilia = (SELECT codigo FROM subfamilias WHERE web_url = '1146-colcha-bouti')

Call stack

#0 /var/www/vhosts/tienda.lavanderiaiguarben.es/httpdocs/src/Library/Sql.php(302): App\Library\Sql::debugQuery()
#1 /var/www/vhosts/tienda.lavanderiaiguarben.es/httpdocs/src/Library/Sql.php(103): App\Library\Sql::debugQuerySQL()
#2 /var/www/vhosts/tienda.lavanderiaiguarben.es/httpdocs/src/Library/Sql.php(121): App\Library\Sql::getStmt()
#3 /var/www/vhosts/tienda.lavanderiaiguarben.es/httpdocs/src/Helper/PaginationHelper.php(82): App\Library\Sql::selectEscalar()
#4 /var/www/vhosts/tienda.lavanderiaiguarben.es/httpdocs/src/Helper/PaginationHelper.php(23): App\Helper\PaginationHelper->getTotalItems()
#5 /var/www/vhosts/tienda.lavanderiaiguarben.es/httpdocs/src/Controller/SubfamiliaController.php(41): App\Helper\PaginationHelper->__construct()
#6 /var/www/vhosts/tienda.lavanderiaiguarben.es/httpdocs/vendor/symfony/http-kernel/HttpKernel.php(152): App\Controller\SubfamiliaController->index()
#7 /var/www/vhosts/tienda.lavanderiaiguarben.es/httpdocs/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 /var/www/vhosts/tienda.lavanderiaiguarben.es/httpdocs/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 /var/www/vhosts/tienda.lavanderiaiguarben.es/httpdocs/public/index.php(20): Symfony\Component\HttpKernel\Kernel->handle()
#10 {main}