An Error Was Encountered

Call to AppServer failed. Status: sql_query_error
Message:

Error in SQL query. SQL DB engine has returned the following: Out of memory (Needed 4190160 bytes)
. The query was: SELECT SQL_CALC_FOUND_ROWS `z_oc_category_2008-7-18`.title_1 AS title,`z_oc_category_2008-7-18`.id,assoc.ael_role,assoc.ael_note,assoc.note,assoc.sorder AS ael_sorder ,	ac.id AS access_id,
					ac.can_view AS access_can_view,
					ac.can_sell AS access_can_sell,
					ac.sell_type AS access_sell_type,
					ac.sell_price_id AS access_sell_price_id,
					aca.sell_type AS aaccess_sell_type,
					aca.sell_price_id AS aaccess_sell_price_id,
					acd.id AS daccess_id,
					acd.can_view AS daccess_can_view,
					acd.can_sell AS daccess_can_sell,
					aca.can_view AS aaccess_can_view,
					aca.can_sell AS aaccess_can_sell,
					acd.sell_type AS daccess_sell_type,
					acd.sell_price_id AS daccess_sell_price_id,
					acd_bo.id AS doaccess_id,
					acd_bo.can_view AS doaccess_can_view,
					acd_bo.can_sell AS doaccess_can_sell,
					acd_bo.sell_type AS doaccess_sell_type,
					acd_bo.sell_price_id AS doaccess_sell_price_id
 FROM assoc, `z_oc_category_2008-7-18` 	
					/* Access to a particular object */
					LEFT JOIN objects_access ac ON 	ac.id=`z_oc_category_2008-7-18`.access_id
														AND ac.owner_type_id=`z_oc_category_2008-7-18`.owner_type_id
														AND ac.owner_id=`z_oc_category_2008-7-18`.owner_id
														AND ac.assigned_owner_type_id='12'
														AND ac.assigned_owner_id='2'
					
					/* Access to a particular object, by particular accessor owner type and any owner_id */
					LEFT JOIN objects_access aca ON ac.id IS NULL
												AND aca.id=`z_oc_category_2008-7-18`.access_id
												AND aca.owner_type_id=`z_oc_category_2008-7-18`.owner_type_id
												AND aca.owner_id=`z_oc_category_2008-7-18`.owner_id
												AND aca.assigned_owner_type_id='12'
												AND aca.assigned_owner_id='0'
												
					/* Defaults for the object owner */
					LEFT JOIN objects_access_defaults acd ON aca.id IS NULL
											AND acd.own ()