[Share] Print skills query

[srekcidxam]

Hello! :D :D This is my first share!!!  :-*

 

I would like to share with you a very simple and clean query which can be very usefull for online scripts.

 

SELECT character_skills.charId, character_skills.skill_id, character_skills.skill_level,character_skills.class_index, characters.charid, characters.classid
FROM characters
LEFT JOIN character_skills ON characters.charid = character_skills.charId
LEFT JOIN characters_
WHERE characters.char_name = '$name' and character_skills.class_index in (select character_subclasses.class_index, character_subclasses.class_id, characters.classid from character_subclasses left join characters on character_subclasses.class_id = characters.classid)

 

Credits: ME  :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D