Looks like the live MySQL does not support nested DISTINCT statments as the develop one, im using v5 and live site has v4, whoop, there are some changes
Its back to work, but displaying wrong downloads count as it was be4, will fix shortly, need to make a separate query for that then...
Thanks for the report neoxed, i totally forgot to 'test' the changes