SELECT `t` . * , `tt` . * FROM `wp3_terms` AS `t` INNER JOIN `wp3_term_taxonomy` AS `tt` ON `t` . `term_id` = `tt` . `term_id` WHERE `tt` . `taxonomy` IN (?) AND `tt` . `count` > ? ORDER BY `tt` . `count` DESC LIMIT ? 