SQL = SELECT * FROM `baza` where `VIZIBIL` > 1 and `VIZIBIL` != 2801 and `COD` not like 'Timis' and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' arsis* trading*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "srl %" or `FIRMA` like "srl %" or `OBIECT_ACTIVITATE` like "% srl %" or `FIRMA` like "% srl %") or (`OBIECT_ACTIVITATE` like "srl,%" or `FIRMA` like "srl,%" or `OBIECT_ACTIVITATE` like "% srl,%" or `FIRMA` like "% srl,%" or `OBIECT_ACTIVITATE` like "% srl" or `FIRMA` like "% srl")) order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: Autorizari ISCIR, proiectare si service instalatii, centrale termice, cazane, aer conditionat, panouri solare, reprezentanta vanzari cazane pe lemn si microcentrale BAXI, WESTEN, BOSCH, BUDERUS, DE DIETRICH, BERETTA, PROTHERM, ARISTON, IMMERGAS, reparatii centrale termice
Expresii si cuvinte cheie: Hale industriale, executie hale industriale, fabricare hale industriale, confectionare hale industriale, productie hale industriale, producator hale, executie hale, sudura hale