ERROR: Unable to execute query
select count(VID) as total 
				from video,favorites
				where video.VID = favorites.posting_id and type= 'video' and favorites.mid ='458' AND status=1
Column 'status' in where clause is ambiguous