MySql中的相关子查询 - 如何首先评估外部查询？

I am having problems with subqueries in MySql. I have a table containing user groups. The columns are id, name and the properties with a comment describing each row: (Id is INT, Name VARCHAR, all other TINYINT(1) (boolean that is)I am having problems with subqueries in MySql.