SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' benz* bucurest*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "led %" or `FIRMA` like "led %" or `OBIECT_ACTIVITATE` like "% led %" or `FIRMA` like "% led %") or (`OBIECT_ACTIVITATE` like "led,%" or `FIRMA` like "led,%" or `OBIECT_ACTIVITATE` like "% led,%" or `FIRMA` like "% led,%" or `OBIECT_ACTIVITATE` like "% led" or `FIRMA` like "% led")) and `COD` like 'Valcea%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: DREPT CIVIL, DREPT PENAL, DREPT COMERCIAL, REGISTRUL COMERTULUI, OFICIUL DE CADASTRU, RECUPERARI DE CREANTE - PERSOANE FIZICE SI JURIDICE, RECUPERARE DOSARE DAUNE AUTO
Expresii si cuvinte cheie: Retele infrastructura, drumuri si poduri, proiectare si executie constructii civile, centre comerciale, hale industriale, benzinarii, confectii metalice, instalatii apa, gaz, electrice, incalzire, energie solara, CASA VERDE, lucrari inchidere si ecologizare perimetre miniere
Expresii si cuvinte cheie: Autogara BETA Cluj Napoca, transport calatori, curse regulate spre Baia Mare, Oradea, Botosani, Deva, Brasov, Bucuresti - rute interne si Ungaria, Germania, Spania, Italia, Franta - rute internationale