select * from tusersfavorites where userID= and type = and siteID = order by rowNumber and siteID = order by dateCreated SELECT tusersfavorites.favoriteID, tusersfavorites.dateCreated, tcontent.title, tcontent.releasedate, tcontent.menuTitle, tcontent.lastupdate, tcontent.summary, tcontent.filename, tcontent.type, tcontent.contentid, tcontent.target,tcontent.targetParams, tcontent.restricted, tcontent.restrictgroups, tcontent.displaystart, tcontent.displaystop, tcontent.orderno,tcontent.sortBy,tcontent.sortDirection, tcontent.fileid, tcontent.credits, tcontent.remoteSource, tcontent.remoteSourceURL, tcontent.remoteURL, tfiles.fileSize,tfiles.fileExt FROM tcontent Inner Join tusersfavorites ON (tcontent.contentID=tusersfavorites.favorite AND tcontent.siteID=tusersfavorites.siteID) Left Join tfiles ON (tcontent.fileID=tfiles.fileID) Left Join tcontent tparent on (tcontent.parentid=tparent.contentid and tcontent.siteid=tparent.siteid and tparent.active=1) WHERE tcontent.siteid= and tusersfavorites.userid= and tcontent.active=1 AND ( tcontent.Display = 1 OR ( tcontent.Display = 2 and ( (tcontent.DisplayStart <= #createodbcdatetime(now())# AND (tcontent.DisplayStop >= #createodbcdatetime(now())# or tcontent.DisplayStop is null)) OR tparent.type='Calendar' ) ) ) ORDER BY tusersfavorites.dateCreated DESC select favorite from tusersfavorites where favorite= and userID= delete from tusersfavorites where type = 'RSS' and userID = and siteID =