use commonswiki_p; select p1.page_title from categorylinks c1 inner join categorylinks c2 on c2.cl_from = c1.cl_from inner join page p1 on p1.page_id = c2.cl_from inner join page p2 on p2.page_title = c2.cl_to and p2.page_namespace = 14 left join page_props on pp_propname = 'hiddencat' and pp_page = p2.page_id where c1.cl_to = '2015_Royal_International_Air_Tattoo' and pp_propname is null group by p1.page_title, c1.cl_from having count(c2.cl_from) = 1