BAP By Current Year BAP By Year BAP By Member BAP Detailed Data

Bap by Member

Use the search to filter data by either first name or last name

{arttablesorter filter="true" stripeRowsOnStartUp="true" theme="blue" class="table sorter"}{artsqltable attributes="class=tablesorter" query="SELECT jos_bap_participant.first_name, jos_bap_participant.last_name, COUNT( jos_spawns.id ) AS cnt, IF( COUNT( jos_spawns.id ) >400, 'Master Breeder IV', IF( COUNT( jos_spawns.id ) >300, 'Master Breeder III', IF( COUNT( jos_spawns.id ) >200, 'Master Breeder II', IF( COUNT( jos_spawns.id ) >100, 'Master Breeder', IF( COUNT( jos_spawns.id ) >50, 'Expert Breeder', IF( COUNT( jos_spawns.id ) >25, 'Advanced Breeder', IF( COUNT(jos_spawns.id ) >10, 'Breeder', 'Novice' ) ) ) ) ) ) ) AS Level FROM jos_spawns JOIN jos_bap_participant ON jos_bap_participant.id = s_breeder GROUP BY s_breeder ORDER BY cnt DESC " headerNames="First N Name, Last Name, Level, Number of Spawns" headers=" first_name,last_name, Level, cnt"}{/artsqltable}{/arttablesorter}