sponsors

SELECT DISTINCT IFNULL(continent.term_id,place.term_id) AS term_id, IFNULL(continent.name, place.name) AS name, NULLIF(place.name,continent.name) AS place, sslhla_posts.ID, sslhla_posts.post_title FROM sslhla_term_relationships countries INNER JOIN sslhla_term_taxonomy country ON countries.term_taxonomy_id = country.term_taxonomy_id INNER JOIN sslhla_terms place ON country.term_id = place.term_id LEFT OUTER JOIN sslhla_terms continent ON country.parent = continent.term_id RIGHT OUTER JOIN sslhla_posts ON countries.object_id = sslhla_posts.ID RIGHT OUTER JOIN sslhla_postmeta year ON year.post_id = sslhla_posts.ID RIGHT OUTER JOIN sslhla_postmeta nomwin ON nomwin.post_id = sslhla_posts.ID RIGHT OUTER JOIN sslhla_term_relationships sectors ON sectors.object_id = sslhla_posts.ID INNER JOIN sslhla_term_taxonomy sector ON sector.term_taxonomy_id = sectors.term_taxonomy_id WHERE sector.term_id = and year.meta_value = 2015