SELECT Max(YEAR(dtRecorded)) as year, Count(PK_Music_Video) as cnt, max(Thumbnail_medium) as thumb FROM Music_Video V LEFT JOIN Music_Artist A ON V.FK_Music_Artist = A.PK_Music_Artist WHERE PK_Music_Artist = 575 AND btLive=1 GROUP BY YEAR(dtRecorded) ORDER BY ( dtRecorded IS NULL ), dtRecorded ASC “Rockin’ Stroll” by: The LEMONHEADS Live in Dublin (September 22, 2022) | GarageVids.com | The Internet's Archive of Live Music Performance Videos