[Eq4bits]

Installed this a couple of weeks or so ago, no probs with forum until then.
Started getting this error message anytime any member tries to access their subscription list from their usercp:

Database error in vBulletin 3.6.2:

Invalid SQL:

			SELECT
				IF(votenum >= 1, votenum, 0) AS votenum,
				IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
				post.pagetext AS preview, thread.threadid, IF(thread.threadprefix <> '', CONCAT('', thread.threadprefix, ' - ', thread.title), thread.title) AS title AS threadtitle, forumid, pollid, open, replycount, postusername,
				thread.lastpost, thread.lastposter, thread.lastpostid, postuserid, thread.dateline, views, thread.iconid AS threadiconid, notes, thread.visible, thread.attach
				, threadread.readtime AS threadread
				, thread.threadprefix
			FROM *****_thread AS thread
			LEFT JOIN *****_post AS post ON(post.postid = thread.firstpostid)
			 LEFT JOIN *****_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 5)
			
			
			WHERE thread.threadid IN (2937,2834,2913,3003,2977,3000,2828,2986,3005,2983,2955,2992,2954,2969,2935,3002,2909,2854,2994,2974)
				
			ORDER BY thread.lastpost DESC;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS threadtitle, forumid, pollid, open, replycount, postusername,
				thread.last' at line 4
Error Number : 1064
Date         : Tuesday, October 31st 2006 @ 07:48:27 AM
Script       : http://www.*********.net/forums/subscription.php?do=viewsubscription
Referrer     : http://www.*********.net/forums/usercp.php
IP Address   : *****************
Username     : *****************
Classname    : vb_database

So after asking elsewhere in the vb.org forums I've tracked it down to the thread prefix modification to subscription.php particularly a 'double AS phrase',
mine looks like:

$previewfield thread.threadid, IF(thread.threadprefix <> '', CONCAT('" . $vbulletin->options['prefixmarkup_start'] . "', thread.threadprefix, '" . $vbulletin->options['prefixmarkup_end'] . "', thread.title), thread.title) AS title AS threadtitle, forumid, pollid, open, replycount, postusername,
				$lastpost_info, postuserid, thread.dateline, views, thread.iconid AS threadiconid, notes, thread.visible, thread.attach
				" . ($vbulletin->options['threadmarking'] ? ", threadread.readtime AS threadread" : '') . "
				$hook_query_fields

and a 'clean' vb3.6.2 subscription.php looks like:

$previewfield thread.threadid, thread.title AS threadtitle, forumid, pollid, open, replycount, postusername,
				$lastpost_info, postuserid, thread.dateline, views, thread.iconid AS threadiconid, notes, thread.visible, thread.attach
				" . ($vbulletin->options['threadmarking'] ? ", threadread.readtime AS threadread" : '') . "
				$hook_query_fields

so what can I do to 'fix' this so members can actually view their subscription list but we can also have the thread prefix?