SELECT distinct videos.video_id FROM videos INNER JOIN treatment_video_relation c on c.video_id = videos.video_id WHERE live = "Yes"and video_country ='United States' and c.subtreatment LIKE "Lung Cancer" AND trim(treatment_key) like "Cancer%Treatment" AND video_date > DATE_SUB(NOW(),INTERVAL 3 YEAR) ORDER BY video_date desc limit 4
