Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM item_template WHERE statscount < 0
- UNION
- SELECT * FROM item_template WHERE stat_value1 <> 0 AND (statscount < 1)
- UNION
- SELECT * FROM item_template WHERE stat_value2 <> 0 AND (statscount < 2 OR stat_value1 = 0)
- UNION
- SELECT * FROM item_template WHERE stat_value3 <> 0 AND (statscount < 3 OR stat_value1 = 0 OR stat_value2 = 0)
- UNION
- SELECT * FROM item_template WHERE stat_value4 <> 0 AND (statscount < 4 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0)
- UNION
- SELECT * FROM item_template WHERE stat_value5 <> 0 AND (statscount < 5 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0)
- UNION
- SELECT * FROM item_template WHERE stat_value6 <> 0 AND (statscount < 6 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0 OR stat_value5 = 0)
- UNION
- SELECT * FROM item_template WHERE stat_value7 <> 0 AND (statscount < 7 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0 OR stat_value5 = 0 OR stat_value6 = 0)
- UNION
- SELECT * FROM item_template WHERE stat_value8 <> 0 AND (statscount < 8 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0 OR stat_value5 = 0 OR stat_value6 = 0 OR stat_value7 = 0)
- UNION
- SELECT * FROM item_template WHERE stat_value9 <> 0 AND (statscount < 9 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0 OR stat_value5 = 0 OR stat_value6 = 0 OR stat_value7 = 0 OR stat_value8 = 0)
- UNION
- SELECT * FROM item_template WHERE stat_value10 <> 0 AND (statscount < 10 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0 OR stat_value5 = 0 OR stat_value6 = 0 OR stat_value7 = 0 OR stat_value8 = 0 OR stat_value9 = 0)
- UNION
- SELECT * FROM item_template WHERE statscount > 10
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement