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

New York City Wedding Transportation

Have fun planning your New York City event.

Return to New York City listings.

Five Star Events

  Car Rental (1)


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 = 36
			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 = 3
				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