Attacker Level
Defender Tier
Weather
Failed to prepare statement:
SELECT
CONCAT(
'
',
attacking_type, ' '
) Type,
CONCAT(
LPAD(ROUND(ROUND(
EXP(SUM(LOG(COALESCE(factor,
1)))),
4
) * 100, 2), 6, '000'),
'%'
) Effectiveness
FROM
`type_effectiveness`
WHERE
defending_type IN(
SELECT TYPE
FROM
type_assignment
WHERE
species_id = 423
AND form_id = (SELECT combat_form_id FROM effective_species WHERE id = 423 AND form_id = 12)
)
GROUP BY TYPE
ORDER BY
LPAD(ROUND( EXP(SUM(LOG(COALESCE(factor, 1)))), 4 ),4, '0') DESC,
attacking_type
',
attacking_type, ' '
) Type,
CONCAT(
LPAD(ROUND(ROUND(
EXP(SUM(LOG(COALESCE(factor,
1)))),
4
) * 100, 2), 6, '000'),
'%'
) Effectiveness
FROM
`type_effectiveness`
WHERE
defending_type IN(
SELECT TYPE
FROM
type_assignment
WHERE
species_id = 423
AND form_id = (SELECT combat_form_id FROM effective_species WHERE id = 423 AND form_id = 12)
)
GROUP BY TYPE
ORDER BY
LPAD(ROUND( EXP(SUM(LOG(COALESCE(factor, 1)))), 4 ),4, '0') DESC,
attacking_type
Failed to prepare statement:
select ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1) as IV, CONCAT(ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1), ' %') as `IV %`, MIN(cp_with_iv_calculation(423,attack.iv, defense.iv, stamina.iv,15.0, (SELECT combat_form_id FROM effective_species WHERE id = 423 AND form_id = 12))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(423,attack.iv, defense.iv, stamina.iv,15.0, (SELECT combat_form_id FROM effective_species WHERE id = 423 AND form_id = 12))),' ') `Max CP` FROM
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) attack,
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) defense,
( SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) stamina
GROUP BY IV
ORDER BY IV DESCFailed to prepare statement:
select ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1) as IV, CONCAT(ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1), ' %') as `IV %`, MIN(cp_with_iv_calculation(423,attack.iv, defense.iv, stamina.iv,20.0, (SELECT combat_form_id FROM effective_species WHERE id = 423 AND form_id = 12))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(423,attack.iv, defense.iv, stamina.iv,20.0, (SELECT combat_form_id FROM effective_species WHERE id = 423 AND form_id = 12))),' ') `Max CP` FROM
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) attack,
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) defense,
( SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) stamina
GROUP BY IV
ORDER BY IV DESCFailed to prepare statement:
select ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1) as IV, CONCAT(ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1), ' %') as `IV %`, MIN(cp_with_iv_calculation(423,attack.iv, defense.iv, stamina.iv,25.0, (SELECT combat_form_id FROM effective_species WHERE id = 423 AND form_id = 12))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(423,attack.iv, defense.iv, stamina.iv,25.0, (SELECT combat_form_id FROM effective_species WHERE id = 423 AND form_id = 12))),' ') `Max CP` FROM
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) attack,
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) defense,
( SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) stamina
GROUP BY IV
ORDER BY IV DESC
| Species Stats |
|---|
| data |
 Gastrodon (East) L40:
1971 - 2324   ATK: 169 DEF: 143 STM: 244 |
| Candy |
|---|
| data |
| Buddy distance: 3km |
| Basic PvE Moves | |||||
|---|---|---|---|---|---|
| Name | Power | Seconds | PPS | Energy | EPS |
| Mud Slap | 18 | 1.40 | 12.86 | 12 | 8.57 |
| Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
| Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
 Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
| Basic PvP Moves | |||||
|---|---|---|---|---|---|
| Name | Power | Seconds | PPS | Energy | EPS |
| Mud Slap | 11 | 1.50 | 7.33 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
| Charged PvE Moves | |||||
|---|---|---|---|---|---|
| Name | Power | Seconds | PPS | Energy | PPE |
| Earth Power | 100 | 3.60 | 27.78 | 50 | 2.00 |
 Body Slam | 50 | 1.90 | 26.32 | 33 | 1.52 |
| Water Pulse | 70 | 3.20 | 21.88 | 50 | 1.40 |
| Charged PvP Moves | |||
|---|---|---|---|
| Name | Power | Energy | PPE |
| Body Slam | 60 | 35 | 1.71 |
| Earth Power | 90 | 55 | 1.64 |
| Water Pulse | 70 | 60 | 1.17 |