500
Ismeretlen hiba történt...
Got error 28 from storage engine
SELECT T2.*
FROM (
SELECT
@r AS _id,
@p := @r AS previous,
(SELECT @r := `parent_id` FROM `categories` WHERE id = _id AND (`active`=1)) AS `parent_id`,
@l := @l + 1 AS lvl
FROM
(SELECT @r := 40, @p := 0, @l := 0) vars,
`categories` h
WHERE @r <> 0 AND @r <> @p AND (`active`=1))
T1
JOIN `categories` T2
ON T1._id = T2.id
WHERE T2.id != 40
ORDER BY T1.lvl DESC