select o.*,i.* from news as o, news_index as i where o.UID = '19' and o.UID = i.UID and i.MODE_HIDE = 'N' and o.DATE_FROM <= '20130520' and DATE_TO >= '20130520' « Dediprog Consumer