paid subscriptions ACP error

[greigeh]

When i press 'view users' from a Paid Subscription in the ACP i get the following database error

Database error in vBulletin 3.8.8. Patch Level 1:

Invalid SQL:

		SELECT COUNT(*) AS users
		FROM live_subscriptionlog AS subscriptionlog
		LEFT JOIN live_user AS user USING (userid)
		WHERE 1=1 AND subscriptionid=85 AND status = 1
			AND user.userid = subscriptionlog.userid;

MySQL Error   : Column 'status' in where clause is ambiguous
Error Number  : 1052
Request Date  : Saturday, January 24th 2015 @ 12:08:15 AM
Error Date    : Saturday, January 24th 2015 @ 12:08:15 AM
Script        : http://----.com/acp/subscriptions.php?do=find&status=1&subscriptionid=85&s=
Referrer      : http://-------.com/acp/subscriptions.php?do=modify
IP Address    : -----
Username      : Greig
Classname     : vB_Database
MySQL Version : 5.5.40-cll

Any ideas on what is wrong? (removed some information as private)

Any help appreciated.