>
>I used Where clause only once.

No, you used it twice.

Take the code that you posted and paste it into notepad. Then do a search on the word WHERE. You'll see that you have it in the code twice.

That might not necessarily be the only thing wrong, but it's the one that I can see.