((headline like '%spectacular%' ) or ( headline like '%exceptional%' ) or ( headline like '%excellent%' ) or
( headline like '%drill%' ))
CreateDate > DATEADD(month,-6,GetDate())
and basefundamentalList.marketcap < 600000
and (SubSector like '%gold%' )
order by (a.Createdate )desc
