SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' traducer* text* italia* roma*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "din %" or `FIRMA` like "din %" or `OBIECT_ACTIVITATE` like "% din %" or `FIRMA` like "% din %") or (`OBIECT_ACTIVITATE` like "din,%" or `FIRMA` like "din,%" or `OBIECT_ACTIVITATE` like "% din,%" or `FIRMA` like "% din,%" or `OBIECT_ACTIVITATE` like "% din" or `FIRMA` like "% din")) or ((`OBIECT_ACTIVITATE` like "259 %" or `FIRMA` like "259 %" or `OBIECT_ACTIVITATE` like "% 259 %" or `FIRMA` like "% 259 %") or (`OBIECT_ACTIVITATE` like "259,%" or `FIRMA` like "259,%" or `OBIECT_ACTIVITATE` like "% 259,%" or `FIRMA` like "% 259,%" or `OBIECT_ACTIVITATE` like "% 259" or `FIRMA` like "% 259")) or ((`OBIECT_ACTIVITATE` like "259 %" or `FIRMA` like "259 %" or `OBIECT_ACTIVITATE` like "% 259 %" or `FIRMA` like "% 259 %") or (`OBIECT_ACTIVITATE` like "259,%" or `FIRMA` like "259,%" or `OBIECT_ACTIVITATE` like "% 259,%" or `FIRMA` like "% 259,%" or `OBIECT_ACTIVITATE` like "% 259" or `FIRMA` like "% 259")) and `COD` like 'Bihor%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: Cazare pensiune, PASTRAVARIE si pensiune turistica, PASTRAVI proaspeti, preparate pastrav, peste proaspat, restaurant si sala conferinte, teren sport, trasee turistice, partii ski, statiuni montane, liniste, agroturism, turism Maramures
Expresii si cuvinte cheie: Perdele si draperii, metraje, croitorie textile, materiale croitorie, confectii croitorie, mercerie, decoruri, decor camera, decor fereastra, storuri, rolete, perdele lamelare, jaluzele, accesorii si feronerie, sina si suport perdea si draperie, sina cu telecomanda, sine profesionale, galerii, lenjerii pat, fete masa, seturi cafea si tacamuri masa, idei si consultanta amenajari si decoratiuni interioare, personalizare locuinte, restaurante, pensiuni, hoteluri, birouri si spatii comerciale