Wonach suchst Du?
What are you looking for?


SELECT Examples

Shows you the names of nodes in Menu

select m.name,m2.name from ad_treenodemm mm
join ad_menu m on mm.node_id = m.ad_menu_id and mm.parent_id = 1000007
LEFT JOIN ad_treenodemm mm2 on mm2.parent_id = mm.node_id
join ad_menu m2 on mm2.node_id = m2.ad_menu_id
order by m.name,m2.name

View source file on GitHub.com