Sign up for email reminders for Meetings, Swaps, Auctions, and Other Events.

Subscribe

Sign up for email reminders for Meetings, Swaps, Auctions, and Other Events.

BAP By Member

7 years 8 months ago #37302 by libasci
BAP By Member was created by libasci
BAP By Current Year
...

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}

Please Log in or Create an account to join the conversation.

More
Time to create page: 0.060 seconds