Search For In Hobby Query: SELECT hobby.ID ID, hobby.name Name FROM hobby order by Name

---

Count Query: select hobby, count(*) num from listings where HOBBY IN ( '1', '2', '3', '4', '5', '6', '7', '9', '8', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '113', '29', '30', '31', '32', '33', '34', '35', '36', '37', '47', '38', '39', '40', '41', '42', '43', '44', '45', '46', '48', '49', '50', '51', '52', '53', '55', '56', '57', '54', '58', '59', '60', '61', '62', '63', '64', '65', '66', '67', '111', '68', '70', '69', '71', '72', '112', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '83', '84', '85', '86', '87', '115', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '114', '100', '99', '101', '102', '103', '104', '105', '106', '107', '108', '109', '110') and ACTIVE ="Y" AND Flagged = 0 GROUP BY HOBBY AllActing(0)Amateur Radio(0)Animals(0)Antiques(3)Aquariums(0)Astrology(0)Astronomy(0)Audio(0)Automobiles(2)Beading(0)Bicycling(0)Bird watching(0)Blacksmithing(0)Board Games(0)Boating(0)Body Building(0)Bowling(0)Brewing(0)Butterfly Collecting(0)Button Collecting(0)Calligraphy(0)Camping(0)Candle Making(0)Canoeing(0)Car Racing(0)Card Games(0)Cave Diving(0)Coin Collecting(0)Collectibles(0)Composing Music(0)Computer activities(8)Cooking(0)Crocheting(0)Cross-Stitch(2)Crossword Puzzles(0)Dancing(0)Darts(0)Diecast Collectibles(0)Disc Golf(0)Dollhouses(0)Dolls(0)Electronics(3)Embroidery(0)Exercise(0)Fencing(0)Fishing(0)Football(0)Four Wheeling(0)Gardening(0)Genealogy(0)Geocaching(0)Golf(0)Hang gliding(0)Hiking(0)Horse riding(0)Horticulture(0)Hot air ballooning(0)House Repair(0)Hunting(0)Illusion(0)Jewelry(0)Jigsaw Puzzles(0)Juggling(0)Kites(0)Knitting(0)Legos(0)Macrame(0)Magic(0)Martial Arts(20)Metal Detecting(0)Model Rockets(0)Models(0)Motorcycles(0)Mountain Climbing(0)Music(2)Musical Instruments(0)Needlepoint(0)Origami(0)Paintball(0)Papermache(0)Papermaking(0)Parachuting(0)Performing Arts(0)Photography(3)Pottery(0)Quilting(0)R/C Vehicles(2)Rafting(0)Robotics(0)Rock Collecting(0)Role Playing Games(0)Running(0)Scrapbooking(0)Scuba Diving(0)Sewing(0)Skateboarding(0)Skeet Shooting(0)Sky Diving(0)Snorkeling(0)Soap Making(0)Soccer(0)Spelunking(0)Sports Memorabilia(0)Stamp Collecting(0)Stamping(0)Tombstone Rubbing(0)Tools(0)Treasure Hunting(0)Visual Arts(0)Walking(0)Windsurfing(0)Wine Making(0)Woodworking(0)Yoga(0)YoYo(0)

Limit search to State All ALABAMA ALASKA AMERICAN SAMOA ARIZONA ARKANSAS CALIFORNIA COLORADO CONNECTICUT DELAWARE DISTRICT OF COLUMBIA FEDERATED STATES OF MICRONESIA FLORIDA GEORGIA GUAM HAWAII IDAHO ILLINOIS INDIANA IOWA KANSAS KENTUCKY LOUISIANA MAINE MARSHALL ISLANDS MARYLAND MASSACHUSETTS MICHIGAN MINNESOTA MISSISSIPPI MISSOURI MONTANA NEBRASKA NEVADA NEW HAMPSHIRE NEW JERSEY NEW MEXICO NEW YORK NORTH CAROLINA NORTH DAKOTA NORTHERN MARIANA ISLANDS OHIO OKLAHOMA OREGON PALAU PENNSYLVANIA PUERTO RICO RHODE ISLAND SOUTH CAROLINA SOUTH DAKOTA TENNESSEE TEXAS UTAH VERMONT VIRGIN ISLANDS VIRGINIA WASHINGTON WEST VIRGINIA WISCONSIN WYOMING Limit search to Country United States All Afghanistan Akrotiri Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua and Barbuda Argentina Armenia Aruba Ashmore and Cartier Islands Australia Austria Azerbaijan Bahamas, The Bahrain Bangladesh Barbados Bassas da India Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Bouvet Island Brazil British Indian Ocean Territory British Virgin Islands Brunei Bulgaria Burkina Faso Burma Burundi Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China Christmas Island Clipperton Island Cocos (Keeling) Islands Colombia Comoros Congo, Democratic Republic of the Congo, Republic of the Cook Islands Coral Sea Islands Costa Rica Cote d'Ivoire Croatia Cuba Cyprus Czech Republic Denmark Dhekelia Djibouti Dominica Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Europa Island Falkland Islands (Islas Malvinas) Faroe Islands Fiji Finland France French Guiana French Polynesia French Southern and Antarctic Lands Gabon Gambia, The Gaza Strip Georgia Germany Ghana Gibraltar Glorioso Islands Greece Greenland Grenada Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard Island and McDonald Islands Holy See (Vatican City) Honduras Hong Kong Hungary Iceland India Indonesia Iran Iraq Ireland Isle of Man Israel Italy Jamaica Jan Mayen Japan Jersey Jordan Juan de Nova Island Kazakhstan Kenya Kiribati Korea, North Korea, South Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia, Federated States of Moldova Monaco Mongolia Montserrat Morocco Mozambique Namibia Nauru Navassa Island Nepal Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Northern Mariana Islands Norway Oman Pakistan Palau Panama Papua New Guinea Paracel Islands Paraguay Peru Philippines Pitcairn Islands Poland Portugal Puerto Rico Qatar Reunion Romania Russia Rwanda Saint Helena Saint Kitts and Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines Samoa San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia and Montenegro Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Georgia and the South Sandwich Islands Spain Spratly Islands Sri Lanka Sudan Suriname Svalbard Swaziland Sweden Switzerland Syria Taiwan Tajikistan Tanzania Thailand Timor-Leste Togo Tokelau Tonga Trinidad and Tobago Tromelin Island Tunisia Turkey Turkmenistan Turks and Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States Uruguay Uzbekistan Vanuatu Venezuela Vietnam Virgin Islands Wake Island Wallis and Futuna West Bank Western Sahara Yemen Zambia Zimbabwe