SELECT cat_title, cat_pages, cat_subcats
FROM category
ORDER BY... |
5 years ago |
SELECT cat_title
FROM category
ORDER BY cat_pages DESC
LIMIT 10000; |
5 years ago |
SELECT *
FROM page_props
LIMIT 100; |
5 years ago |
SELECT *
FROM page_props
WHERE pp_page = "Anarchism"; |
5 years ago |
SELECT page_id, page_title, page_props.pp_propname
FROM page
JOIN... |
5 years ago |
SELECT page_id, page_title, page_props.name
FROM page
JOIN page_props
... |
5 years ago |
SELECT *
FROM page_props LIMIT 10; |
5 years ago |
SELECT *
FROM page_props
WHERE pp_page = 50; |
5 years ago |
SELECT page_id, page_title, page_props.pp_propname
FROM page
JOIN... |
5 years ago |
SELECT page_id, page_title, categorylinks.*
FROM page
JOIN... |
5 years ago |
SELECT page_id, page_title, categorylinks.*
FROM page
JOIN... |
5 years ago |
SELECT cat_id, cat_title, cat_pages FROM category ORDER BY cat_pages DESC LIMIT 100; |
5 years ago |