SELECT clubs.club_id AS clubs_club_id, clubs.long_name AS clubs_long_name, clubs.short_name AS clubs_short_name, clubs.address AS clubs_address, clubs.grass AS clubs_grass, clubs.lights AS clubs_lights, clubs.courts AS clubs_courts, clubs.website AS clubs_website, clubs.special_requests AS clubs_special_requests, clubs.directions AS clubs_directions, clubs.comments AS clubs_comments, clubs.lat AS clubs_lat, clubs.lon AS clubs_lon, clubs.contact_id AS clubs_contact_id 
FROM clubs