Miscellany

SELECT MAX(set0.folder_id) FROM folder AS set0,folder AS set1 
WHERE set0.user_id=1 
AND set0.lft 
BETWEEN set1.lft AND set1.rgt 
AND set0.name_link = 'test123' 
AND set1.name_link = 'test123' 
AND set1.parent_id=0