SELECT SQL_CALC_FOUND_ROWS uqsbx_2_posts.ID FROM uqsbx_2_posts LEFT JOIN uqsbx_2_term_relationships ON (uqsbx_2_posts.ID = uqsbx_2_term_relationships.object_id) WHERE 1=1 AND ( uqsbx_2_term_relationships.term_taxonomy_id IN (810) ) AND uqsbx_2_posts.post_type = 'team' AND ((uqsbx_2_posts.post_status = 'publish')) GROUP BY uqsbx_2_posts.ID ORDER BY CAST( IF((SELECT COUNT(team_ordering.post_id) FROM uqsbx_2_postmeta as team_ordering WHERE (team_ordering.meta_key='team_ordering_default') AND team_ordering.post_id=uqsbx_2_posts.ID LIMIT 1)>0, (SELECT team_ordering.meta_value FROM uqsbx_2_postmeta as team_ordering WHERE (team_ordering.meta_key='team_ordering_default') AND team_ordering.post_id=uqsbx_2_posts.ID LIMIT 1), 999999) AS SIGNED) ASC, uqsbx_2_posts.post_title ASC LIMIT 0, 12