WikiZF

SELECT count(*) as total FROM library l INNER JOIN library_custom_fields lcf1 ON l.id = lcf1.library_fk WHERE l.template_id = 18002 AND lcf1.name = 'industrie' AND match(lcf1.value) against(?)