Untitled query #3756

SQL

SELECT
   GROUP_CONCAT(lv SEPARATOR ',') 
FROM
  (
    SELECT
        @pv:= (
            SELECT
                GROUP_CONCAT(child_id SEPARATOR ',')
            FROM
                (
					SELECT 
						cl_from as child_id, p2.page_id as parent_id, cl_type
					FROM
						categorylinks cl JOIN page p1 JOIN page p2
					ON
						cl.cl_from = p1.page_id AND cl.cl_to = p2.page_title
				) AS Folder
            WHERE
                parent_id IN (@pv)
            )
    AS 
        lv
    FROM
               (
					SELECT 
						cl_from as child_id, p2.page_id as parent_id, cl_type
					FROM
						categorylinks cl JOIN page p1 JOIN page p2
					ON
						cl.cl_from = p1.page_id AND cl.cl_to = p2.page_title
				) AS Folder2
    JOIN
        (SELECT @pv:=30529496) tmp #Johann_Sebastian_Bach
    WHERE
        parent_id IN (@pv)
        
  ) a;
SQL

Checking query status...
