problem with transfering website

i just made a website on a local webserver(xampp)
now i'm uploading it to my webspace @ my hosting and i get the following error:
Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

This is JUST a guess, but I think that the MySQL error is telling you that you can't do two things at once here. You're asking the command to get the COUNT(*) total of ALL records (hence the asterisk) and then wanting the values of 'land', which apparently HAs to be the value of "Argentinië", and saying that wijnen.kleur MUST equal 'Rood' even though you did not request it in the SELECT...

There's a lot wrong here. Because I only read English, the example makes it difficult to completely understand exactly what it is that you are trying to accomplish.