^ array:8 [ "success" => false "class" => "DBAL" "methode" => "DBAL::executeDbal" "at line" => 522 "entity" => null "error" => array:3 [ 0 => "42000" 1 => 1064 2 => "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'in (parents_id) ) OR `category_id`' at line 1" ] "request" => " SELECT COUNT(*) FROM `product` LEFT JOIN `shop` ON `shop`.id = product.shop_id LEFT JOIN `category` ON `category`.id = product.category_id LEFT JOIN `currency` ON `currency`.id = product.currency_id LEFT JOIN `tva` ON `tva`.id = product.tva_id LEFT JOIN `status` ON `status`.id = product.status_id LEFT JOIN `status` `adminstatus` ON `adminstatus`.id = product.adminstatus_id WHERE 1 AND `product`.cover > :this_cover AND `product`.cover IS NOT NULL and `product`.quantity > :this_quantity and status.position = :status_position and adminstatus.position = :adminstatus_position and `category_id` in ( select id from category where in (parents_id) ) OR `category_id` " "values" => array:4 [ "this_cover" => 0 "this_quantity" => 0 "status_position" => 1 "adminstatus_position" => 3 ] ]