SELECT o.object_name,o.object_perms,p.perm_grant,p.perm_deny FROM k4_objects o, k4_perms p, k4_roles r, k4_user_roles u WHERE u.user_id=1  AND u.role_id=r.role_id  AND p.role_id=r.role_id  AND o.object_id=p.object_id ORDER BY r.perm_level ASC

SELECT c.*, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags FROM k4_category_tags ct, k4_tags ts, k4_categories c WHERE c.category_id=ct.category_id AND ts.tag_id=ct.tag_id GROUP BY c.category_id ORDER BY name ASC