Q=SELECT 
storie.ID as ID
,type.type as type

FROM 
vinnico_stories as storie INNER JOIN vinnico_stories_type as type INNER  JOIN vinnico_stories_type_catassoc as assoc_storie  ON (  assoc_storie.ID_storie=type.ID   AND (assoc_storie.ID_parent = storie.ID ))
WHERE storie.ID='8'
ORDER BY type.type DESC