Untitled query #13349

This query is marked as a draft This query has been published by FShbib.

SQL

use arwiki_p;
select concat('# [[:ملف:', replace(page_title, "_", " "), ']]') as file_title
from page as p1
join image 
on exists (select *
           from categorylinks as cl1
           where cl_from = page_id
           and (cl_to = "ملصقات_الاستعمال_العادل"))
where img_width > 220
#and page_id IN (SELECT tl_from FROM templatelinks where tl_title = 'ملصق')
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.

SQL

Checking query status...