SELECT TOP 1 * FROM [dnt_online] WHERE [userid]=@userid AND [ip]=@ip
@userid
@ip
Int32
AnsiString
-1
38.107.179.234
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]