BAP By Member

8 years 3 weeks 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( ) AS cnt, IF( COUNT( ) >400, 'Master Breeder IV', IF( COUNT( ) >300, 'Master Breeder III', IF( COUNT( ) >200, 'Master Breeder II', IF( COUNT( ) >100, 'Master Breeder', IF( COUNT( ) >50, 'Expert Breeder', IF( COUNT( ) >25, 'Advanced Breeder', IF( COUNT( ) >10, 'Breeder', 'Novice' ) ) ) ) ) ) ) AS Level FROM jos_spawns JOIN jos_bap_participant ON = 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.

Time to create page: 0.054 seconds