SQL Quick fix +Rep to who fixes

[Namor]

[SQL] Delete FROM item_template
WHERE Quality=2 and
WHERE Flags IN (2048,4, and
WHERE InventoryType IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,20,21,22)

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Flags IN (2048,4, and
WHERE InventoryType IN (1,2,3,4,5,6,7,8,9,10,11,1' at line 3
<......<
Fix pl0x?

[Namor]

4chan helped more than you guys did.
Fix was...
Can't have multiple WHERE clauses.

[stoneharry]

You expect everyone to be online and help in less than 4 hours? Unfortunately some of us have more important things to do than help you instantly.

[Namor]

4 hours, that's 1/6th of the day, and the majority of you are European. <.<

[stoneharry]

4 hours, that's 1/6th of the day, and the majority of you are European. <.<

When the world cup (England vs Germany) is currently on and the summer holidays for a lot of us have just started. Yes, were really going to be online at the moment and free.

[Namor]

You aren't free on holidays? :O
And the game is at 8:30pm, here. o.o

[stoneharry]

You aren't free on holidays? :O
And the game is at 8:30pm, here. o.o

Score when I'm posing this is 4-1 to Germany (should be 4-2 but ref had a "uhh what's a goal" moment). Basically England are getting hammered. On live atm. And when the holidays have just started, you generally are out celebrating and having a good time that school is over rather than sitting inside on a boiling hot day.

[Namor]

Man, I should have put money on this game. <..<
Well. Stoneharry, you have MSN? I must talk to you. ;D

[stoneharry]

Man, I should have put money on this game. <..<
Well. Stoneharry, you have MSN? I must talk to you. ;D

[email protected]

[vanoon]

Delete FROM item_template
WHERE Quality=2 and
WHERE Flags IN (2048,4, and
WHERE InventoryType IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,20,21,22)
should be:
Delete FROM item_template
WHERE Quality=2 and
Flags IN (2048,4, and
InventoryType IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,20,21,22) don't know if this works 100% but it should.
Or just split the queue