Mine

Gia dokimase auto:

SELECT producer.*, tools.* FROM producer, tools, techtypes, type_line, usergroups, userg_line WHERE (
 (
 MATCH (tools.tool_name) AGAINST ('domotic')
 OR MATCH (producer.name) AGAINST ('domotic')
 OR MATCH (tools.description) AGAINST ('domotic')
 OR MATCH (tools.interoperability) AGAINST ('domotic')
 OR MATCH (tools.advantages) AGAINST ('domotic')
 OR MATCH (tools.disadvantages) AGAINST ('domotic')
 OR MATCH (tools.usability_issues) AGAINST ('domotic')
 OR MATCH (tools.method_use) AGAINST ('domotic')
 OR MATCH (tools.applications) AGAINST ('domotic')
 OR ((MATCH (techtypes.techtype) AGAINST ('domotic')
       AND type_line.type_id=techtypes.type_id
       AND tools.tool_name=type_line.tool_name))
 OR ((MATCH (usergroups.usergroup) AGAINST ('domotic')
       AND userg_line.userg_id=usergroups.userg_id
       AND tools.tool_name = userg_line.tool_name))
 )
)
AND tools.prod_id=producer.prod_id
GROUP BY tools.tool_name