MYSQL Query Date Between

What is wrong with this query

select  a.TEST开发者_如何学PythonDATE  from testr a,XREFRTGTE b where a.id = b.id and a.TESTDATE between BETWEEN STR_TO_DATE('2011-05-26 12:22:33','YYYY-MM-DD HH:MM:SS') AND STR_TO_DATE('2011-06-02 12:22:33','YYYY-MM-DD HH:MM:SS') limit 200

Please help

I can see two between used in the query:

... between BETWEEN ...

Try dropping one.