INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_1`, `wage_1` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_2`, `wage_2` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_3`, `wage_3` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_4`, `wage_4` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_5`, `wage_5` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_6`, `wage_6` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_7`, `wage_7` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_8`, `wage_8` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_9`, `wage_9` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_10`, `wage_10` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_11`, `wage_11` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_12`, `wage_12` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_13`, `wage_13` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_14`, `wage_14` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_15`, `wage_15` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_16`, `wage_16` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_17`, `wage_17` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_18`, `wage_18` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_19`, `wage_19` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_20`, `wage_20` FROM `factions`;