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
-