destacadas
1221 - Incorrect usage of UNION and LIMIT

SELECT imagen, nombre_seccion, titulo, id_noticia, bajada, donde, carpeta_donde FROM ( SELECT c.imagen, c.id_carrera AS id_noticia, c.titulo, '' AS bajada, 'Carreras' AS nombre_seccion, 'carrera' AS donde, 3 AS permanente, '2112-05-05' AS fecha, 'carreras' as carpeta_donde FROM carreras c WHERE c.destacada =1 AND c.mostrar = 1 LIMIT 2 UNION SELECT n.imagen, n.id_noticia, n.titulo, n.bajada, s.descripcion_pl AS nombre_seccion, 'nota' AS donde, n.permanente, n.fecha, 'noticias' as carpeta_donde FROM noticias n, sub_secciones s WHERE n.id_sub_seccion = s.id_sub_seccion AND n.id_seccion = s.id_seccion AND n.mostrar =1 AND n.destacada =1 ORDER BY permanente DESC , fecha DESC ) TEMP LIMIT 5

[TEP STOP]