Increase Results in Similar Threads?

[imported_silkroad]

For example, here was some code that "errored" ....

SELECT thread.threadid, thread.forumid, thread.title, postusername, postuserid, thread.lastpost, thread.replycount, forum.title AS forumtitle
			,post.pagetext AS preview
			, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
			
		FROM thread AS thread
		INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
		LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
		 LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
		
		WHERE thread.threadid IN (42594, 46777, 48335, 24513, 27051, 7320, 41438, 51387, ) AND thread.visible = 1
			
			
			
		ORDER BY lastpost DESC;