Skip to content

Instantly share code, notes, and snippets.

@iebb

iebb/NEW SKILL

Created July 6, 2016 09:23
Show Gist options
  • Save iebb/e42f4d0b96766406b10d22aec62af174 to your computer and use it in GitHub Desktop.
Save iebb/e42f4d0b96766406b10d22aec62af174 to your computer and use it in GitHub Desktop.
Download ZIP
NEW SKILL
Raw
NEW SKILL
SELECT unit_number, eponym, unit_m.name, unit_leader_skill_m.description,
member_tag_m.name as 'member',
unit_attribute_m.name as 'attribute',
unit_leader_skill_extra_m.effect_value as 'value'
FROM unit_m
LEFT JOIN unit_leader_skill_m ON unit_leader_skill_m.unit_leader_skill_id = unit_m.default_leader_skill_id
LEFT JOIN unit_leader_skill_extra_m ON unit_leader_skill_extra_m.unit_leader_skill_id = unit_m.default_leader_skill_id
LEFT JOIN member_tag_m ON unit_leader_skill_extra_m.member_tag_id = member_tag_m.member_tag_id
LEFT JOIN unit_attribute_m ON unit_leader_skill_extra_m.leader_skill_effect_type = unit_attribute_m.attribute_id
WHERE unit_m.rarity > 3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment