---

select t_tld.tld, t_domain.domain, t_subdomain.subdomain, '' || t_url.url || '' as url, max(t_ref_time.datetime) as datetime, max(t_ref_time.datetime) as inhalt, t_domain.domain as description, /* count(*),*/ 'Analyse Website in Domain: ' || t_subdomain.subdomain || '.' || t_domain.domain || '.' || t_tld.tld || ' - ' || count(*) || ' gefundene Links' as title, max(t_url.id) as urlid, '' || count(*) || '' as count from t_tld join t_ref on t_ref.tldid = t_tld.id join t_domain on t_domain.id = t_ref.domainid join t_subdomain on t_subdomain.id = t_ref.subdomainid join t_url on t_url.id = t_ref.urlid join t_ref_time on t_ref_time.refid = t_ref.id where domain = 'al-la' and subdomain = '' and tld = 'ch' group by t_tld.tld, t_domain.domain, t_subdomain.subdomain, t_url.url limit 20;