SELECT
    anon_1.account_groups_book AS anon_1_account_groups_book,
    anon_1.account_groups_id AS anon_1_account_groups_id,
    anon_1.account_groups_name AS anon_1_account_groups_name,
    anon_1.account_groups_fullname AS anon_1_account_groups_fullname,
    account_permissions_1.USER AS account_permissions_1_user,
    account_permissions_1.book AS account_permissions_1_book,
    account_permissions_1.id AS account_permissions_1_id,
    account_permissions_1.name AS account_permissions_1_name
FROM
    (SELECT
        account_groups.book AS account_groups_book,
        account_groups.id AS account_groups_id,
        account_groups.name AS account_groups_name,
        account_groups.fullname AS account_groups_fullname
    FROM account_groups
    WHERE account_groups.name = ? LIMIT 2 OFFSET 0) AS anon_1
    LEFT OUTER JOIN
        account_group_permissions AS account_group_permissions_1
    ON anon_1.account_groups_id = account_group_permissions_1."group"
    LEFT OUTER JOIN
        account_permissions AS account_permissions_1
    ON account_permissions_1.id = account_group_permissions_1.permission