Query fail: SELECT IFNULL(COUNT(CON.id_content),0) AS count FROM aux_tbl_con_searcher CON INNER JOIN tbl_con_content_category CAT ON CAT.id_category = CON.category_id LEFT JOIN tbl_con_content_meta AS MET ON MET.id_content = CON.id_content AND MET.estado = 'A' LEFT JOIN tbl_con_content_article_property_option AS APO ON APO.id_content = CON.id_content AND APO.id_property = 1 WHERE CON.estado = 'A' AND CON.ipublishedx = 1 AND CON.dpublished <= NOW() AND ( CON.id_type <> 1 OR (CON.id_type = 1 AND CON.value > 0) ) AND ( ( MATCH ( CON.title, CON.code, CON.attached_id, CON.description, CON.published, CON.brand, CON.type, CON.tags) AGAINST ( 'prensa hidraulica' ) ) OR (CON.code LIKE '%prensa hidraulica%' OR CON.title LIKE '%prensa hidraulica%' OR CON.description LIKE '%prensa hidraulica%' OR CON.brand LIKE '%prensa hidraulica%' ) ) AND CAT.root_direct LIKE '/%' AND CON.id_type = 1
-