-- Solo lectura. Verificar despues de 01 y 02.
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA=DATABASE()
  AND (TABLE_NAME LIKE 'hist_ancheteria_%'
       OR TABLE_NAME='hist_ordenes_ancheteria'
       OR TABLE_NAME IN ('ancheteria_temporadas','ancheteria_cierres','ancheteria_cierre_eventos'))
ORDER BY TABLE_NAME;

SELECT COUNT(*) AS temporadas_configuradas FROM ancheteria_temporadas;
SELECT COUNT(*) AS ordenes_sin_temporada FROM ordenes_ancheteria WHERE temporada_id IS NULL;
SELECT COUNT(*) AS historico_ordenes_inicial FROM hist_ordenes_ancheteria;
SELECT COUNT(*) AS cierres_iniciales FROM ancheteria_cierres;
SELECT COUNT(*) AS eventos_iniciales FROM ancheteria_cierre_eventos;

SELECT o.nombre,o.ruta,o.icono,p.nombre AS padre,r.nombre AS rol
FROM opcion o
LEFT JOIN opcion p ON p.id=o.opcion_padre_id
LEFT JOIN rol_permiso_opcion rpo ON rpo.opcion_id=o.id
LEFT JOIN rol r ON r.id=rpo.rol_id
WHERE o.ruta IN (
  '/cierreancheteria/index','/reportesancheteria/index',
  '@perm:ancheteria-cierre-temporada','@perm:ancheteria-reportes-historicos'
)
ORDER BY o.ruta,r.nombre;