insert into #variables.tableprefix#ranks(id,name,minposts) values(, , ) delete from #variables.tableprefix#ranks where id = select top 1 name from #variables.tableprefix#ranks where minposts <= order by minposts desc limit 1 select id, name, minposts from #variables.tableprefix#ranks where id = select id, name, minposts from #variables.tableprefix#ranks update #variables.tableprefix#ranks set name = , minposts = where id =