little regex help needed

hello i am kind new to parser so i need little help i want to skip duplicate domains while scraping and want to skip some tlds as well while scraping how can i do that skipping duplicate domains like

support.google.com
this should only comes once not gain like not even google.com like this and i mean by skipping tlds like .br .vn .tw i want to skip these type of tlds and need ones more help i want to only extract those urls which have specific character like = sign or other

 

thanks lovely what about the filter for subdomains or scraping duplicate domans