Se ha producido un error en /busqueda_tramites.php - Error en stored procedure 1962 - sel_busqueda_tramites_filtros SQL= SELECT temacod AS codigo, COUNT(a.tramitecod) AS cantidad, "temas" AS categoria FROM tra_tramites_temas AS a INNER JOIN ( SELECT a.tramitecod FROM tra_tramites_publicados AS a LEFT JOIN tra_tramites_temas AS c ON a.tramitecod=c.tramitecod LEFT JOIN tra_tramites_acciones AS d ON a.tramitecod=d.tramitecod WHERE IF ("0", MATCH(a.tramitetitulo, a.tramitedescripcion, a.tramitetags, a.organismonombresigla) AGAINST ("" IN BOOLEAN MODE), 1) AND IF ("0",c.temacod = "",1) AND IF ("1", a.organismocod = "74",1) AND IF ("0", a.perfilcod = "",1) AND IF ("0", a.hechosvitalescod = "",1) AND IF ("1", d.accioncod = "1",1) AND IF ("0", a.tramiteacciones!="",1) GROUP BY tramitecod ) AS b ON a.tramitecod = b.tramitecod GROUP BY temacod UNION SELECT t.organismocod AS codigo,COUNT(sub.tramitecod) AS cantidad, "organismos" AS categoria FROM ( SELECT a.tramitecod FROM tra_tramites_publicados AS a LEFT JOIN tra_tramites_temas AS c ON a.tramitecod=c.tramitecod LEFT JOIN tra_tramites_acciones AS d ON a.tramitecod=d.tramitecod WHERE IF ("0", MATCH(a.tramitetitulo, a.tramitedescripcion, a.tramitetags, a.organismonombresigla) AGAINST ("" IN BOOLEAN MODE), 1) AND IF ("0",c.temacod = "",1) AND IF ("1", a.organismocod = "74",1) AND IF ("0", a.perfilcod = "",1) AND IF ("0", a.hechosvitalescod = "",1) AND IF ("1", d.accioncod = "1",1) AND IF ("0", a.tramiteacciones!="",1) GROUP BY tramitecod ) sub INNER JOIN tra_tramites_publicados t ON t.tramitecod=sub.tramitecod GROUP BY t.organismocod UNION SELECT t.perfilcod AS codigo,COUNT(per.tramitecod) AS cantidad, "perfiles" AS categoria FROM ( SELECT a.tramitecod FROM tra_tramites_publicados AS a LEFT JOIN tra_tramites_temas AS c ON a.tramitecod=c.tramitecod LEFT JOIN tra_tramites_acciones AS d ON a.tramitecod=d.tramitecod WHERE IF ("0", MATCH(a.tramitetitulo, a.tramitedescripcion, a.tramitetags, a.organismonombresigla) AGAINST ("" IN BOOLEAN MODE), 1) AND IF ("0",c.temacod = "",1) AND IF ("1", a.organismocod = "74",1) AND IF ("0", a.perfilcod = "",1) AND IF ("0", a.hechosvitalescod = "",1) AND IF ("1", d.accioncod = "1",1) AND IF ("0", a.tramiteacciones!="",1) GROUP BY tramitecod ) per INNER JOIN tra_tramites_publicados t ON t.tramitecod=per.tramitecod AND t.perfilcod IS NOT NULL GROUP BY t.perfilcod UNION SELECT t.hechosvitalescod AS codigo,COUNT(hec.tramitecod) AS cantidad, "hechosvitales" AS categoria FROM ( SELECT a.tramitecod FROM tra_tramites_publicados AS a LEFT JOIN tra_tramites_temas AS c ON a.tramitecod=c.tramitecod LEFT JOIN tra_tramites_acciones AS d ON a.tramitecod=d.tramitecod WHERE IF ("0", MATCH(a.tramitetitulo, a.tramitedescripcion, a.tramitetags, a.organismonombresigla) AGAINST ("" IN BOOLEAN MODE), 1) AND IF ("0",c.temacod = "",1) AND IF ("1", a.organismocod = "74",1) AND IF ("0", a.perfilcod = "",1) AND IF ("0", a.hechosvitalescod = "",1) AND IF ("1", d.accioncod = "1",1) AND IF ("0", a.tramiteacciones!="",1) GROUP BY tramitecod ) hec INNER JOIN tra_tramites_publicados t ON t.tramitecod=hec.tramitecod AND t.hechosvitalescod IS NOT NULL GROUP BY t.hechosvitalescod UNION SELECT accioncod AS codigo, COUNT(a.tramitecod) AS cantidad, "acciones" AS categoria FROM tra_tramites_acciones AS a INNER JOIN ( SELECT a.tramitecod FROM tra_tramites_publicados AS a LEFT JOIN tra_tramites_temas AS c ON a.tramitecod=c.tramitecod LEFT JOIN tra_tramites_acciones AS d ON a.tramitecod=d.tramitecod WHERE IF ("0", MATCH(a.tramitetitulo, a.tramitedescripcion, a.tramitetags, a.organismonombresigla) AGAINST ("" IN BOOLEAN MODE), 1) AND IF ("0",c.temacod = "",1) AND IF ("1", a.organismocod = "74",1) AND IF ("0", a.perfilcod = "",1) AND IF ("0", a.hechosvitalescod = "",1) AND IF ("1", d.accioncod = "1",1) AND IF ("0", a.tramiteacciones!="",1) GROUP BY tramitecod ) AS b ON a.tramitecod = b.tramitecod GROUP BY accioncod UNION SELECT 1 AS codigo,COUNT(otrasacciones.tramitecod) AS cantidad, "enlinea" AS categoria FROM ( SELECT a.tramitecod FROM tra_tramites_publicados AS a LEFT JOIN tra_tramites_temas AS c ON a.tramitecod=c.tramitecod LEFT JOIN tra_tramites_acciones AS d ON a.tramitecod=d.tramitecod WHERE IF ("0", MATCH(a.tramitetitulo, a.tramitedescripcion, a.tramitetags, a.organismonombresigla) AGAINST ("" IN BOOLEAN MODE), 1) AND IF ("0",c.temacod = "",1) AND IF ("1", a.organismocod = "74",1) AND IF ("0", a.perfilcod = "",1) AND IF ("0", a.hechosvitalescod = "",1) AND IF ("1", d.accioncod = "1",1) AND IF ("0", a.tramiteacciones!="",1) GROUP BY a.tramitecod ) otrasacciones INNER JOIN tra_tramites_publicados t ON t.tramitecod=otrasacciones.tramitecod AND t.tramiteacciones!="" ORDER BY categoria, cantidad DESC Error Mysql: 144 - Table './tramites/tra_tramites_publicados' is marked as crashed and last (automatic?) repair failedProblema en la ejecución del stored procedure. Error al realizar la busqueda.