select node_name, domain_name from nodes where domain_name in (select
domain_name from bu_copygroups where integer(retextra) >365*4 and retextra
<>'NOLIMIT' or retextra = 'NOLIMIT' or integer(verexists) >365*4 and
verexists <>'NOLIMIT')

This looks at all the management classes in a domain and plays some games.
You need to verify that it works correctly.  What it does is selects the
domains with management classes that meet the criteria and matches against
the node definitions to give you a list.