TU HOTEL EN MALLORCA

				
     select SQL_CALC_FOUND_ROWS c.id,c.titulo_es,m.url,sc.descripcion_es,c.tipo_alojamiento,c.categoria_alojamiento from contenido c
 inner join  subcategorias sc on sc.id = c.id_subcategoria inner join categorias ca on ca.id = sc.id_categoria inner join (select m.id,m.id_contenido,m.url from media m group by m.id,m.id_contenido,m.url 
) m on m.id_contenido = c.id 
 where ca.id = 3  group by c.id order by rand()  LIMIT 0, 12;