SQL SELECT to match a searchterm in wp_terms but only from a specific taxonomy

new_gist_file_0

SELECT * FROM $termstable AS terms
            JOIN ".$wpdb->prefix."term_taxonomy AS termtax ON terms.term_id = termtax.term_id
            WHERE termtax.taxonomy = '$taxonomy'
            AND terms.name LIKE '%$searchterm%' COLLATE utf8_swedish_ci
            ORDER BY termtax.count DESC