Fork of
Untitled query #75197
by لوقا
This query is marked as a draft
This query has been published
by حبيشان.
SQL
AخA
select SUBSTRING_INDEX(REPLACE(el_to,"https://shamela.ws/book/",""), "/", 1) as bookid, count(*) as bookcount from externallinks
inner join page on page.page_id = externallinks.el_from
where el_to like "https://shamela.ws/book%"
and page.page_namespace in (0)
and page.page_is_redirect = 0
group by bookid;
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.