[download]

local/bin/news

   1 #!/bin/bash
   2 
   3 s=$(sqlite3 ~/.newsboat/cache.db '
   4     select rss_item.title || " (" || rss_feed.title || ")"
   5     from rss_item join rss_feed on rssurl = feedurl
   6     where unread = 1 order by pubDate desc
   7 ')
   8 
   9 [[ $s ]] && echo "$s"