SELECT term_data.tid AS tid,
   term_lineage.lineage AS term_lineage_lineage,
   node_term_node.title AS node_term_node_title,
   node_term_node.nid AS node_term_node_nid,
   node_term_node_node_data_field_site_url.field_site_url_url AS node_term_node_node_data_field_site_url_field_site_url_url,
   node_term_node_node_data_field_site_url.field_site_url_title AS node_term_node_node_data_field_site_url_field_site_url_title,
   node_term_node_node_data_field_site_url.field_site_url_attributes AS node_term_node_node_data_field_site_url_field_site_url_attributes,
   node_term_node.type AS node_term_node_type,
   node_term_node.vid AS node_term_node_vid
 FROM sled_term_data term_data 
 LEFT JOIN sled_term_node term_node ON term_data.tid = term_node.tid
 LEFT JOIN sled_node node_term_node ON term_node.vid = node_term_node.vid
 LEFT JOIN sled_term_hierarchy term_hierarchy ON term_data.tid = term_hierarchy.tid
 INNER JOIN sled_term_data term_data_term_hierarchy ON term_hierarchy.parent = term_data_term_hierarchy.tid
 INNER JOIN sled_content_field_site_cats node_term_node_node_data_field_site_cats ON node_term_node.vid = node_term_node_node_data_field_site_cats.vid
 LEFT JOIN sled_term_lineage term_lineage ON term_data.tid = term_lineage.tid
 LEFT JOIN sled_content_field_site_url node_term_node_node_data_field_site_url ON node_term_node.vid = node_term_node_node_data_field_site_url.vid
 WHERE (node_term_node.status <> 0) AND (node_term_node.type in ('publish')) AND (term_data.vid in ('1')) AND (node_term_node_node_data_field_site_cats.field_site_cats_value IN ('72', '146')) AND (node_term_node.vid IN (
  SELECT tn.vid FROM sled_term_node tn
    LEFT JOIN sled_term_hierarchy th ON th.tid = tn.tid
    LEFT JOIN sled_term_hierarchy th1 ON th.parent = th1.tid
    LEFT JOIN sled_term_hierarchy th2 ON th1.parent = th2.tid
    LEFT JOIN sled_term_hierarchy th3 ON th2.parent = th3.tid
    LEFT JOIN sled_term_hierarchy th4 ON th3.parent = th4.tid
    LEFT JOIN sled_term_hierarchy th5 ON th4.parent = th5.tid
  WHERE tn.tid = 12
    OR th1.tid = 12
    OR th2.tid = 12
    OR th3.tid = 12
    OR th4.tid = 12
    OR th5.tid = 12
  ))
   ORDER BY term_lineage_lineage ASC, node_term_node_title ASC