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

Sacramento Event Destination Wedding and Travel

Sacramento Event Destination Wedding from your Event Travel Vendors

Return to Sacramento 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 = 224
			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 = 51
				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