Rainbow Event Medals: An Overview
SELECT
monsters.monster_id,
monsters.monster_no_jp,
monsters.monster_no_na,
monsters.rarity,
monsters.name_ja,
monsters.name_en,
monster_name_overrides.name_en AS name_en_override
FROM monsters LEFT JOIN monster_name_overrides ON monsters.monster_id=monster_name_overrides.monster_id WHERE name_en_override=? ORDER BY monsters.monster_id DESC