We can have domains without submitted pages, looking only at the homepage, but not
the other way around.
Query: SELECT d.id AS DID ,s.* FROM et_domain_submissions s LEFT JOIN et_domains d ON d.domain = s.dsdomain WHERE d.domain IS NULL
1 Orphans ~ Domains without submission pages
| DID | id | dsdomain | dinactive | dsurl | dstype | dstimestamp |
|---|---|---|---|---|---|---|
| 26 | co.uk | 1 | https://dovermuseum.co.uk | html | 04th Feb 14:50 3 months |
(last activity recently ago)