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
