--- top-level domains ---declare @atlds varchar(400)declare @btlds varchar(400)set @atlds = '(aero|am|as|ax|bg|biz|cat|cc|cf|cl|com|cz|de|dj|dk|edu|eu|fm|fo|gl|gm|gov|hm|info|jobs|km|la|md|mn|mp|mq|mr|nc|net|nu|org|si|sm|sn|sr|st|su|sz|td|tk|uz|vc|vu|ws)'set @btlds = '(ao|ar|bd|bn|br|co|cr|cy|do|eg|et|fj|fk|gh|gn|gu|id|il|jm|ke|kh|ki|kw|kz|lb|lc|lr|ls|ml|mm|mv|mw|mx|my|ng|ni|np|nz|om|pa|pe|pg|pw|py|qa|sa|sb|sv|sy|th|tn|tz|uk|uy|va|ve|ye|yu|za|zm|zw)'declare @category intdeclare @regex varchar(500)set @category = 32--set @regex = '^[A-z0-9-]+\.(com)$'set @regex = '^[A-z0-9-]+\.' + @atlds + '$'DECLARE @domains varchar(255)DECLARE domains_cursor CURSOR FOR --select id, str_domain, str_directory, n_lwmask, str_reviewer, date_modified select str_domain from tbl_webmask where b_deleted = 0 and n_lwmask = @category and str_directory = '/' and master.dbo.fn_pcre_match(str_domain, @regex) = 1OPEN domains_cursorFETCH NEXT FROM domains_cursor INTO @domainsWHILE @@FETCH_STATUS = 0BEGIN-- PRINT @domains declare @subdomains varchar(255) declare subdomains_cursor cursor for select str_domain from tbl_webmask where b_deleted = 0 and n_lwmask = @category and str_directory = '/' and str_domain like '%.' + @domains open subdomains_cursor fetch next from subdomains_cursor into @subdomains while @@FETCH_STATUS = 0 begin print @subdomains fetch next from subdomains_cursor into @subdomains end close subdomains_cursor deallocate subdomains_cursor FETCH NEXT FROM domains_cursor INTO @domainsENDCLOSE domains_cursorDEALLOCATE domains_cursor