SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' echipament* router* mecanic* laser* bucurest*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "cnc %" or `FIRMA` like "cnc %" or `OBIECT_ACTIVITATE` like "% cnc %" or `FIRMA` like "% cnc %") or (`OBIECT_ACTIVITATE` like "cnc,%" or `FIRMA` like "cnc,%" or `OBIECT_ACTIVITATE` like "% cnc,%" or `FIRMA` like "% cnc,%" or `OBIECT_ACTIVITATE` like "% cnc" or `FIRMA` like "% cnc")) and `COD` like 'Bihor%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: Vanzari, cumparari, inchirieri regim hotelier, terenuri, case, vile, apartamente, garsoniere, spatii comerciale, birouri, hale, depozite in orice zona a Bucurestiului
Expresii si cuvinte cheie: Agentie imobiliara, tranzactii apartamente, case, vile, terenuri, spatii comerciale; consultanta, proiecte imobiliare si investitii proprii, publicitate in presa si Internet pentru proprietatea dumneavoastra, asistenta juridica, cadastru, intabulare si extras de carter funciara.