-logy adjective redirect query

SQL

#select page_title from page right join redirect on page_id=rd_from where page_namespace=0 and page_title like "%logical" and rd_title=replace(page_title,"logical","logy");
#select page_title from page where page_namespace=0 and page_title like "%logy" and not page_title like "%\_%" and replace(page_title,"logy","logical") not in (select page_title from page where page_namespace=0);

select page_title from page right join redirect on page_id=rd_from where page_namespace=0 and page_title like "%language\_group" and rd_title=replace(page_title,"language_group","languages");
SQL

Checking query status...
