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;