Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Bulgu
.
Toggle Highlighting
SQL
USE trwiki_p; SET @N = 15; SELECT fpp_page_id as id, round(timediff(now(),fpp_pending_since)/240000,3) as since, datediff(now(),fpp_pending_since) from flaggedpage_pending where fpp_page_id <> 26386 limit 10 ; /* SELECT concat("tr.wikipedia.org/wiki/Dosya:",replace(p.page_title," ","_")), c.cl_to, p.page_is_redirect from page p left join categorylinks c on c.cl_from = p.page_id where p.page_namespace = 6 and p.page_id NOT IN (select pp.page_id from page pp left JOIN categorylinks cc ON cc.cl_from = pp.page_id where cc.cl_to IN ("Tüm_adil_kullanım_dosyaları", "Adil_kullanım_sembolleri")) and c.cl_to is NULL and p.page_is_redirect = 0 limit 10; -- */ /* SELECT * from page p join iwlinks iwl on iwl.iwl_from = p.page_id where p.page_namespace = 6 and iwl.iwl_prefix like "c%" and iwl.iwl_title rlike "Image:" limit 10; */
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...