Yevgeniy Kisselyov

Ошибка вываливается из за ASC он должен быть после order by который и должен сортировать а не группировать записи.
конечный запрос должен быть таким:

SELECT 
  city, count(*)
FROM 
  ip
GROUP BY
  city 
ORDER BY
  city ASC;

Либо так

SELECT COUNT(*)
FROM joiners_tourdate, joiners_artist
JOIN joiners_country on joiners_tourdate.country_id = joiners_country.id
WHERE joiners_tourdate.artist_id = joiners_artist.id
AND joiners_tourdate.country_id = 3

Либо переделать на join

SELECT COUNT(*)
FROM joiners_tourdate 
JOIN joiners_country on joiners_tourdate.country_id = joiners_country.id
JOIN joiners_artist ON joiners_tourdate.artist_id = joiners_artist.id
WHERE joiners_tourdate.country_id = 3

SELECT t2.user, IFNULL(t1.activity, 0) 
FROM table2 AS t2 
LEFT JOIN table1 AS t1 ON t1.user=t2.user  ORDER BY t2.user