Failed to prepare statement:
SELECT tp.attacker_level, tp.defender_tier, Threat, Target, `Basic Move`, `Charged Move`, AVG(EDPS) EDPS, AVG(CDPS) CDPS, Survival, AVG(Deaths) Deaths, (`Victory Factor`) `Victory Factor`, attacker_id, attacker_form_id, species_id, form_id, threat_profile_id, AVG(ranking) ranking, weather, is_best_friend FROM threats_by_profile tbp, threat_profile tp WHERE tp.id = tbp.threat_profile_id AND species_id = 822 AND form_id = 000 AND is_best_friend = 0 GROUP BY tp.attacker_level, tp.defender_tier, attacker_id, attacker_form_id, species_id, form_id, weather, is_best_friend, `Basic Move`, `Charged Move` ORDER BY weather, ranking
Forms:
Threats
Info
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 = 822
AND form_id = (SELECT combat_form_id FROM effective_species WHERE id = 822 AND form_id = 000)
)
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(822,attack.iv, defense.iv, stamina.iv,15.0, (SELECT combat_form_id FROM effective_species WHERE id = 822 AND form_id = 000))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(822,attack.iv, defense.iv, stamina.iv,15.0, (SELECT combat_form_id FROM effective_species WHERE id = 822 AND form_id = 000))),' ') `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(822,attack.iv, defense.iv, stamina.iv,20.0, (SELECT combat_form_id FROM effective_species WHERE id = 822 AND form_id = 000))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(822,attack.iv, defense.iv, stamina.iv,20.0, (SELECT combat_form_id FROM effective_species WHERE id = 822 AND form_id = 000))),' ') `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(822,attack.iv, defense.iv, stamina.iv,25.0, (SELECT combat_form_id FROM effective_species WHERE id = 822 AND form_id = 000))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(822,attack.iv, defense.iv, stamina.iv,25.0, (SELECT combat_form_id FROM effective_species WHERE id = 822 AND form_id = 000))),' ') `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
',
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 = 822
AND form_id = (SELECT combat_form_id FROM effective_species WHERE id = 822 AND form_id = 000)
)
GROUP BY TYPE
ORDER BY
LPAD(ROUND( EXP(SUM(LOG(COALESCE(factor, 1)))), 4 ),4, '0') DESC,
attacking_type 
