Untitled query #18692

SQL

use hewiki_p;
select studwork.page_title, rev_timestamp, concat('[[מיוחד:הבדל/', rev_id, ']]') from revision_userindex inner join page studwork on studwork.page_id=rev_page inner join pagelinks on pl_title=studwork.page_title and pl_namespace=(page_namespace-page_namespace%2) inner join page proj on proj.page_id=pl_from where rev_page=studwork.page_id and rev_user=90459 and proj.page_title like 'עבודות_ויקידמיות/%חיפה' and (studwork.page_namespace=0 or studwork.page_namespace=2 or studwork.page_namespace=118 or studwork.page_namespace=1 or studwork.page_namespace=3 or studwork.page_namespace=119) and (studwork.page_title like '%/%' or (studwork.page_namespace!=2 and studwork.page_namespace!=3)) group by rev_id order by rev_timestamp;
SQL

Checking query status...
