SELECT b.idBaza, b.bazaName
FROM interimo_admin2019.ii_baze AS b
WHERE EXISTS (
SELECT 1 FROM interimo_imobile.of AS o
WHERE o.ofertaBaza = b.idBaza
AND o.activa = 1
AND o.ofertaDeleted = 0
)
ORDER BY b.bazaName
Apartamente de inchiriat Iasi 2 camere - pagina 1 - 121 anunturi
