query

RESULTSET

query
	CAMPGROUND	CAMP_LOOP	CID	CID	COUNT	DES	DES	FAV	FAV	FLAT	POWER	PRIVATE	SEWER	SID	SITE	STAYED	TYPE	WATER
1	Kejimkujik	M	1	1	1	Very poor cell	Very poor cell	2	2	9	1	3	0	20	11	1	Parks Canada	0
2	Porters Lake	B	6	6	19	Large site, grass cover, mostly sun	Large site, grass cover, mostly sun	5	5	4	0	4	0	2	23	1	NS Parks	0

CACHED

false

EXECUTIONTIME

SQL

select *, count(*) as count from camping_sites inner join camping_campgrounds on camping_sites.`cid` = `camping_campgrounds`.`cid` group by camping_sites.cid order by campground

Menu

Kejimkujik

Parks Canada
Very poor cell

Porters Lake

NS Parks
Large site, grass cover, mostly sun

Add Campground