Planet Charters adventure vacations in Western, Canada.

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
  Fishing on Lake Michigan for salmon and tro...,
Illinois, US
  Scuba Diving,
French Polynesia, PF
  Salmon fishing on Lake Michigan on a 39' bo...,
Illinois, US
  Flyfishing for Northern Pike,
Alaska, US
  Bus and coach charter in Europe,
Overijssel, NL
---

 

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=37 AND rt.city_id=tbllisting_totals.city_id AND tblvirtuallocation.virtloc_type NOT IN (1) AND tblprovince.country_id=223 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'