| use dewiki_p;
SELECT cl_sortkey_prefix FROM categorylinks JOIN page ON... |
3 years ago |
| use dewiki_p;
SELECT cl_sortkey_prefix FROM categorylinks JOIN page ON... |
3 years ago |
| use dewiki_p;
SELECT cl_sortkey_prefix FROM categorylinks JOIN page ON... |
3 years ago |
| use dewiki_p;
SELECT * FROM categorylinks JOIN page ON page_id = cl_from... |
3 years ago |
| use dewiki_p;
SELECT IF(page_namespace = 14, 'category', 'article') as... |
3 years ago |
| use dewiki_p;
SELECT cl_to FROM categorylinks WHERE cl_to = 'Deutscher' LIMIT 100 |
3 years ago |
| use dewiki_p;
SELECT cl_to FROM categorylinks WHERE cl_to LIKE 'Deutsche%'... |
3 years ago |
| use dewiki_p;
SELECT cl_to FROM categorylinks WHERE cl_to LIKE 'Lebend%' LIMIT 1000 |
3 years ago |
| use dewiki_p;
SELECT cl_to FROM categorylinks WHERE cl_to LIKE 'Lebend%' LIMIT 10 |
3 years ago |
| use enwiki_p;
SELECT IF(page_namespace = 14, 'category', 'article') as... |
3 years ago |
| use dewiki_p;
SELECT IF(page_namespace = 14, 'category', 'article') as... |
3 years ago |
| use enwiki_p;
SELECT IF(page_namespace = 14, 'category', 'article') as... |
3 years ago |
| use enwiki_p;
SELECT IF(page_namespace = 14, 'category', 'article') as... |
3 years ago |
| use enwiki_p;
SELECT IF(page_namespace = 14, 'category', 'article') as... |
3 years ago |
| use enwiki_p;
SELECT IF(page_namespace = 14, 'category', 'article') as... |
3 years ago |
| use metawiki;
SELECT * FROM categorylinks JOIN page ON page_id = cl_from... |
3 years ago |
| use dewiki_p;
SELECT * FROM categorylinks JOIN page ON page_id = cl_from... |
3 years ago |
| use dewiki_p;
SELECT page_title FROM categorylinks JOIN page ON page_id =... |
3 years ago |
| use dewiki_p;
SELECT type, page_title FROM categorylinks JOIN page ON... |
3 years ago |
| use dewiki_p;
SELECT IF(page_namespace = 14, 'category', 'article') as... |
3 years ago |
| USE metawiki_p; SELECT cl_to, cl_from FROM categorylinks WHERE cl_to LIKE... |
3 years ago |
| USE metawiki_p; SELECT cl_to, cl_from FROM categorylinks ORDER BY... |
3 years ago |
| USE metawiki_p; SELECT cl_to, cl_from FROM categorylinks ORDER BY... |
3 years ago |
| USE metawiki_p; SELECT * FROM categorylinks LIMIT 10; |
3 years ago |
| USE metawiki_p; SELECT * FROM categorylinks LIMIT 10; |
3 years ago |
| USE metawiki_p; SELECT cat_title FROM category WHERE... |
3 years ago |
| USE metawiki_p; SELECT cat_title FROM category WHERE cat_title LIKE... |
3 years ago |
| USE metawiki_p; SELECT cat_title FROM category WHERE cat_title LIKE 'L%' LIMIT 10; |
3 years ago |
| USE metawiki_p; SELECT cat_title FROM category WHERE cat_title='Living... |
3 years ago |
| USE metawiki_p; SELECT cat_title FROM category WHERE cat_title LIKE 'living... |
3 years ago |
| USE metawiki_p; SELECT cat_title FROM category WHERE cat_title LIKE 'living'... |
3 years ago |
| USE metawiki_p; SELECT cat_title FROM category WHERE cat_title LIKE 'LP' LIMIT 10; |
3 years ago |
| USE metawiki_p; SELECT * FROM category WHERE cat_title='LP' LIMIT 10; |
3 years ago |
| USE metawiki_p; SELECT * FROM category WHERE category_id='LP' LIMIT 10; |
3 years ago |
| USE metawiki_p; SELECT * FROM category WHERE category='LP' LIMIT 10; |
3 years ago |
| USE metawiki_p; SELECT * FROM category LIMIT 10; |
3 years ago |
