WITH RECURSIVE traverse (cat_page_id, cat_title, depth) AS (
SELECT... |
3 years ago |
WITH RECURSIVE traverse (cat_page_id, cat_title, depth) AS (
SELECT... |
3 years ago |
WITH RECURSIVE traverse (cat_page_id, cat_title, depth) AS (
SELECT... |
3 years ago |
WITH RECURSIVE traverse (cat_page_id, cat_title) AS (
SELECT p0.page_id,... |
3 years ago |
WITH RECURSIVE traverse (cat_page_id, cat_title) AS (
SELECT p0.page_id,... |
3 years ago |
WITH RECURSIVE traverse (cat_title, cat_page_id) AS (
SELECT p.page_id,... |
3 years ago |
WITH RECURSIVE cte (n) AS
(
SELECT 1
UNION ALL
SELECT n + 1 FROM cte... |
3 years ago |