ER_BAD_FIELD_ERROR on ghost using latest tag

[Lucifer1590]

error log

ghostblog     | [2022-11-03 15:26:39] ERROR "POST /ghost/api/admin/posts/?formats=mobiledoc%2Clexical" 400 210ms
ghostblog     | 
ghostblog     | Could not understand request.
ghostblog     | 
ghostblog     | Error ID:
ghostblog     |     e9c55980-5b8b-11ed-bfd4-bfb3f919763b
ghostblog     | 
ghostblog     | Error Code: 
ghostblog     |     ER_BAD_FIELD_ERROR
ghostblog     | 
ghostblog     | ----------------------------------------
ghostblog     | 
ghostblog     | Error: select `posts`.*, (with `k` as (select `member_id` from `members_subscription_created_events` where posts.id = members_subscription_created_events.attribution_id union select `member_id` from `members_created_events` where posts.id = members_created_events.attribution_id) select count(*) from `k`) as `count__conversions`, `posts`.*, (select count(distinct `members_click_events`.`member_id`) from `members_click_events` inner join `redirects` on `members_click_events`.`redirect_id` = `redirects`.`id` where posts.id = redirects.post_id) as `count__clicks`, `posts`.*, (select COALESCE(ROUND(AVG(score) * 100), 0) from `members_feedback` where posts.id = members_feedback.post_id) as `count__sentiment`, `posts`.*, (select count(*) from `members_feedback` where posts.id = members_feedback.post_id AND members_feedback.score = 0) as `count__negative_feedback`, `posts`.*, (select sum(`score`) from `members_feedback` where posts.id = members_feedback.post_id) as `count__positive_feedback` from `posts` where `posts`.`id` = '6363ddafb005a00001de843f' limit 1 - Unknown column 'posts.id' in 'where clause'

Installed on a VPS with ubuntu 22.04 and docker + docker-compose updated to the latest

and using MariaDB latest as DBMS

but after switching to SQL 8.0 the error disappears

[sanengineer]

yes, its happen it on mee too...

[TemaSM]

Confirming issue
Related:
TryGhost/Ghost#15729
TryGhost/Ghost#15766
TryGhost/Ghost#15806
TryGhost/Ghost#15813
TryGhost/Ghost#15815

Introduced by:
TryGhost/Ghost@22fe1c0#diff-3149f93d170c65cd0c97a204a2d19c6102351b3c542c357aa342874699521237R1363