The attached script is used to show the current Subscriptions Amounts for the month in vBulletin. However, it uses Sub-Queries which is only supported by MySQL v4.1+. My Webshost is running v4.0.16 of MySQL and doesn't plan on upgrading any time soon. According to this link, there is a workaround for this problem:
[login to view URL]
Unfortunately, that is over my head so now I am stuck.