SELECT * FROM tbl_posts WHERE post_type = 'Barrel Race' AND displaylevel = 'Public' AND eventdate <= DATE_ADD(CURDATE(), INTERVAL 7 DAY) AND enddate >= CURDATE() AND (event_state = 'OK' or event_state = 'TX') ORDER BY eventdate, event_state, event_city ASC