Advertisement
Kalashnikov

Untitled

Jun 25th, 2011
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. SELECT p.id, @e := te1.damage_factor /100 * te2.damage_factor /100 AS e
  2. FROM pokemon AS p
  3. INNER JOIN pokemon_types AS t1 ON p.id = t1.pokemon_id
  4. INNER JOIN type_efficacy AS te1 ON t1.type_id = te1.target_type_id
  5. INNER JOIN pokemon_types AS t2 ON p.id = t2.pokemon_id
  6. INNER JOIN type_efficacy AS te2 ON t2.type_id = te2.target_type_id
  7.  
  8. WHERE te1.damage_type_id =10
  9. AND t1.slot =1
  10. AND te2.damage_type_id =10
  11. AND t2.slot =2
  12. AND te1.damage_factor /100 * te2.damage_factor /100 >=2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement