select {wp_terms}.term_id,
       {wp_terms}.name,
       wp_term_taxonomy.taxonomy,
       wp_term_taxonomy.count

from {wp_terms}

left outer join {wp_term_taxonomy} wp_term_taxonomy
on {wp_terms}.term_id = wp_term_taxonomy.term_id

/* the recognizedCategories variable holds user defined taxonomies */
where ( wp_term_taxonomy.taxonomy = 'category' or lower({wp_terms}.name) in ({recognizedCategories}) 
        or lower(wp_term_taxonomy.taxonomy) in ({recognizedCategories}) )
      and wp_term_taxonomy.count >= 1

/* only include this line if an ID has been specified. e.g.
      and wp_terms.term_id = 74
      {term_id}
/*  */

order by {wp_terms}.name