Fork of
ss
by Mr. Ibrahem
This query is marked as a draft
This query has been published
by Mr. Ibrahem.
SQL
x
/*select
CONCAT("Category:",p1.page_title) AS title , ll_title
from page AS p1, langlinks
where p1.page_title like "%heatre_people%"
AND p1.page_id = ll_from
AND ll_lang = "ar"
LIMIT 1000;
*/
select
CONCAT("Category:",p1.page_title) AS title , ll_title
from page AS p1, langlinks
#where p1.page_title like "%tage_actors%" AND ll_title like "%مسرحيون%"
#where p1.page_title like "%film_directors%" AND ll_title like "%مخرجون_%"
#where p1.page_title like "%Energy_infrastructure_in_%" AND ll_title like "%الطاقة_في_%"
#where p1.page_title like "%at_multi-sport_events%" AND ll_title like "%أحداث_رياضية_متعددة_في%"
#where p1.page_title like "%adapted_into%"
#AND ll_title like "%حدائق%"
where p1.page_title like "%players%" AND ll_title like "%حكام%"
AND p1.page_id = ll_from
AND ll_lang = "ar"
LIMIT 1000;
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.