I have a question regarding the JSP mapper condition.

I'm developing a shopping mall web.

I'd like to add a page-nation function to the page that displays the latest products.

Then condition in the mapper is

I think we need to add 2 more.

<select id="navNewList" resultType="ShoesVO" parameterType="hashmap">
     SELECT *
     FROM goods_2
     WHERE release_date>=SYSDATE
     WHERE num BETWEEN #{start} AND #{end}
   </select>

Is it right to give two WHERE conditional sentences?

Actually, it didn't work when I did it.

If you can edit it, please answer<