Fork of
Untitled query #57225
by لوقا
This query is marked as a draft
This query has been published
by Nehaoua.
SQL
x
# عدد الصفحات
select count(DISTINCT(el_from)) as num_pages from externallinks
where el_to like "%rasoolona.com%"
and (el_to not like "%archive.org%");
# عدد الروابط بعد حذف المكرر
select count(DISTINCT(el_to)) as num_links from externallinks
where el_to like "%rasoolona.com%"
and (el_to not like "%archive.org%");
# عدد الروابط
select count(el_to) as num_links from externallinks
where el_to like "%rasoolona.com%"
and (el_to not like "%archive.org%");
# عدد الروابط مع الارشف
select count(el_to) as num_links from externallinks
where el_to like "%rasoolona.com%"
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.