SELECT * FROM pagelinks
where pl_target_id is not null limit 100;
|
1 year ago |
SELECT * FROM pagelinks
where null pl_target_id limit 100;
|
1 year ago |
SELECT * FROM pagelinks
where not null pl_target_id limit 100;
|
1 year ago |
SELECT * FROM pagelinks
where pl_target_id not null limit 100;
|
1 year ago |
SELECT * FROM pagelinks
where pl_title>'Öst' limit 100;
|
1 year ago |
SELECT * FROM pagelinks
where pl_title>'Öst' limmit 100;
|
1 year ago |
SELECT * FROM pagelinks
limit 555555,100;
|
1 year ago |
SELECT * FROM pagelinks
limit 100;
|
1 year ago |
SELECT * FROM pagelinks
where pl_title like 'Ab%';
|
1 year ago |
SELECT * FROM pagelinks
where pl_title like 'Ab%';
|
1 year ago |
SELECT * FROM pagelinks
where pl_title like '58%';
|
1 year ago |
SELECT * FROM pagelinks
where pl_title like '%58%';
|
1 year ago |
SELECT * FROM pagelinks
where pl_title like '%558398%';
|
1 year ago |
SELECT * FROM pagelinks
where pl_title like '%558398%';
|
1 year ago |
SELECT * FROM pagelinks
where pl_title like '%5583%';
|
1 year ago |
SELECT * FROM pagelinks
where pl_title like '(5583%';
|
1 year ago |
SELECT page_title FROM page
left join flaggedpages on... |
1 year ago |
SELECT page_title FROM page
left join flaggedpages on... |
1 year ago |
SELECT page_title FROM page
left join flaggedpages on... |
1 year ago |
SELECT page_title FROM flaggedpages
left join page on... |
1 year ago |
USE huwiki_p;
SELECT page_namespace, page_title FROM page WHERE... |
5 years ago |
USE huwiki_p;
SELECT page_namespace, page_title FROM page WHERE... |
5 years ago |
USE huwiki_p;
SELECT page_namespace, page_title FROM page WHERE... |
5 years ago |
USE huwiki_p;
SELECT page_namespace, page_title FROM page WHERE... |
5 years ago |
USE huwiki_p;
SELECT page_namespace, page_title FROM page WHERE... |
5 years ago |