RTFACT
Life Is Good (Single)
AFL Music
$1.99 buy
Life Is Good is the first single from the progrock band Artifact, with a full, tentatively self-titled album scheduled for a March, 2017 release.
The band features renowned rock musicians such as Jeff Scott Soto, Jeff Kollman, and Joel Taylor among others.

released October 31, 2016

Jeff Scott Soto – vocals
Jeff Kollman – guitars
Gary Meek– sax, flute
Edward Tsiselsky– keyboards
Eugene Sharikov– bass
Joel Taylor– drums
SELECT DISTINCT SQL_CALC_FOUND_ROWS 
                 music.*, 
                 UNIX_TIMESTAMP(music.datetime) AS d, 
                 music_projects.name_en AS project_name,
                 music_categories.name_en AS category_name,
                 music_authors.name_en AS author_name,
                 music_types.name_en AS type_name,
                 music_labels.name_en AS label_name,
                 music_subscriptions.`delimiter`,
                 music_subscriptions.subscription_id
          FROM music
          LEFT JOIN music_projects ON (music_projects.id = music.project_id)
          LEFT JOIN music_categories ON (music_categories.id = music.category_id)
          LEFT JOIN music_genres ON (music_genres.id = music.genre_id) 
          LEFT JOIN music_authors ON (music_authors.id = music.author_id) 
          LEFT JOIN music_types ON (music_types.id = music.type_id) 
          LEFT JOIN music_labels ON (music_labels.id = music.label_id) 
           RIGHT  JOIN music_subscriptions ON ( music_subscriptions.music_id = music.id )
          LEFT JOIN subscriptions ON ( music_subscriptions.subscription_id = subscriptions.id )
          WHERE 1
            AND UNIX_TIMESTAMP(music.datetime) < 1511245800
            AND (
                music.vis = 1
             OR music.vis IS NULL
            )
            
             AND music_subscriptions.subscription_id = 59  AND music.type_id = 2 
           ORDER BY music_subscriptions.sort 
          LIMIT 0, 20

No results found