vdEJBd2z

1SELECT * FROM program pr WHERE pr.programid = '1' AND currentDate BETWEEN pr.date_start AND pr.date_end ORDER BY pr.date_end;
2	
3CREATE INDEX IF NOT EXISTS pr_ind ON program (programid,date_start,date_end);
4	
5SEARCH TABLE program AS pr USING INDEX pr_ind (programid=? AND date_start<?)