select * from tclassextend where subTypeID= or ( siteid= and type= and subType= ) order by type,subType select subTypeID from tclassextend where subTypeID= update tclassextend set siteID = , type = , subType = , baseTable = , baseKeyField = , dataTable=, isActive = #getIsActive()# where subTypeID= Insert into tclassextend (subTypeID,siteID,type,subType,baseTable,baseKeyField,dataTable,isActive) values( , , , , , , , #getIsActive()#) delete from tclassextend where subTypeID= update #getBaseTable()# set subType='Default' where siteID= and subType= select ExtendSetID,subTypeID,name,orderno,isActive,siteID,categoryID,orderno,0 as setlevel from tclassextendsets where subTypeID= and ( categoryID like '%#listGetAt(arguments.filter,f)#%' or ) and categoryID is null Union All select tclassextendsets.ExtendSetID,tclassextendsets.subTypeID,tclassextendsets.name,tclassextendsets.orderno,tclassextendsets.isActive,tclassextendsets.siteID,tclassextendsets.categoryID,tclassextendsets.orderno,1 as setlevel from tclassextendsets Inner Join tclassextend On (tclassextendsets.subTypeID=tclassextend.subTypeID) where tclassextend.type= and tclassextend.subType= and ( tclassextendsets.categoryID like '%#listGetAt(arguments.filter,f)#%' or ) and tclassextendsets.categoryID is null select * from rs order by setlevel desc, orderno