acHxqXpL

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