SMS priser | SMSknuden.dk

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'henning__smsknuden_dk.prices.country' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

			##################################################
					SELECT	*
					FROM	prices
					GROUP BY provider
					ORDER BY
						provider <> 'nexmo',
						provider <> 'bulksms'
					##################################################

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' max(prices.updated) AS updated, sms_price, sms_voice_price ' at line 5

			##################################################
					SELECT	prices.country,
						regions.area,
						regions.country_name,
						,
						max(prices.updated) AS updated,
						sms_price,
						sms_voice_price
					FROM	prices
					LEFT JOIN regions USING(country)
					LEFT JOIN free_nexmo_numbers USING(country)
					
					GROUP BY
						prices.country
					ORDER BY
						CASE area
							WHEN 'Baltikum'		THEN 1
							WHEN 'Vest-europa'	THEN 2
										ELSE 9
						END,
						area,
						country
					##################################################

SMS priser | SMSknuden.dk

SMS-priser:

ISO Land Normalt Semi-annonym Incoming/month