Executed SQL

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

Time

0.09 ms

Results

CLUBS_CLUB_ID	CLUBS_LONG_NAME	CLUBS_SHORT_NAME	CLUBS_ADDRESS	CLUBS_GRASS	CLUBS_LIGHTS	CLUBS_COURTS	CLUBS_WEBSITE	CLUBS_SPECIAL_REQUESTS	CLUBS_DIRECTIONS	CLUBS_COMMENTS	CLUBS_LAT	CLUBS_LON	CLUBS_CONTACT_ID
1	Thurlestone Golf Club	Thurlestone	Thurlestone Golf Club, Thurlestone, Kingsbridge TQ7 3NZ	1	0	10	www.thurlestonegolfclub.co.uk	Matches to start mid May	Go through village towards the sea, club on right. Register parking at Pro Shop		50.2659	-3.86134	2
2	Cary Park Tennis Club	Cary Park	We can only enter men\'s 2nds if home games are on Sat/Sun Afternoons	0	0	2	www.caryparktennis.co.uk	We can only enter men\'s 2nds if home games are on Sat/Sun Afternoons			50.4777	-3.51914	1094
3	Avon Vale Tennis and Croquet Club	Avon Vale	Later matches because of grass	1	0	5	www.avonvaletennisandcroquet.org.uk	Later matches because of grass			50.4082	-3.81227	664
4	Kingsbridge Park Community Tennis	Kingsbridge Park	Memorial recreation Ground,\r\nEmbankment Road,\r\nKingsbridge TQ7 1JN	0	1	2	communitytennis.info		Turn Left off Derby Road Kingsbridge TQ7 1JN		50.2815	-3.7732	1005
5	Newton & Noss Tennis Club	Newton & Noss		0	0	2	clubspark.lta.org.uk/newtonnosstennisclub				50.3084	-4.04182	1439
6	Kingsbridge Lawn Tennis Club	Kingsbridge Lawn	The Clubhouse, Ebrington Street, Kingsbridge, Devon TQ7 1DE	0	1	3			LH Narrow Turning off Ebrington Street		50.2827	-3.77363	572
7	Dartmouth	Dartmouth	Coronation Park, Manor St., Dartmouth TQ6 0EX	0	1	4					50.3551	-3.5784	328
8	Churston Tennis Club	Churston	Churston Road, Churston Ferrers TQ5 0HU	0	1	2					50.3964	-3.54294	1055
12	Salcombe Tennis Club	Salcombe		0	0	2	www.salcombetennis.club		From Malborough to Salcombe. Past Petrol Station on right. Next left. Next right - St Dunstan\'s Road. Next left - Raleigh Road. At bottom left - Bonaventure Rd. The club gate is between 2 houses immediately on your right. Park Raleigh Road.		50.2382	-3.77101	59
13	Totnes Community Tennis Club	Totnes		0	1	2	www.totnestennis.co.uk				50.4357	-3.68784	1530
14	Ivybridge Tennis Club	Ivybridge	Erm Playing Fields\r\nErmington Road PL21 9ES	0	1	2	sdtc.mycourts.co.uk				50.3836	-3.92559	169
16	Newton Abbot Tennis Club	Newton Abbot	Marsh Road, Newton Abbot TQ12 2AR	0	1	2	www.nasquash.co.uk		Off the avenue to marsh road		50.532	-3.60494	935
17	Bovey Tracey	Bovey Tracey	Newton Road,\r\nBovey Tracey\r\nTQ13 9PF	0	1	2	www.boveytraceyltc.com		Located in spots ground off Newton Road	Courts not available until 6:15	50.5853	-3.67812	664
18	Ipplepen Tennis Club	Ipplepen		0	1	2	clubspark.lta.org.uk/IpplepenTennisClub		Google Maps - Ipplepen Tennis Club TQ12 5SB		50.4861	-3.64553	1509
19	Torquay Tennis Club	Torquay		0	1	9	www.torquaytennisclub.co.uk				50.4657	-3.536	1777