describe page; |
4 years ago |
describe category; |
4 years ago |
show tables where table like '%cat%'; |
4 years ago |
show tables;
|
4 years ago |
show databases; |
4 years ago |
select
(select cat_id from category
where cat_title like... |
4 years ago |
select * from category where cat_title like '%21st%Finnish%businesspeople%' limit 20; |
4 years ago |
select cat_id, cat_title from category where cat_title like... |
4 years ago |
select cat_id, cat_title from category where cat_title like... |
4 years ago |
select cat_id, cat_title from category where cat_title like '%21st%eople%' limit 20; |
4 years ago |
select cat_id, cat_title from category where cat_title like '%eople%' limit 20; |
4 years ago |
select cat_id, cat_title from category limit 20; |
4 years ago |
select car_id, cat_title from category limit 20; |
4 years ago |
select car_id, cat_title from catgory limit 20; |
4 years ago |
select rd_from, rd_title
from redirect
where rd_from like
(select page_id
... |
4 years ago |
select rd_from, rd_title from redirect where rd_from like (select page_title... |
4 years ago |
select page_title as 'sivuja' from page where page_title like... |
4 years ago |
select count(page_title) as 'sivuja' from page where page_title like... |
4 years ago |
select count(page_title) as 'sivuja' from page where page_title like... |
4 years ago |
select count(page_title) as 'sivuja' from page where page_title like... |
4 years ago |
select count(page_title) as 'sivuja' from page where page_title like '%Trump%'; |
4 years ago |
select count(page_title) as 'sivuja' from page where page_title like... |
4 years ago |
select page_title as 'sivuja' from page where page_title like '%Tito%Tarantula%'; |
4 years ago |
select count(sivuja) from (select page_title as 'sivuja' from page where... |
4 years ago |
blank query |
4 years ago |
select count(sivuja) from (select page_is_redirect, page_title from page... |
4 years ago |
select count(sivuja) from (select page_is_redirect, page_title as 'sivuja'... |
4 years ago |
select count(sivuja) from (select page_is_redirect as 'redirect', page_title... |
4 years ago |
select count(sivuja) from (select page_is_redirect as redirect, page_title... |
4 years ago |
select count(sivuja) from (select page_is_redirect, page_title as sivuja... |
4 years ago |
select count(sivuja) from (select page_is_redirect, page_title from page... |
4 years ago |
select count(select page_is_redirect, page_title from page where page_title... |
4 years ago |
select page_is_redirect, page_title from page where page_title like... |
4 years ago |
select page_is_redirect from page group by page_is_redirect limit 20; |
4 years ago |
select redirect.rd_from, redirect.rd_title, page.page_id, page.page_title,... |
4 years ago |
select redirect.rd_from, redirect.rd_title, page.page_id, page.page_title,... |
4 years ago |
select redirect.rd_from, redirect.rd_title, page.page_id, page.page_title,... |
4 years ago |
select redirect.rd_from, redirect.rd_title, archive.ar_id,... |
4 years ago |
select * from redirect limit 20; |
4 years ago |
describe redirect; |
4 years ago |
select pt_namespace, pt_title, pt_reason_id from protected_titles where... |
4 years ago |
select pt_namespace, pt_title, pt_reason_id from protected_titles limit 20; |
4 years ago |
describe protected_titles; |
4 years ago |
select pt_namespace, pt_title, pt_reason from protected_titles where... |
4 years ago |
select pt_namespace, pt_title from protected_titles where pt_namespace > 20 limit 20; |
4 years ago |
select pt_namespace, pt_title from protected_titles where pt_namespace >... |
4 years ago |