8 lines
318 B
SQL
8 lines
318 B
SQL
select .dbo.ve_getshortpath(itemid), text from transitions tt
|
|
join contents cc on cc.contentid = tt.fromid
|
|
join items ii on cc.contentid = ii.contentid
|
|
where trantype = 1
|
|
--where toid <> rangeid and trantype = 2 --not in (2,0)
|
|
--select distinct trantype from transitions
|
|
--select * from contents where contentid = 778
|