Хабр Курсы для всех
РЕКЛАМА
Практикум, Хекслет, SkyPro, авторские курсы — собрали всех и попросили скидки. Осталось выбрать!
Говорят, что данный пункт был «впихнут» в оферту аккурат 1 июня 2018 года.

















+---------------+-------+
| Registrant | count |
+---------------+-------+
| regformat-ru | 1 |
| pn-ru | 2 |
| beeline-ru | 4 |
| dr-ru | 5 |
| netfox-ru | 12 |
| 101domain-ru | 46 |
| runet-ru | 65 |
| openprov-ru | 140 |
| realtime-ru | 162 |
| rd-ru | 171 |
| uninic-ru | 183 |
| nethouse-ru | 205 |
| fe-ru | 207 |
| domenus-ru | 214 |
| centralreg-ru | 216 |
| webnames-ru | 229 |
| domainshop-ru | 233 |
| aab-ru | 241 |
| atex-ru | 308 |
| timeweb-ru | 346 |
| domainer-ru | 364 |
| naunet-ru | 593 |
| salenames-ru | 744 |
| regtime-ru | 1492 |
| axelname-ru | 1592 |
| ardis-ru | 2400 |
| active-ru | 3471 |
| ru-center-ru | 5937 |
| r01-ru | 8258 |
| beget-ru | 8949 |
+---------------+-------++---------------+-------+
| Registrant | count |
+---------------+-------+
| demos-ru | 1 |
| dr-ru | 3 |
| pn-ru | 4 |
| relcomhost-ru | 39 |
| atex-ru | 63 |
| 101domain-ru | 64 |
| beeline-ru | 74 |
| realtime-ru | 83 |
| domainshop-ru | 86 |
| runet-ru | 92 |
| active-ru | 119 |
| fe-ru | 126 |
| openprov-ru | 126 |
| aab-ru | 139 |
| agava-ru | 157 |
| uninic-ru | 166 |
| domainer-ru | 166 |
| beget-ru | 242 |
| reggi-ru | 308 |
| centralreg-ru | 332 |
| webnames-ru | 414 |
| netfox-ru | 591 |
| salenames-ru | 673 |
| domenus-ru | 868 |
| axelname-ru | 1375 |
| rd-ru | 2282 |
| ardis-ru | 3027 |
| naunet-ru | 3511 |
| nethouse-ru | 3537 |
| regtime-ru | 6463 |
| r01-ru | 17104 |
| ru-center-ru | 24992 |
+---------------+-------++--------------+-------+
| Registrant | count |
+--------------+-------+
| atex-ru | 1 |
| realtime-ru | 1 |
| salenames-ru | 1 |
| fe-ru | 1 |
| rd-ru | 1 |
| domenus-ru | 1 |
| ardis-ru | 4 |
| regtime-ru | 4 |
| axelname-ru | 5 |
| active-ru | 11 |
| ru-center-ru | 19 |
| r01-ru | 20 |
| regru-ru | 242 |
+--------------+-------++---------------+-------+
| Registrant | count |
+---------------+-------+
| aab-ru | 1 |
| openprov-ru | 1 |
| relcomhost-ru | 1 |
| active-ru | 1 |
| runet-ru | 1 |
| agava-ru | 2 |
| domainshop-ru | 2 |
| uninic-ru | 2 |
| webnames-ru | 8 |
| salenames-ru | 11 |
| centralreg-ru | 13 |
| 101domain-ru | 14 |
| axelname-ru | 15 |
| netfox-ru | 20 |
| reggi-ru | 22 |
| ardis-ru | 33 |
| domenus-ru | 45 |
| naunet-ru | 79 |
| nethouse-ru | 146 |
| rd-ru | 272 |
| regtime-ru | 359 |
| r01-ru | 1161 |
| ru-center-ru | 1779 |
| regru-ru | 8949 |
+---------------+-------+
-- домены которые за год унесены от beget
SELECT
dh1.registrant AS 'Registrant',
COUNT(*) AS count
FROM
domain_history AS dh1
WHERE
dh1.date_start <= '2018-07-01'
AND dh1.date_end > '2018-07-01'
AND dh1.registrant != 'beget-ru'
AND dh1.domain_id IN (SELECT
dh.domain_id
FROM
domain_history AS dh
WHERE
dh.date_start <= '2017-07-01'
AND dh.date_end > '2017-07-01'
AND dh.registrant = 'beget-ru')
GROUP BY dh1.registrant
ORDER BY COUNT(*);
-- домены которые перенесены в beget
SELECT
dh2.registrant AS 'Registrant', COUNT(*) AS count
FROM
domain_history AS dh2
WHERE
dh2.date_start <= '2017-07-01'
AND dh2.date_end > '2017-07-01'
AND dh2.domain_id IN (SELECT
dh1.domain_id
FROM
domain_history AS dh1
WHERE
dh1.date_start <= '2018-07-01'
AND dh1.date_end > '2018-07-01'
AND dh1.registrant = 'beget-ru'
AND dh1.domain_id IN (SELECT
dh.domain_id
FROM
domain_history AS dh
WHERE
dh.date_start <= '2017-07-01'
AND dh.date_end > '2017-07-01'
AND dh.registrant != 'beget-ru'))
GROUP BY dh2.registrant
ORDER BY COUNT(*);mysql -h manikin.beget.ru -P 3311 -u read_only -p read_only domain_statistic
Бывшие партнёры BeGet и Reg.ru требуют провести проверку друг у друга