Planet Charters adventure vacations in Midwest, United States.

PlanetCharters.com
Top Footer

Look for in  Go
Service ID # Go
Search site Go
---
  Browse Adventures
  Post your Service
  Tell A Friend
  Newsletter
Featured Adventure

Friday Harbor, WA Friday Harbor, WA
  Also Featuring
  Boat Charters out of Port Hardy BC Canada,
British Columbia, CA
  Liveaboard dive charter boat, Milne Bay, PN...,
Papua New Guinea, PG
  Mt. Baker area cabins, cottages, and condos...,
Washington, US
  inshore and offshore fishing,
Florida, US
  Sea Kayak Adventure Tours,
Nova Scotia, CA
  Taveuni's Finest Diving,
Taveuni, FJ
---

 

SELECT DISTINCT tblvirtuallocation.virtloc_id,tblvirtuallocation.virtloc_desc,'r-'||tblvirtuallocation.virtloc_key,COUNT(DISTINCT list_id) AS item_count FROM tblvirtuallocation LEFT OUTER JOIN tblregion_totals ON tblregion_totals.virtloc_id=tblvirtuallocation.virtloc_id LEFT OUTER JOIN tbllisting_totals ON tbllisting_totals.city_id=tblregion_totals.city_id ,tblregion_totals rt LEFT OUTER JOIN tblcity ON tblcity.city_id=tbllisting_totals.city_id LEFT OUTER JOIN tblprovince ON tblprovince.prov_id=tblcity.prov_id WHERE tblvirtuallocation.virtloc_id IS NOT NULL AND tblvirtuallocation.virtloc_type=1 AND rt.virtloc_id=28 AND rt.city_id=tbllisting_totals.city_id AND tblvirtuallocation.virtloc_type NOT IN (1) AND tblprovince.country_id=371 GROUP BY tblvirtuallocation.virtloc_id,virtloc_desc,tblvirtuallocation.virtloc_key HAVING item_count>0 ORDER BY tblvirtuallocation.virtloc_desc
Unknown column 'tbllisting_totals.city_id' in 'on clause'