Server crashes when optimizing SQL with ORDER BY

CREATE DATABASE d;

USE d;

CREATE TABLE `vohgajoo` (

  `ohtighit` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `heipeeri` datetime DEFAULT NULL,

  `yingaexe` datetime DEFAULT NULL,

  `itahweit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

  `ooghohva` varchar(12) DEFAULT NULL,

  `iedacoox` tinytext DEFAULT NULL,

  `meingeic` enum('m','f','t') DEFAULT NULL,

  `quauxeej` date DEFAULT NULL,

  `ahmaepao` varchar(16) DEFAULT NULL,

  `chiavahn` float DEFAULT NULL,

  `eebiavit` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`eebiavit`)),

  `theibaej` bit(1) NOT NULL DEFAULT b'0',

  PRIMARY KEY (`ohtighit`),

  KEY `itahweit` (`itahweit`(12)),

  KEY `ooghohva` (`ooghohva`)

) ENGINE=InnoDB AUTO_INCREMENT=381603 DEFAULT CHARSET=utf8mb4;

CREATE TABLE `imaewaey` (

  `angooyie` int(11) NOT NULL,

  `binaeshe` int(11) NOT NULL,

  `itizahra` varchar(5) NOT NULL DEFAULT 'en',

  `aithixis` int(11) NOT NULL,

  `yingaexe` datetime NOT NULL,

  PRIMARY KEY (`angooyie`,`binaeshe`,`itizahra`),

  KEY `hieghieg` (`angooyie`,`binaeshe`,`aithixis`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

(SELECT bx.itahweit, v.aithixis/2 aithixis, 2 angooyie, JSON_UNQUOTE(JSON_EXTRACT(eebiavit, '$.claumexf')) claumexf FROM d.vohgajoo bx LEFT JOIN d.imaewaey v ON v.itizahra='en' AND v.angooyie=2 AND v.binaeshe=bx.ohtighit WHERE bx.ohtighit IN (4985) AND bx.theibaej=1 ORDER BY bx.meingeic IN ('f','t') DESC, JSON_EXTRACT(bx.eebiavit, '$.balmrusb') DESC LIMIT 1) ORDER BY angooyie=16, aithixis DESC;