Find number of external links that probably point to site index (1)

SQL

CREATE TABLE `domains` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `domains_domain_unique` (`domain`),
  KEY `domains_title_index` (`title`),
  KEY `domains_lang_index` (`lang`)
) ENGINE=InnoDB AUTO_INCREMENT=466664 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SQL

Checking query status...