Fork of
সংশোধিত ও অন্তর্ভুক্ত হয়নি
by Mahir256
This query is marked as a draft
This query has been published
by Bodhisattwa.
SQL
AخA
select concat("পাতা:", page_title), page_len
from page
join page_props
on pp_page = page_id
where pp_propname = 'proofread_page_quality_level'
and pp_value in (3, 4)
and page_namespace = 104
and page_title not in (
select lt_title
from templatelinks
join page on tl_from = page_id
join linktarget on tl_target_id = lt_id
where page_namespace = 0
)
order by page_title;
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.