err = s.db.Order("created_at desc").Raw(`SELECT groups.*, pl.name, pl.address, pl.lat, pl.lng,
                    (CASE
                        WHEN group_members.device_id IS NOT NULL THEN TRUE
                        ELSE FALSE
                    END) as is_shared
                    FROM ((groups JOIN group_members ON groups.id = group_members.group_id)
                    LEFT JOIN (
                        SELECT DISTINCT ON (planning_locations.group_id) planning_locations.*
                        FROM planning_locations) as pl
                        ON pl.group_id = groups.id
                    )
                    WHERE group_members.user_id = ? `+limit+offset+`;`, userID).
        Scan(&groupsList).Error