UPDATE [dnt_stats] SET [count]=[count]+1 WHERE ([type]='total' AND [variable]='hits') OR ([type]='month' AND [variable]='201007') OR ([type]='week' AND [variable]='6') OR ([type]='hour' AND [variable]='02')
TIME: 0
SELECT CASE WHEN DATEDIFF(n, [lastpost], GETDATE())<600 THEN 'new' ELSE 'old' END AS [havenew],[dnt_forums].*, [dnt_forumfields].* FROM [dnt_forums] LEFT JOIN [dnt_forumfields] ON [dnt_forums].[fid]=[dnt_forumfields].[fid] WHERE [parentid] = @fid AND [status] > 0 ORDER BY [displayorder]
