| select distinct cat_title from category limit 100 OFFSET 3000; |
3 weeks ago |
| select distinct cat_title from category limit 100 OFFSET 1000; |
3 weeks ago |
| select distinct cat_title from category limit 100; |
3 weeks ago |
| desc category; |
3 weeks ago |
| SELECT
p_to.page_title AS target_title,
COUNT(DISTINCT... |
3 weeks ago |
| SELECT
p_to.page_title AS target_title,
COUNT(DISTINCT... |
3 weeks ago |
| SELECT
p_to.page_title AS target_title,
COUNT(DISTINCT... |
3 weeks ago |
| SELECT
p_to.page_title AS target_title,
COUNT(DISTINCT... |
3 weeks ago |
| SELECT
p_to.page_title AS target_title,
COUNT(DISTINCT... |
3 weeks ago |
| SELECT
p_to.page_title AS target_title,
... |
3 weeks ago |
| SELECT p.*
FROM page p
WHERE p.page_is_redirect = 1
AND EXISTS (
SELECT... |
3 weeks ago |
| SELECT p.* -- All fields from parent categories
FROM categorylinks cl
JOIN... |
3 weeks ago |
| SELECT p.* -- All fields from parent categories
FROM categorylinks cl
JOIN... |
3 weeks ago |
| SELECT p.* -- This will return all columns from the page table
FROM... |
3 weeks ago |
| SELECT p.* -- This will return all columns from the page table
FROM... |
3 weeks ago |
| SELECT p.* -- This will return all columns from the page table
FROM... |
3 weeks ago |
| SELECT p.* AS parent_category
FROM categorylinks cl
JOIN page p1 ON... |
3 weeks ago |
| WITH RECURSIVE category_tree AS (
-- Base case: direct parent categories
... |
3 weeks ago |
| SELECT DISTINCT p.page_title AS parent_category
FROM categorylinks cl
JOIN... |
3 weeks ago |
| SELECT DISTINCT p.page_title AS parent_category
FROM categorylinks cl
JOIN... |
3 weeks ago |
| SELECT p.page_title AS parent_category
FROM categorylinks cl
JOIN page p1 ON... |
3 weeks ago |
| SELECT p.page_title AS subcategory
FROM categorylinks cl
JOIN page p ON... |
3 weeks ago |
| SELECT p.page_title AS parent_category
FROM categorylinks cl
JOIN page p1 ON... |
3 weeks ago |
| SELECT p.page_title AS subcategory
FROM categorylinks cl
JOIN page p ON... |
3 weeks ago |
| SELECT p.page_title AS subcategory
FROM categorylinks cl
JOIN page p ON... |
3 weeks ago |
| SELECT * FROM categorylinks WHERE cl_type = 'subcat' limit 10; |
3 weeks ago |
| desc categorylinks; |
3 weeks ago |
| decribe categorylinks; |
3 weeks ago |
| select * from category where cat_id = 12; |
3 weeks ago |
| select * from category where id = 12; |
3 weeks ago |
| select * from categorylinks limit 10; |
3 weeks ago |
| select * from category_links limit 10; |
3 weeks ago |
| select * from category limit 10; |
3 weeks ago |
| select 8 from category limit 10; |
3 weeks ago |
| show tables; |
3 weeks ago |
| select * from page where page_title like 'Шаблон:Инфокутија%'; |
1 month ago |
| select * from page where title like 'Шаблон:Инфокутија%'; |
1 month ago |
| show tables; |
1 month ago |
| describe tables; |
1 month ago |
