Mapa -
SELECT DISTINCT(t1.id) FROM alojamientos as t1 WHERE t1.visible = '0' AND t1.ciudad_id = '5' AND t1.tipo_alojamiento = 'hostal' ORDER BY t1.nombre
SELECT DISTINCT(t1.id) FROM alojamientos as t1 WHERE t1.visible = '0' AND t1.ciudad_id = '5' AND t1.tipo_alojamiento = 'apartamento' ORDER BY t1.nombre
SELECT DISTINCT(t1.id) FROM alojamientos as t1 WHERE t1.visible = '0' AND t1.ciudad_id = '5' AND t1.tipo_alojamiento = 'hotel' ORDER BY t1.nombre
SELECT DISTINCT(t1.id) FROM alojamientos as t1 WHERE t1.visible = '0' AND t1.ciudad_id = '5' AND t1.tipo_alojamiento = 'casa' ORDER BY t1.nombre
