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 = 208
AND form_id = (SELECT combat_form_id FROM effective_species WHERE id = 208 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(208,attack.iv, defense.iv, stamina.iv,15.0, (SELECT combat_form_id FROM effective_species WHERE id = 208 AND form_id = 00))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(208,attack.iv, defense.iv, stamina.iv,15.0, (SELECT combat_form_id FROM effective_species WHERE id = 208 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(208,attack.iv, defense.iv, stamina.iv,20.0, (SELECT combat_form_id FROM effective_species WHERE id = 208 AND form_id = 00))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(208,attack.iv, defense.iv, stamina.iv,20.0, (SELECT combat_form_id FROM effective_species WHERE id = 208 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(208,attack.iv, defense.iv, stamina.iv,25.0, (SELECT combat_form_id FROM effective_species WHERE id = 208 AND form_id = 00))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(208,attack.iv, defense.iv, stamina.iv,25.0, (SELECT combat_form_id FROM effective_species WHERE id = 208 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
',
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 = 208
AND form_id = (SELECT combat_form_id FROM effective_species WHERE id = 208 AND form_id = 00)
)
GROUP BY TYPE
ORDER BY
LPAD(ROUND( EXP(SUM(LOG(COALESCE(factor, 1)))), 4 ),4, '0') DESC,
attacking_type 
Onix
