Untitled query #27563

SQL

-- select * from plwiki_p.user where user_name = 'Mały dobosz'

-- select * from plwiki_p.page where page_namespace = 2 and page_title = 'Basshuntersw'
-- select * from plwiki_p.pagelinks where pl_namespace =2 and pl_title = 'Basshuntersw';
-- select * from plwiki_p.revision where rev_user = 89373

-- select user_id, user_name from plwiki_p.user usersjoin
-- select replace(log_title, '_', ' ') as uname from plwiki_p.logging where log_type = 'thanks' limit 100
select log_page from plwiki_p.logging where log_type = 'thanks' as t
 left join select page_id, page_namespace, page_title from plwiki_p.page as p
 on t.log_page = p.page_id
SQL

Checking query status...
