I want to delete a lot posts in bulk from a category which have more than 1000 posts. I prefer to do them in SQL. Where I put a single command and I see the posts vanished ;)

How is it possible to achieve this?

Somebody told me to do this to check the posts I want to delete, but it didn't work! (I want to delete between posts ID 100 to 200).

> 
> SELECT \* FROM ((wp\_posts p LEFT JOIN wp\_term\_relationships tr ON p.ID
>  = tr.object\_id) LEFT JOIN wp\_term\_taxonomy tt ON tr.term\_taxonomy\_id = tt.term\_taxonomy\_id) LEFT JOIN wp\_terms t ON tt.term\_id = t.term\_id WHERE t.name='xxx' and p.ID>=100 and p.ID<=200
> 
> 
> 

Thanks!