SELECT * FROM tblTrophy AS a WHERE (Guid IN (SELECT TOP 1 Guid FROM tblTrophy AS b WHERE (Specie = a.Specie) AND (Status <> 'Archived') AND (Specie <> '') ORDER BY MainImage DESC, OutfitterName)) ORDER BY Specie
|
Member and Preferred Outfitters Photos
|
|

for as little as $19.99/yr!
.jpg)
"I would not have had the opportunity for this buck of a lifetime without the Magnum Hunt Club."
~Dale Sears
|