insert into #variables.tableprefix#forums(id,name,description,active,conferenceidfk,attachments,messages) values(, , , , , , 0 ) delete from #variables.tableprefix#forums where id = delete from #variables.tableprefix#subscriptions where forumidfk = select id, name, description, active, conferenceidfk, attachments, messages, lastpost, lastpostuseridfk, lastpostcreated from #variables.tableprefix#forums where id = select f.id, f.name, f.description, f.active, f.attachments, f.conferenceidfk, f.lastpostcreated, f.messages, f.lastpost, f.lastpostuseridfk, c.name as conference from #variables.tableprefix#forums f, #variables.tableprefix#conferences c where f.conferenceidfk = c.id and f.active <> 0 and f.conferenceidfk = order by f.name update #variables.tableprefix#forums set name = , description = , active = , attachments = , conferenceidfk = where id = select id, name, description, conferenceidfk from #variables.tableprefix#forums where active = 1 and ( (name like or description like '%#aTerms[x]#%') #joiner# name like or description like '%#arguments.searchTerms#%' ) update #variables.tableprefix#forums set lastpost = , lastpostuseridfk = , lastpostcreated = , messages = messages + 1 where id = update #variables.tableprefix#forums set lastpost = , lastpostuseridfk = , lastpostcreated = , messages = where id = update #variables.tableprefix#forums set lastpost = , lastpostuseridfk = , lastpostcreated = , messages = where id =