5 lines
305 B
SQL
5 lines
305 B
SQL
Select vn.versionid, vn.foldername, ItemID, Replace(Number,'\u8209?','-') ProcNum, Replace(Text,'\u8209?','-') ProcTitle from contents cc
|
|
JOIN VEFN_GetVersionItems('') VI ON VI.ContentID = CC.ContentID
|
|
JOIN VEFN_GetVersionNames() VN ON VI.VersionID = VN.VersionID
|
|
Where Type = 0
|
|
order by VersionID, ItemID |