SQL = SELECT * FROM `baza` where `VIZIBIL` >= 1 and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST (' automat* programabi* bucurest*' IN BOOLEAN MODE)) or ((`OBIECT_ACTIVITATE` like "plc %" or `FIRMA` like "plc %" or `OBIECT_ACTIVITATE` like "% plc %" or `FIRMA` like "% plc %") or (`OBIECT_ACTIVITATE` like "plc,%" or `FIRMA` like "plc,%" or `OBIECT_ACTIVITATE` like "% plc,%" or `FIRMA` like "% plc,%" or `OBIECT_ACTIVITATE` like "% plc" or `FIRMA` like "% plc")) and `COD` like 'satu mare%' order by `CREDITE` desc, `TVA` desc, `DATA` desc
Expresii si cuvinte cheie: CLASS VENTILATION - importator produse ventilatie, ventilator inox, ventilator cu anemostat, tubulatura ventilatie si grila ventilatie