[CELKO TREE]

[lucasvanlierop]

SELECT
N1.node_id
,N1.node_properties_id
,N1.node_name
,N1.node_title
,N1.node_type
,COUNT(N2.node_id) AS node_level

FROM nodes AS N1
JOIN properties AS P
ON N1.node_properties_id = P.properties_id
JOIN nodes AS N2
ON N1.node_lft BETWEEN N2.node_lft AND N2.node_rgt
JOIN nodes AS N3
ON N3.node_id = '64'
WHERE
N1.node_lft BETWEEN (N3.node_lft + 1) AND (N3.node_rgt - 1)
GROUP BY N1.node_id ORDER BY N1.node_lft

[gorgi_19]

Erhm.. En wat is je vraag / probleem?

[whoami]

Ok
Het spel is uit.

Damn, 't knopje is weg.

[ Voor 43% gewijzigd door whoami op 28-04-2004 16:08 ]

[curry684]

Gaaf.