Untitled query #18692

SQL

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

Checking query status...
