SELECT
    id as Id,
    codigo_script as Codigo,
    lenguaje as Lenguaje,
    titulo as Titulo,
    fecha_creacion as FechaCreacion,
    (SELECT nombre FROM core_modulos_app WHERE core_scripts.moduloapp=core_modulos_app.id) as Modulo
FROM
    core_scripts
WHERE
    es_snippet=0
    AND 
    id >= 0
