Complex custom query?

Good day, intending to make query for purging old revisions, but getting error on line #27, any ideas to fix?

DELETE pm FROM wp_postmeta pm WHERE pm.post_id IN (
    SELECT p.ID
    FROM wp_posts p
    WHERE p.post_type = 'revision'
        AND p.ID NOT IN (
            SELECT recent_revisions.ID
            FROM (
                    SELECT ID
                    FROM wp_posts
                    WHERE post_type = 'revision'
                    ORDER BY post_parent,
                        post_date DESC
                ) AS recent_revisions
            WHERE recent_revisions.ID IN (
                    SELECT ID
                    FROM (
                            SELECT ID
                            FROM wp_posts
                            WHERE post_type = 'revision'
                            GROUP BY post_parent
                            HAVING COUNT(ID) > 15
                        ) AS grouped_revisions
                )
        )
);

DELETE p FROM wp_posts p WHERE p.post_type = 'revision' AND p.ID NOT IN (
    SELECT recent_revisions.ID
    FROM (
            SELECT ID
            FROM wp_posts
            WHERE post_type = 'revision'
            ORDER BY post_parent,
                post_date DESC
        ) AS recent_revisions
    WHERE recent_revisions.ID IN (
            SELECT ID
            FROM (
                    SELECT ID
                    FROM wp_posts
                    WHERE post_type = 'revision'
                    GROUP BY post_parent
                    HAVING COUNT(ID) > 15
                ) AS grouped_revisions
        )
);