---

SQL - 2: select `c`.`id`, `c`.`show_id`, `c`.`code`, `c`.`image`, `c`.`fish_id`, `c`.`fish_variant_id`, `c`.`fish_breed_id`, `c`.`fish_sex_id`, `c`.`fish_size`, `c`.`image`, `c`.`owner_id`, `c`.`handler_id`, `c`.`par_handler_id`, `c`.`farm_id`, `c`.`size_id`, `c`.`championship_id`, `c`.`class_id`, `n`.* from `koishow_show_contestant` `c` left join ( select `id` `nid`, `contestant_id`, `point`, `type`, if(`type` = 1, `other_id`, `is_champion`) `v1`, if(`type` = 1, 0, `is_bis`) `v2`, if(`type` = 1, 0, `is_nominee`) `v3`, if(`type` = 1, 0, `is_runnerup`) `v4`, if(`type` = 1, 0, `is_top`) `v5` from `koishow_show_nominee` ) n on n.contestant_id = c.id where `status` = 1 AND ((`v1` > 0 OR `v2` = 1 OR `v4` > 0) AND `owner_id` = 16420) LIMIT 0,20
modules/koishow/_function.php line:2746
modules/koishow/search.php line:44
modules/koishow/_switch.php line:120
1054: Unknown column 'type' in 'field list'

---

SQL - 3: select count(1) from `koishow_show_contestant` `c` left join ( select `id` `nid`, `contestant_id`, `point`, `type`, if(`type` = 1, `other_id`, `is_champion`) `v1`, if(`type` = 1, 0, `is_bis`) `v2`, if(`type` = 1, 0, `is_nominee`) `v3`, if(`type` = 1, 0, `is_runnerup`) `v4`, if(`type` = 1, 0, `is_top`) `v5` from `koishow_show_nominee` ) n on n.contestant_id = c.id where `status` = 1 AND ((`v1` > 0 OR `v2` = 1 OR `v4` > 0) AND `owner_id` = 16420)
modules/koishow/_function.php line:2945
modules/koishow/search.php line:45
modules/koishow/_switch.php line:120
1054: Unknown column 'type' in 'field list'