SQL Date between and another condition statement not working

Here is two SQL Query when executing this SQL its work fine.

SELECT * 
  FROM xyz 
 WHERE file_play_start_开发者_如何学Pythondate BETWEEN '2011-07-01 06:15:00' 
                                AND '2011-07-08 06:30:00'

...but when adding another condition then its not working. e.i:returning no result tho there is result to show in this condition.

SELECT * 
  FROM xyz 
 WHERE calender_id = 3 
   AND file_play_start_date BETWEEN '2011-07-01 06:15:00' 
                                AND '2011-07-08 06:30:00'

Can any one tell me why its happening?

---

Because there are no records with calendar_id of 3 and the file_play_start_date between those two values.

---

select count(*) from reqcat.tpa_log where pa_status_cd='BAD' and row_update_time BETWEEN '2018-01-01' AND '2018-02-28';

Its not working . But when I do the

count * with pa_status_cd='BAD' and row_update_time BETWEEN '2018-01-01' AND '2018-02-28'

seperately it works.

---

There are no rows in xyz where calender_id = 3 and file_play_start_date between '2011-07-01 06:15:00' and '2011-07-08 06:30:00'.