Five Star Connections Header Banner
PLAN YOUR EVENT

Looking for places to visit and things to do in San Diego ... start here
San Diego Travel
Websource

Thinking of a Cruise?

Planning a Wedding?

Make
FiveStarConnections.com
Your Home Page

National Listings Event Outdoor Furnishings and Home Life Necessities

National Listings Event Outdoor Furnishings from your Event Home Life Necessities Vendors

Return to National Listings listings

Five Star Events



This script cannot continue, terminating.

Error:

Can not execute query

			SELECT *
			FROM (

			SELECT

			image,
			company_name,
			url,
			show_address,
			address1,
			city,
			state,
			zipcode,
			zip4,
			phone_areacode,
			phone_number,
			show_phone2,
			phone2_areacode,
			phone2_number,
			public_message,
			email,
			show_email,
			show_url,
			display_level,
			contact1_firstname,
			contact1_lastname,
			service_area, show_service_area,
			tbl_vendors.vendor_id, vendor_uid , (url <> '') * show_url AS has_url, image <> '' AS has_image,
(url <> '') * show_url * (image <> '') AS has_image_and_url, 
			para_values.value, para_fields.label, para_fields.name

			FROM  tbl_vendors
			INNER JOIN itbl_regions_vendors ON tbl_vendors.vendor_id = itbl_regions_vendors.vendor_id
			INNER JOIN itbl_sites_vendors Use Index (site_id) ON tbl_vendors.vendor_id = itbl_sites_vendors.vendor_id
 INNER JOIN itbl_subtypes_vendors ON tbl_vendors.vendor_id =  itbl_subtypes_vendors.vendor_id AND itbl_subtypes_vendors.subtype_id = 211
			LEFT JOIN para_values ON tbl_vendors.vendor_id = para_values.vendor_id AND para_values.value <> '' AND para_values.active = 1
			LEFT JOIN para_fields ON para_values.para_field_id = para_fields.id
			WHERE
				0=0 
				AND itbl_regions_vendors.region_id = 12
				AND itbl_sites_vendors.site_id = 5
				AND itbl_sites_vendors.display_level <> 0 
	) t   ORDER BY 
	-- comment til jan 2006	
	has_image_and_url DESC,	
has_url DESC, company_name LIMIT 0, 1000
:
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay