SELECT c.id_canal, c.nombre_canal, c.id_categoria_canal, cp.nombre_categoria_programa, v.videoId, 
        v.duration, v.title, p.nombre_programa, p.idioma, c.mostrar_programas, c.idioma
        FROM alontv.canal AS c
        INNER JOIN alontv.canal_rel_programa AS crp USING (id_canal)
        INNER JOIN alontv.programa AS p USING (id_programa)
        LEFT JOIN alontv.categoria_programa AS cp ON (cp.id_categoria_programa=c.id_categoria_canal)
        INNER JOIN alontv.video AS v USING (id_programa)
        WHERE v.id_video = (
            SELECT id_video FROM alontv.programacion As pr
            WHERE fecha_inicio < NOW()  AND id_canal=c.id_canal
            ORDER BY fecha_inicio DESC 
            LIMIT 1
        ) AND c.id_categoria_canal=13 AND c.activo=1  AND c.idioma = ''