رده:حما - Quarry

SQL

select concat ('*[[:رده:',page_title,']]>[[:رده:',REPLACE (page_title,"حما","حماة"),']]') from page
where page_namespace = 14
and  page_title like '%حما%'
and not page_title like '%حمات%'
and not page_title like '%حماه%'
and not page_title like '%حماة%'
and not page_title like '%حمام%'
and not page_title like '%حمان%'
and not page_title like '%حماس%'
and not page_title like '%حمای%'
and not page_title like '%حماد%'
and not page_title like '%حمار%'
and not page_title like '%حماق%'
and page_is_redirect = 0
SQL

Checking query status...
