My query works fine but for the last part as below. I need to retrieve records where the start date <= today and end date is >= today.

I also need the records where the strat date is up to 9 months from today.

This part of the query ensures it returns nothing when there is data to be returned. I have had little success from searching and reading the docs.

Code MySQL:
WHERE ( pl.start_date <= CURDATE() or pl.start_date <= date_sub(curdate(), interval 270 day) )
    AND pl.end_date >= CURDATE()

Please give me a nudge.

bazz