| SELECT *
FROM categorylinks limit 1; |
9 months ago |
| SELECT *
FROM category limit 1; |
9 months ago |
| SELECT count(distinct(cat_title))
FROM category; |
9 months ago |
| SELECT count(cat_title)
FROM category; |
9 months ago |
| SELECT cat_title
FROM category; |
9 months ago |
| SELECT cat_title
FROM categories |
9 months ago |
| SELECT cat_title
FROM categories |
9 months ago |
| SELECT cat_title
FROM categories |
9 months ago |
| SELECT cat_title
FROM categories |
9 months ago |
| SELECT cat_title
FROM categories |
9 months ago |
| SELECT cat_title
FROM categories |
9 months ago |
| SELECT *
FROM categories |
9 months ago |
| SELECT +
FROM categories |
9 months ago |
|
WITH RECURSIVE CategoryTree AS (
SELECT
cl_from AS page_id,
cl_to... |
9 months ago |
| USE enwiki;
-- Replace 'Your_Category_Name' with the name of the category... |
9 months ago |
| SELECT cl_to, COUNT(*) as count
FROM categorylinks
WHERE cl_from = (SELECT... |
9 months ago |
| SELECT cl_to, COUNT(*) as count
FROM categorylinks
WHERE cl_from = (SELECT... |
9 months ago |
| USE enwiki;
-- Replace 'Your_Article_Title' with the title of the Wikipedia... |
9 months ago |
| SELECT cl_to
FROM categorylinks
WHERE cl_from = (SELECT page_id FROM page... |
9 months ago |
| SELECT cl_to
FROM categorylinks
WHERE cl_from = (SELECT page_id FROM page... |
9 months ago |
| SELECT cl_to
FROM categorylinks
WHERE cl_from = (SELECT page_id FROM page... |
9 months ago |
