Funny September Misheard Song and Music Lyrics

Songs by September

10 Most Common September Misheard Songs

SQL Error:Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lyrics_site.a.FirstName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_bySQL:SELECT
COUNT(mis.ID) AS Qty,
CONCAT(IF(a.FirstName="","",CONCAT(a.FirstName," ")),a.Name) AS Artist,
s.Name AS Song,
s.ID
FROM songs s
LEFT JOIN misheards mis ON s.ID=mis.SongID
LEFT JOIN artists a ON s.ArtistID=a.ID
WHERE mis.ArtistID="2207"
GROUP BY Song
ORDER BY Qty DESC
LIMIT 10