SELECT
    id as Id,
    nombre as {$MULTILANG_Nombre},
    (SELECT COUNT(*) FROM core_formulario WHERE modulo=core_modulos_app.id) as Frm,
    (SELECT COUNT(*) FROM core_informe WHERE modulo=core_modulos_app.id) as Inf,
    descripcion as {$MULTILANG_Detalles},
    desarrolladores as "{$MULTILANG_UsuariosAdmin}"
FROM
    core_modulos_app

UNION

SELECT
    "0" as Id,
    "<b>_HUERFANOS_</b>" as {$MULTILANG_Nombre},
    (SELECT COUNT(*) FROM core_formulario WHERE modulo=0 AND id>0) as Frm,
    (SELECT COUNT(*) FROM core_informe WHERE modulo=0 AND id>0) as Inf,
    "<font color=red>Elementos tipo formulario y/o informe sin ser asignados a un modulo</font>" as {$MULTILANG_Detalles},
    "" as "{$MULTILANG_UsuariosAdmin}"

