SELECT * FROM alojamientos WHERE (pagado = 1) AND idciudad = AND destacado=1 ORDER BY rand() limit 3SELECT * FROM alojamientos WHERE (pagado = 1) AND idciudad IN (select id from ciudades WHERE idcircuito = ) AND destacado=1 ORDER BY rand() limit 4