* Locals dintre d'un immoble concret (i no son immobles):
SELECT * FROM locals WHERE tipus NOT LIKE 'immoble' AND id IN (SELECT id_local FROM immoble_local) AND id = [id_immoble_concret]

* Locals que no estan dintre de cap immoble (i no son immobles): 
SELECT * FROM locals WHERE tipus NOT LIKE 'immoble' AND id NOT IN (SELECT id_local FROM immoble_local)
