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 = 028
AND form_id = (SELECT combat_form_id FROM effective_species WHERE id = 028 AND form_id = 00)
)
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(028,attack.iv, defense.iv, stamina.iv,15.0, (SELECT combat_form_id FROM effective_species WHERE id = 028 AND form_id = 00))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(028,attack.iv, defense.iv, stamina.iv,15.0, (SELECT combat_form_id FROM effective_species WHERE id = 028 AND form_id = 00))),' ') `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(028,attack.iv, defense.iv, stamina.iv,20.0, (SELECT combat_form_id FROM effective_species WHERE id = 028 AND form_id = 00))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(028,attack.iv, defense.iv, stamina.iv,20.0, (SELECT combat_form_id FROM effective_species WHERE id = 028 AND form_id = 00))),' ') `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(028,attack.iv, defense.iv, stamina.iv,25.0, (SELECT combat_form_id FROM effective_species WHERE id = 028 AND form_id = 00))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(028,attack.iv, defense.iv, stamina.iv,25.0, (SELECT combat_form_id FROM effective_species WHERE id = 028 AND form_id = 00))),' ') `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