SELECT producer.*, tools.* FROM producer, tools, techtypes, type_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 tools.prod_id=producer.prod_id
AND type_line.type_id=techtypes.type_id
AND tools.tool_name=type_line.tool_name)
)
)
AND tools.prod_id=producer.prod_id
GROUP BY tools.tool_name