2 sql=select TabID,ParentId,TabName,Title,TabOrder from Tabs where TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by TabOrder, ParentId 2 sql=select TabID,ParentId,TabName,Title,TabOrder from Tabs where TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by TabOrder, ParentId 2 sql=select TabID,'-1' as ParentId,TabName,Title,LastUpdate from Tabs where TabID='5' union select TabID,'5' as ParentId,TabName,Title,LastUpdate from Tabs where TabID<>'5' and tabtype='Proj' and TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by LastUpdate DESC 2 sql=select TabID,ParentId,TabName,Title,TabOrder from Tabs where TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by TabOrder, ParentId 2 sql=select TabID,ParentId,TabName,Title,TabOrder from Tabs where TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by ParentId,TabOrder 2 sql=select TabID,ParentId,TabName,Title,TabOrder from Tabs where TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by ParentId,TabOrder 2 sql=select TabID,ParentId,TabName,Title,TabOrder from Tabs where TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by ParentId,TabOrder 2 sql=select TabID,ParentId,TabName,Title,TabOrder from Tabs where TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by ParentId,TabOrder 2 sql=select TabID,ParentId,TabName,Title,TabOrder from Tabs where TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by ParentId,TabOrder PM_TreeList=0 tabFilter= and tabtype='Proj' tabrootname=Projects 2 sql=select TabID,ParentId,TabName,Title,TabOrder from Tabs where TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by ParentId,TabOrder PM_TreeList=0 tabFilter= and tabtype='Proj' tabrootname=Projects 2 sql=select TabID,ParentId,TabName,Title,TabOrder from Tabs where TabID in (0005,121,527,529,531,532,533,534,535,536,545,1551,1596,1639,1640,1642,2110,2479,2978,3202) order by ParentId,TabOrder