insert into #variables.tableprefix#threads(id,name,readonly,active,forumidfk,useridfk,datecreated,sticky) values(, , , , , , , ) delete from #variables.tableprefix#threads where id = delete from #variables.tableprefix#subscriptions where threadidfk = select id, name, readonly, active, forumidfk, useridfk, datecreated, sticky from #variables.tableprefix#threads where id = select #variables.tableprefix#threads.id, #variables.tableprefix#threads.name, #variables.tableprefix#threads.readonly, #variables.tableprefix#threads.active, #variables.tableprefix#threads.forumidfk, #variables.tableprefix#threads.useridfk, #variables.tableprefix#threads.datecreated, #variables.tableprefix#forums.name as forum, #variables.tableprefix#users.username, max(#variables.tableprefix#messages.posted) as lastpost, count(#variables.tableprefix#messages.id) as messagecount, #variables.tableprefix#threads.sticky, #variables.tableprefix#conferences.name as conference from (((#variables.tableprefix#threads left join #variables.tableprefix#messages on #variables.tableprefix#threads.id = #variables.tableprefix#messages.threadidfk) inner join #variables.tableprefix#forums on #variables.tableprefix#threads.forumidfk = #variables.tableprefix#forums.id) inner join #variables.tableprefix#conferences on #variables.tableprefix#forums.conferenceidfk = #variables.tableprefix#conferences.id) inner join #variables.tableprefix#users on #variables.tableprefix#threads.useridfk = #variables.tableprefix#users.id where 1=1 and #variables.tableprefix#threads.active = 1 and #variables.tableprefix#threads.forumidfk = group by #variables.tableprefix#threads.id, #variables.tableprefix#threads.name, #variables.tableprefix#threads.readonly, #variables.tableprefix#threads.active, #variables.tableprefix#threads.forumidfk, #variables.tableprefix#threads.useridfk, #variables.tableprefix#threads.datecreated, #variables.tableprefix#forums.name, #variables.tableprefix#users.username, #variables.tableprefix#threads.sticky, #variables.tableprefix#conferences.name order by #variables.tableprefix#threads.sticky descasc, max(#variables.tableprefix#messages.posted) desc lastpost desc select useridfk from #variables.tableprefix#messages where threadidfk = and posted = update #variables.tableprefix#threads set name = , readonly = , active = , forumidfk = , useridfk = , datecreated = , sticky = where id = select id, name from #variables.tableprefix#threads where active = 1 and ( (name like ) #joiner# name like )