But how to tell lsql to do this query?
SELECT row FROM
(SELECT @row_number:=@row_number + 1 AS row, ID, Name
FROM bCategory as a, (SELECT @row_number:=0) AS b
WHERE FatherID = 33 and Number_of_Links > 0
ORDER BY sort, Pfad, Name) as c
WHERE ID = 3300;
SELECT row FROM
(SELECT @row_number:=@row_number + 1 AS row, ID, Name
FROM bCategory as a, (SELECT @row_number:=0) AS b
WHERE FatherID = 33 and Number_of_Links > 0
ORDER BY sort, Pfad, Name) as c
WHERE ID = 3300;