select dbo.ve_getitemapplicability(iii.itemid) fromappl,dbo.ve_getitemapplicability(ii.itemid) toappl,
dbo.ve_GetShortPath(iii.itemid) frompath,dbo.ve_GetShortPath(ii.itemid) topath,
ccc.type fromtype,cc.type totype
from transitions tt
inner join contents ccc on tt.fromid = ccc.contentid
inner join items iii on ccc.contentid = iii.contentid
inner join items ii on tt.toid = ii.itemid
inner join contents cc on ii.contentid = cc.contentid
where dbo.ve_getitemapplicability(iii.itemid) != dbo.ve_getitemapplicability(ii.itemid)