Planet Charters adventure vacations in West, United States.
Top Footer

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

Friday Harbor, WA Friday Harbor, WA
  Also Featuring
  Private Island with Dive Resort,
Papua New Guinea, PG
  Fishing Charters,
Florida, US
  Van & Coach Charter of Atlantic Canada,
Nova Scotia, CA


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=167 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'