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

San Diego Wedding Speaker

Have fun planning your San Diego event.

Return to San Diego 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_types_vendors ON tbl_vendors.vendor_id =  itbl_types_vendors.vendor_id AND itbl_types_vendors.type_id = 69
			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 = 20
				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