SELECT t.classname,name,skill_id FROM skill_trees LEFT JOIN char_templates t ON (class_id = t.classid) WHERE name='soul cry' GROUP BY t.classname;
+-----------+----------+----------+
| classname | name | skill_id |
+-----------+----------+----------+
| Orc Mage | Soul Cry | 1001 |
| Shaman | Soul Cry | 1001 |
| Warcryer | Soul Cry | 1001 |
| Overlord | Soul Cry | 1001 |
+-----------+----------+----------+