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 'ORDER BY checker DESC,nome ASC' at line 7SELECT a.id,a.url,trim(a.nome) as nome,g.genero_sub,CASE WHEN (v.posicao IS NULL AND i.id_artista IS NULL) THEN "9999999" WHEN (v.posicao IS NULL AND i.id_artista IS NOT NULL) THEN "9999998" WHEN i.id_artista IS NOT NULL THEN (v.posicao-2000) ELSE v.posicao END as colocacao,IF( a.nome REGEXP '^[a-z0-9]', 1, 0 ) AS checker FROM artistas a INNER JOIN generos_sub g ON(g.id=a.genero_sub) LEFT JOIN views_artistas_semana_corrente v ON(v.id_artista=a.id /*AND (v.data=IF(DATE_FORMAT( NOW() , '%w' ) BETWEEN 1 AND 2 ,DATE_FORMAT( DATE_SUB(NOW( ),INTERVAL 7 DAY) , '%u%/%Y' ), DATE_FORMAT( NOW( ) , '%u%/%Y' )))*/) LEFT JOIN inicial i ON(i.id_artista=a.id) WHERE a.ativo=1 AND a.id_cidade= ORDER BY checker DESC,nome ASC