SELECT * FROM trips AS t 
  INNER JOIN calendar AS c 
    ON t.service_id=c.service_id 
  INNER JOIN calendar_dates AS cd 
    ON t.service_id=cd.service_id
  WHERE 
    AND cd.date=:date 
    AND cd.exceptType=1
    AND (c.start IS NULL OR c.start<=:date)
    AND (c.end IS NULL OR c.end>=:date)
    AND (c.days=0 OR (c.days & :day) != 0);