Event Alerts

Please enable the javascript to submit this form

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}