[Lexx_a]

SQL запрос обновлялки ноблессов при апдейте до феникса 17352:

INSERT IGNORE INTO olympiad_nobles
	SELECT obj_Id,-1,char_name,18,0,0,0,0,0 FROM characters WHERE obj_Id IN (
		SELECT char_id FROM character_quests WHERE name='_247_PossessorOfaPreciousSoul4' AND var='<state>' AND value='Completed'
	);

UPDATE olympiad_nobles o LEFT JOIN character_subclasses s ON o.char_id=s.char_obj_id AND s.isBase SET o.class_id=s.class_id;