Songs by The Royal Guardsmen

10 Most Common The Royal Guardsmen 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_by

---

SQL:
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="3049"
    GROUP BY Song
    ORDER BY Qty DESC
    LIMIT 10

---