backTrace

/home/ecotouri/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 159
, handle, 
/home/ecotouri/public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/home/ecotouri/public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 971
/home/ecotouri/public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/home/ecotouri/public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home/ecotouri/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/home/ecotouri/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/ecotouri/public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/ecotouri/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2421
/home/ecotouri/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1607
/home/ecotouri/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 145
/home/ecotouri/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 868
/home/ecotouri/public_html/sites/all/modules/civicrm/CRM/Contact/BAO/GroupContact.php, executeQuery, 404
/home/ecotouri/public_html/sites/all/modules/civicrm/CRM/Contact/BAO/GroupContact.php, getContactGroup, 116
/home/ecotouri/public_html/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php, getValues, 600
/home/ecotouri/public_html/sites/all/modules/ctools/plugins/access/php.inc(54) : eval()'d code, retrieve, 19
/home/ecotouri/public_html/sites/all/modules/ctools/plugins/access/php.inc, eval, 54
/home/ecotouri/public_html/sites/all/modules/ctools/includes/context.inc, ctools_php_ctools_access_check, 1434
/home/ecotouri/public_html/sites/all/modules/ctools/includes/context-task-handler.inc, ctools_access, 175
/home/ecotouri/public_html/sites/all/modules/panels/plugins/task_handlers/panel_context.inc, ctools_context_handler_select, 250
/home/ecotouri/public_html/sites/all/modules/ctools/includes/context-task-handler.inc, panels_panel_context_render, 45
/home/ecotouri/public_html/sites/all/modules/ctools/page_manager/plugins/tasks/page.inc, ctools_context_handler_render, 333
, page_manager_page_execute, 
/home/ecotouri/public_html/includes/menu.inc, call_user_func_array, 350
/home/ecotouri/public_html/index.php, menu_execute_active_handler, 17

| The International Ecotourism Society
Sorry. A non-recoverable error has occurred.

DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Error Details
Database Error Code: Incorrect key file for table '/tmp/#sql_e1eb_1.MYI'; try to repair it, 126
Additional Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => SELECT 
                    civicrm_group_contact.id as civicrm_group_contact_id, 
                    civicrm_group.title as group_title,
                    civicrm_group.visibility as visibility,
                    civicrm_group_contact.status as status, 
                    civicrm_group.id as group_id,
                    civicrm_subscription_history.date as date,
                    civicrm_subscription_history.method as method FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (contact_a.id = civicrm_phone.contact_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (contact_a.id = civicrm_im.contact_id AND civicrm_im.is_primary = 1)  LEFT JOIN civicrm_group_contact ON contact_a.id = civicrm_group_contact.contact_id  LEFT JOIN civicrm_group ON civicrm_group.id =  civicrm_group_contact.group_id  LEFT JOIN civicrm_subscription_history
                                   ON civicrm_group_contact.contact_id = civicrm_subscription_history.contact_id
                                  AND civicrm_group_contact.group_id   =  civicrm_subscription_history.group_id LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_worldregion ON civicrm_country.region_id = civicrm_worldregion.id   LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-39` ON ( `civicrm_entity_tag-39`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-39`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-40` ON ( `civicrm_entity_tag-40`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-40`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-54` ON ( `civicrm_entity_tag-54`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-54`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-79` ON ( `civicrm_entity_tag-79`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-79`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-91,92,93,94,95,96` ON ( `civicrm_entity_tag-91,92,93,94,95,96`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-91,92,93,94,95,96`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_group_contact `civicrm_group_contact-37` ON contact_a.id = `civicrm_group_contact-37`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-43,44` ON contact_a.id = `civicrm_group_contact-43,44`.contact_id    LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_43` ON contact_a.id = `civicrm_group_contact_cache_43`.contact_id    LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_44` ON contact_a.id = `civicrm_group_contact_cache_44`.contact_id   LEFT JOIN civicrm_membership ON civicrm_membership.contact_id = contact_a.id  LEFT JOIN civicrm_contribution_recur ccr ON ( civicrm_membership.contribution_recur_id = ccr.id ) LEFT JOIN civicrm_membership_status ON civicrm_membership.status_id = civicrm_membership_status.id  LEFT JOIN civicrm_membership_type ON civicrm_membership.membership_type_id = civicrm_membership_type.id  
LEFT JOIN civicrm_value_non_member_group_4 ON civicrm_value_non_member_group_4.entity_id = contact_a.id  LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender') LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value AND option_group_gender.id = gender.option_group_id)  LEFT JOIN civicrm_option_group option_group_prefix ON (option_group_prefix.name = 'individual_prefix') LEFT JOIN civicrm_option_value individual_prefix ON (contact_a.prefix_id = individual_prefix.value AND option_group_prefix.id = individual_prefix.option_group_id )  LEFT JOIN civicrm_option_group option_group_suffix ON (option_group_suffix.name = 'individual_suffix') LEFT JOIN civicrm_option_value individual_suffix ON (contact_a.suffix_id = individual_suffix.value AND option_group_suffix.id = individual_suffix.option_group_id )  WHERE contact_a.id = 38382 AND civicrm_group.is_active = 1  AND civicrm_group_contact.status = 'Added' AND  (  ( civicrm_group_contact.group_id IN (28, 35, 36, 37, 38, 39, 40, 43, 44, 45, 49, 50, 52, 53, 54, 55, 56, 57, 59, 60, 61, 62, 63, 64, 65, 67, 68, 69, 70, 72, 73, 74, 76, 77, 78, 79, 80, 81, 75 ) AND civicrm_group_contact.status = 'Added' )  OR  (  ( LOWER(civicrm_membership_type.name) IS NULL AND contact_a.contact_type IN ('Individual') AND civicrm_value_non_member_group_4.non_member_information_54 = 'tourism and related industry professional' )  )  OR  ( civicrm_membership.membership_type_id = 5 AND  civicrm_membership.owner_membership_id IS NULL AND civicrm_membership.is_test = 0 )  OR  (  ( LOWER(civicrm_membership_type.name) = 'organization' AND LOWER(civicrm_membership_status.name) = 'expired' AND `civicrm_entity_tag-39`.tag_id = (39) AND `civicrm_entity_tag-40`.tag_id = (40) AND contact_a.contact_type IN ('Organization') )  )  OR  (  ( LOWER(civicrm_membership_type.name) = 'organization' AND LOWER(civicrm_membership_status.name) = 'expired' AND `civicrm_entity_tag-39`.tag_id = (39) AND `civicrm_entity_tag-40`.tag_id = (40) AND `civicrm_entity_tag-54`.tag_id = (54) AND contact_a.contact_type IN ('Organization') )  )  OR  ( civicrm_membership.membership_type_id = 5 AND  civicrm_membership.owner_membership_id IS NOT NULL AND civicrm_membership.status_id IN ('1','2','3') AND civicrm_membership.is_test = 0 )  OR  ( civicrm_membership.membership_type_id = 4 AND civicrm_membership.status_id IN ('1','2','3') AND civicrm_membership.is_test = 0 )  OR  ( ( ( `civicrm_group_contact-43,44`.group_id IN ( 43,44 ) AND `civicrm_group_contact-43,44`.status IN ("Added") ) OR ( `civicrm_group_contact_cache_43`.group_id = 43 OR `civicrm_group_contact_cache_44`.group_id = 44 ) ) )  OR  (  ( LOWER(civicrm_membership_type.name) = 'organization' AND LOWER(civicrm_country.name) = 'argentina' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_membership_status.name) = 'new' AND LOWER(civicrm_membership_status.name) = 'current' AND LOWER(civicrm_membership_status.name) = 'grace' AND LOWER(civicrm_membership_status.name) = 'expired' )  OR  ( LOWER(civicrm_country.name) = 'bolivia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'brazil' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'chile' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'colombia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'ecuador' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'french guiana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'guyana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'paraguay' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'peru' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'suriname' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'uruguay' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'venezuela' AND contact_a.contact_type IN ('Organization') )  )  OR  (  ( LOWER(civicrm_country.name) = 'argentina' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'bolivia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'brazil' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'chile' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'colombia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'ecuador' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'french guiana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'guyana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'paraguay' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'peru' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'suriname' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'uruguay' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'venezuela' AND contact_a.contact_type IN ('Individual') )  )  OR  (  ( LOWER(civicrm_country.name) = 'argentina' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'bolivia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'brazil' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'chile' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'colombia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'ecuador' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'french guiana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'guyana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'paraguay' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'peru' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'suriname' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'uruguay' AND contact_a.contact_type IN ('Organization') )  )  OR  ( civicrm_state_province.id IN (1004) AND civicrm_country.id = 1228 AND contact_a.contact_type IN ('Individual') )  OR  ( civicrm_event.id = 11 AND civicrm_participant.status_id = 1 AND civicrm_participant.is_test = 0 )  OR  ( `civicrm_entity_tag-91,92,93,94,95,96`.tag_id IN (91,92,93,94,95,96) )  OR  ( LOWER(civicrm_worldregion.name) = 'africa west, east, central and southern' AND ( ( `civicrm_group_contact-43,44`.group_id IN ( 43,44 ) AND `civicrm_group_contact-43,44`.status IN ("Added") ) OR ( `civicrm_group_contact_cache_43`.group_id = 43 OR `civicrm_group_contact_cache_44`.group_id = 44 ) ) )  OR  ( contact_a.contact_type IN ('Individual') AND `civicrm_entity_tag-79`.tag_id IN (79) )  OR  ( contact_a.contact_type IN ('Individual') )  OR  ( contact_a.contact_type IN ('Individual') )  OR  ( civicrm_membership.membership_type_id = 4 AND civicrm_membership.is_test = 0 )  OR  ( civicrm_membership.membership_type_id IN ('5','10','11') AND  civicrm_membership.owner_membership_id IS NOT NULL AND civicrm_membership.is_test = 0 )  OR  (  ( ( civicrm_value_non_member_group_4.non_member_information_54 like '%tourism and related industry professional%' )  )  )  OR  (  ( `civicrm_group_contact-37`.group_id = ( 37 ) AND `civicrm_group_contact-37`.status IN ("Added") AND contact_a.contact_type IN ('Individual') AND civicrm_value_non_member_group_4.non_member_information_54 != 'tourism and related industry professional' )  )  OR  (  ( LOWER(civicrm_country.name) = 'algeria' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'angola' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'benin' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'botswana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'burkina faso' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'burundi' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'cameroon' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'cape verde' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'central african republic' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'chad' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'comoros' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'congo, the democratic republic of' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'congo' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'djibouti' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'egypt' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'equatorial guinea' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'eritrea' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'ethiopia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'gabon' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'gambia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'ghana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'guinea' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'guinea-bissau' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'côte d\'ivoire' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'kenya' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'lesotho' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'liberia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'libyan arab jamahiriya' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'madagascar' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'malawi' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mali' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mauritania' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mauritius' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'morocco' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mozambique' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'namibia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'niger' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'nigeria' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'rwanda' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'sao tome and principe' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'senegal' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'seychelles' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'sierra leone' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'somalia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'south africa' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'south sudan' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'sudan' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'swaziland' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'tanzania, united republic of' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'togo' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'tunisia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'uganda' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'zambia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'zimbabwe' AND contact_a.contact_type IN ('Individual') )  )  OR  ( LOWER(civicrm_worldregion.name) = 'europe and central asia' AND contact_a.contact_type IN ('Individual') )  )   ORDER BY civicrm_group.title, civicrm_subscription_history.date ASC LIMIT 0, 3 [nativecode=126 ** Incorrect key file for table '/tmp/#sql_e1eb_1.MYI'; try to repair it]
    [type] => DB_Error
    [user_info] => SELECT 
                    civicrm_group_contact.id as civicrm_group_contact_id, 
                    civicrm_group.title as group_title,
                    civicrm_group.visibility as visibility,
                    civicrm_group_contact.status as status, 
                    civicrm_group.id as group_id,
                    civicrm_subscription_history.date as date,
                    civicrm_subscription_history.method as method FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (contact_a.id = civicrm_phone.contact_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (contact_a.id = civicrm_im.contact_id AND civicrm_im.is_primary = 1)  LEFT JOIN civicrm_group_contact ON contact_a.id = civicrm_group_contact.contact_id  LEFT JOIN civicrm_group ON civicrm_group.id =  civicrm_group_contact.group_id  LEFT JOIN civicrm_subscription_history
                                   ON civicrm_group_contact.contact_id = civicrm_subscription_history.contact_id
                                  AND civicrm_group_contact.group_id   =  civicrm_subscription_history.group_id LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_worldregion ON civicrm_country.region_id = civicrm_worldregion.id   LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-39` ON ( `civicrm_entity_tag-39`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-39`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-40` ON ( `civicrm_entity_tag-40`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-40`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-54` ON ( `civicrm_entity_tag-54`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-54`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-79` ON ( `civicrm_entity_tag-79`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-79`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-91,92,93,94,95,96` ON ( `civicrm_entity_tag-91,92,93,94,95,96`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-91,92,93,94,95,96`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_group_contact `civicrm_group_contact-37` ON contact_a.id = `civicrm_group_contact-37`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-43,44` ON contact_a.id = `civicrm_group_contact-43,44`.contact_id    LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_43` ON contact_a.id = `civicrm_group_contact_cache_43`.contact_id    LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_44` ON contact_a.id = `civicrm_group_contact_cache_44`.contact_id   LEFT JOIN civicrm_membership ON civicrm_membership.contact_id = contact_a.id  LEFT JOIN civicrm_contribution_recur ccr ON ( civicrm_membership.contribution_recur_id = ccr.id ) LEFT JOIN civicrm_membership_status ON civicrm_membership.status_id = civicrm_membership_status.id  LEFT JOIN civicrm_membership_type ON civicrm_membership.membership_type_id = civicrm_membership_type.id  
LEFT JOIN civicrm_value_non_member_group_4 ON civicrm_value_non_member_group_4.entity_id = contact_a.id  LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender') LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value AND option_group_gender.id = gender.option_group_id)  LEFT JOIN civicrm_option_group option_group_prefix ON (option_group_prefix.name = 'individual_prefix') LEFT JOIN civicrm_option_value individual_prefix ON (contact_a.prefix_id = individual_prefix.value AND option_group_prefix.id = individual_prefix.option_group_id )  LEFT JOIN civicrm_option_group option_group_suffix ON (option_group_suffix.name = 'individual_suffix') LEFT JOIN civicrm_option_value individual_suffix ON (contact_a.suffix_id = individual_suffix.value AND option_group_suffix.id = individual_suffix.option_group_id )  WHERE contact_a.id = 38382 AND civicrm_group.is_active = 1  AND civicrm_group_contact.status = 'Added' AND  (  ( civicrm_group_contact.group_id IN (28, 35, 36, 37, 38, 39, 40, 43, 44, 45, 49, 50, 52, 53, 54, 55, 56, 57, 59, 60, 61, 62, 63, 64, 65, 67, 68, 69, 70, 72, 73, 74, 76, 77, 78, 79, 80, 81, 75 ) AND civicrm_group_contact.status = 'Added' )  OR  (  ( LOWER(civicrm_membership_type.name) IS NULL AND contact_a.contact_type IN ('Individual') AND civicrm_value_non_member_group_4.non_member_information_54 = 'tourism and related industry professional' )  )  OR  ( civicrm_membership.membership_type_id = 5 AND  civicrm_membership.owner_membership_id IS NULL AND civicrm_membership.is_test = 0 )  OR  (  ( LOWER(civicrm_membership_type.name) = 'organization' AND LOWER(civicrm_membership_status.name) = 'expired' AND `civicrm_entity_tag-39`.tag_id = (39) AND `civicrm_entity_tag-40`.tag_id = (40) AND contact_a.contact_type IN ('Organization') )  )  OR  (  ( LOWER(civicrm_membership_type.name) = 'organization' AND LOWER(civicrm_membership_status.name) = 'expired' AND `civicrm_entity_tag-39`.tag_id = (39) AND `civicrm_entity_tag-40`.tag_id = (40) AND `civicrm_entity_tag-54`.tag_id = (54) AND contact_a.contact_type IN ('Organization') )  )  OR  ( civicrm_membership.membership_type_id = 5 AND  civicrm_membership.owner_membership_id IS NOT NULL AND civicrm_membership.status_id IN ('1','2','3') AND civicrm_membership.is_test = 0 )  OR  ( civicrm_membership.membership_type_id = 4 AND civicrm_membership.status_id IN ('1','2','3') AND civicrm_membership.is_test = 0 )  OR  ( ( ( `civicrm_group_contact-43,44`.group_id IN ( 43,44 ) AND `civicrm_group_contact-43,44`.status IN ("Added") ) OR ( `civicrm_group_contact_cache_43`.group_id = 43 OR `civicrm_group_contact_cache_44`.group_id = 44 ) ) )  OR  (  ( LOWER(civicrm_membership_type.name) = 'organization' AND LOWER(civicrm_country.name) = 'argentina' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_membership_status.name) = 'new' AND LOWER(civicrm_membership_status.name) = 'current' AND LOWER(civicrm_membership_status.name) = 'grace' AND LOWER(civicrm_membership_status.name) = 'expired' )  OR  ( LOWER(civicrm_country.name) = 'bolivia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'brazil' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'chile' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'colombia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'ecuador' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'french guiana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'guyana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'paraguay' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'peru' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'suriname' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'uruguay' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'venezuela' AND contact_a.contact_type IN ('Organization') )  )  OR  (  ( LOWER(civicrm_country.name) = 'argentina' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'bolivia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'brazil' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'chile' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'colombia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'ecuador' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'french guiana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'guyana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'paraguay' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'peru' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'suriname' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'uruguay' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'venezuela' AND contact_a.contact_type IN ('Individual') )  )  OR  (  ( LOWER(civicrm_country.name) = 'argentina' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'bolivia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'brazil' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'chile' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'colombia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'ecuador' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'french guiana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'guyana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'paraguay' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'peru' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'suriname' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'uruguay' AND contact_a.contact_type IN ('Organization') )  )  OR  ( civicrm_state_province.id IN (1004) AND civicrm_country.id = 1228 AND contact_a.contact_type IN ('Individual') )  OR  ( civicrm_event.id = 11 AND civicrm_participant.status_id = 1 AND civicrm_participant.is_test = 0 )  OR  ( `civicrm_entity_tag-91,92,93,94,95,96`.tag_id IN (91,92,93,94,95,96) )  OR  ( LOWER(civicrm_worldregion.name) = 'africa west, east, central and southern' AND ( ( `civicrm_group_contact-43,44`.group_id IN ( 43,44 ) AND `civicrm_group_contact-43,44`.status IN ("Added") ) OR ( `civicrm_group_contact_cache_43`.group_id = 43 OR `civicrm_group_contact_cache_44`.group_id = 44 ) ) )  OR  ( contact_a.contact_type IN ('Individual') AND `civicrm_entity_tag-79`.tag_id IN (79) )  OR  ( contact_a.contact_type IN ('Individual') )  OR  ( contact_a.contact_type IN ('Individual') )  OR  ( civicrm_membership.membership_type_id = 4 AND civicrm_membership.is_test = 0 )  OR  ( civicrm_membership.membership_type_id IN ('5','10','11') AND  civicrm_membership.owner_membership_id IS NOT NULL AND civicrm_membership.is_test = 0 )  OR  (  ( ( civicrm_value_non_member_group_4.non_member_information_54 like '%tourism and related industry professional%' )  )  )  OR  (  ( `civicrm_group_contact-37`.group_id = ( 37 ) AND `civicrm_group_contact-37`.status IN ("Added") AND contact_a.contact_type IN ('Individual') AND civicrm_value_non_member_group_4.non_member_information_54 != 'tourism and related industry professional' )  )  OR  (  ( LOWER(civicrm_country.name) = 'algeria' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'angola' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'benin' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'botswana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'burkina faso' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'burundi' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'cameroon' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'cape verde' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'central african republic' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'chad' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'comoros' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'congo, the democratic republic of' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'congo' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'djibouti' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'egypt' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'equatorial guinea' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'eritrea' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'ethiopia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'gabon' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'gambia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'ghana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'guinea' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'guinea-bissau' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'côte d\'ivoire' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'kenya' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'lesotho' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'liberia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'libyan arab jamahiriya' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'madagascar' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'malawi' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mali' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mauritania' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mauritius' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'morocco' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mozambique' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'namibia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'niger' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'nigeria' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'rwanda' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'sao tome and principe' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'senegal' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'seychelles' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'sierra leone' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'somalia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'south africa' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'south sudan' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'sudan' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'swaziland' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'tanzania, united republic of' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'togo' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'tunisia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'uganda' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'zambia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'zimbabwe' AND contact_a.contact_type IN ('Individual') )  )  OR  ( LOWER(civicrm_worldregion.name) = 'europe and central asia' AND contact_a.contact_type IN ('Individual') )  )   ORDER BY civicrm_group.title, civicrm_subscription_history.date ASC LIMIT 0, 3 [nativecode=126 ** Incorrect key file for table '/tmp/#sql_e1eb_1.MYI'; try to repair it]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT 
                    civicrm_group_contact.id as civicrm_group_contact_id, 
                    civicrm_group.title as group_title,
                    civicrm_group.visibility as visibility,
                    civicrm_group_contact.status as status, 
                    civicrm_group.id as group_id,
                    civicrm_subscription_history.date as date,
                    civicrm_subscription_history.method as method FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (contact_a.id = civicrm_phone.contact_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (contact_a.id = civicrm_im.contact_id AND civicrm_im.is_primary = 1)  LEFT JOIN civicrm_group_contact ON contact_a.id = civicrm_group_contact.contact_id  LEFT JOIN civicrm_group ON civicrm_group.id =  civicrm_group_contact.group_id  LEFT JOIN civicrm_subscription_history
                                   ON civicrm_group_contact.contact_id = civicrm_subscription_history.contact_id
                                  AND civicrm_group_contact.group_id   =  civicrm_subscription_history.group_id LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_worldregion ON civicrm_country.region_id = civicrm_worldregion.id   LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-39` ON ( `civicrm_entity_tag-39`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-39`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-40` ON ( `civicrm_entity_tag-40`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-40`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-54` ON ( `civicrm_entity_tag-54`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-54`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-79` ON ( `civicrm_entity_tag-79`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-79`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-91,92,93,94,95,96` ON ( `civicrm_entity_tag-91,92,93,94,95,96`.entity_id = contact_a.id  AND 
                        `civicrm_entity_tag-91,92,93,94,95,96`.entity_table = 'civicrm_contact' )    LEFT JOIN civicrm_group_contact `civicrm_group_contact-37` ON contact_a.id = `civicrm_group_contact-37`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-43,44` ON contact_a.id = `civicrm_group_contact-43,44`.contact_id    LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_43` ON contact_a.id = `civicrm_group_contact_cache_43`.contact_id    LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_44` ON contact_a.id = `civicrm_group_contact_cache_44`.contact_id   LEFT JOIN civicrm_membership ON civicrm_membership.contact_id = contact_a.id  LEFT JOIN civicrm_contribution_recur ccr ON ( civicrm_membership.contribution_recur_id = ccr.id ) LEFT JOIN civicrm_membership_status ON civicrm_membership.status_id = civicrm_membership_status.id  LEFT JOIN civicrm_membership_type ON civicrm_membership.membership_type_id = civicrm_membership_type.id  
LEFT JOIN civicrm_value_non_member_group_4 ON civicrm_value_non_member_group_4.entity_id = contact_a.id  LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender') LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value AND option_group_gender.id = gender.option_group_id)  LEFT JOIN civicrm_option_group option_group_prefix ON (option_group_prefix.name = 'individual_prefix') LEFT JOIN civicrm_option_value individual_prefix ON (contact_a.prefix_id = individual_prefix.value AND option_group_prefix.id = individual_prefix.option_group_id )  LEFT JOIN civicrm_option_group option_group_suffix ON (option_group_suffix.name = 'individual_suffix') LEFT JOIN civicrm_option_value individual_suffix ON (contact_a.suffix_id = individual_suffix.value AND option_group_suffix.id = individual_suffix.option_group_id )  WHERE contact_a.id = 38382 AND civicrm_group.is_active = 1  AND civicrm_group_contact.status = 'Added' AND  (  ( civicrm_group_contact.group_id IN (28, 35, 36, 37, 38, 39, 40, 43, 44, 45, 49, 50, 52, 53, 54, 55, 56, 57, 59, 60, 61, 62, 63, 64, 65, 67, 68, 69, 70, 72, 73, 74, 76, 77, 78, 79, 80, 81, 75 ) AND civicrm_group_contact.status = 'Added' )  OR  (  ( LOWER(civicrm_membership_type.name) IS NULL AND contact_a.contact_type IN ('Individual') AND civicrm_value_non_member_group_4.non_member_information_54 = 'tourism and related industry professional' )  )  OR  ( civicrm_membership.membership_type_id = 5 AND  civicrm_membership.owner_membership_id IS NULL AND civicrm_membership.is_test = 0 )  OR  (  ( LOWER(civicrm_membership_type.name) = 'organization' AND LOWER(civicrm_membership_status.name) = 'expired' AND `civicrm_entity_tag-39`.tag_id = (39) AND `civicrm_entity_tag-40`.tag_id = (40) AND contact_a.contact_type IN ('Organization') )  )  OR  (  ( LOWER(civicrm_membership_type.name) = 'organization' AND LOWER(civicrm_membership_status.name) = 'expired' AND `civicrm_entity_tag-39`.tag_id = (39) AND `civicrm_entity_tag-40`.tag_id = (40) AND `civicrm_entity_tag-54`.tag_id = (54) AND contact_a.contact_type IN ('Organization') )  )  OR  ( civicrm_membership.membership_type_id = 5 AND  civicrm_membership.owner_membership_id IS NOT NULL AND civicrm_membership.status_id IN ('1','2','3') AND civicrm_membership.is_test = 0 )  OR  ( civicrm_membership.membership_type_id = 4 AND civicrm_membership.status_id IN ('1','2','3') AND civicrm_membership.is_test = 0 )  OR  ( ( ( `civicrm_group_contact-43,44`.group_id IN ( 43,44 ) AND `civicrm_group_contact-43,44`.status IN ("Added") ) OR ( `civicrm_group_contact_cache_43`.group_id = 43 OR `civicrm_group_contact_cache_44`.group_id = 44 ) ) )  OR  (  ( LOWER(civicrm_membership_type.name) = 'organization' AND LOWER(civicrm_country.name) = 'argentina' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_membership_status.name) = 'new' AND LOWER(civicrm_membership_status.name) = 'current' AND LOWER(civicrm_membership_status.name) = 'grace' AND LOWER(civicrm_membership_status.name) = 'expired' )  OR  ( LOWER(civicrm_country.name) = 'bolivia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'brazil' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'chile' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'colombia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'ecuador' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'french guiana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'guyana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'paraguay' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'peru' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'suriname' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'uruguay' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'venezuela' AND contact_a.contact_type IN ('Organization') )  )  OR  (  ( LOWER(civicrm_country.name) = 'argentina' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'bolivia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'brazil' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'chile' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'colombia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'ecuador' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'french guiana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'guyana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'paraguay' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'peru' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'suriname' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'uruguay' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'venezuela' AND contact_a.contact_type IN ('Individual') )  )  OR  (  ( LOWER(civicrm_country.name) = 'argentina' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'bolivia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'brazil' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'chile' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'colombia' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'ecuador' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'french guiana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'guyana' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'paraguay' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'peru' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'suriname' AND contact_a.contact_type IN ('Organization') )  OR  ( LOWER(civicrm_country.name) = 'uruguay' AND contact_a.contact_type IN ('Organization') )  )  OR  ( civicrm_state_province.id IN (1004) AND civicrm_country.id = 1228 AND contact_a.contact_type IN ('Individual') )  OR  ( civicrm_event.id = 11 AND civicrm_participant.status_id = 1 AND civicrm_participant.is_test = 0 )  OR  ( `civicrm_entity_tag-91,92,93,94,95,96`.tag_id IN (91,92,93,94,95,96) )  OR  ( LOWER(civicrm_worldregion.name) = 'africa west, east, central and southern' AND ( ( `civicrm_group_contact-43,44`.group_id IN ( 43,44 ) AND `civicrm_group_contact-43,44`.status IN ("Added") ) OR ( `civicrm_group_contact_cache_43`.group_id = 43 OR `civicrm_group_contact_cache_44`.group_id = 44 ) ) )  OR  ( contact_a.contact_type IN ('Individual') AND `civicrm_entity_tag-79`.tag_id IN (79) )  OR  ( contact_a.contact_type IN ('Individual') )  OR  ( contact_a.contact_type IN ('Individual') )  OR  ( civicrm_membership.membership_type_id = 4 AND civicrm_membership.is_test = 0 )  OR  ( civicrm_membership.membership_type_id IN ('5','10','11') AND  civicrm_membership.owner_membership_id IS NOT NULL AND civicrm_membership.is_test = 0 )  OR  (  ( ( civicrm_value_non_member_group_4.non_member_information_54 like '%tourism and related industry professional%' )  )  )  OR  (  ( `civicrm_group_contact-37`.group_id = ( 37 ) AND `civicrm_group_contact-37`.status IN ("Added") AND contact_a.contact_type IN ('Individual') AND civicrm_value_non_member_group_4.non_member_information_54 != 'tourism and related industry professional' )  )  OR  (  ( LOWER(civicrm_country.name) = 'algeria' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'angola' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'benin' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'botswana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'burkina faso' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'burundi' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'cameroon' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'cape verde' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'central african republic' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'chad' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'comoros' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'congo, the democratic republic of' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'congo' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'djibouti' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'egypt' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'equatorial guinea' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'eritrea' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'ethiopia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'gabon' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'gambia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'ghana' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'guinea' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'guinea-bissau' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'côte d\'ivoire' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'kenya' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'lesotho' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'liberia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'libyan arab jamahiriya' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'madagascar' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'malawi' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mali' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mauritania' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mauritius' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'morocco' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'mozambique' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'namibia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'niger' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'nigeria' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'rwanda' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'sao tome and principe' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'senegal' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'seychelles' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'sierra leone' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'somalia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'south africa' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'south sudan' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'sudan' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'swaziland' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'tanzania, united republic of' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'togo' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'tunisia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'uganda' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'zambia' AND contact_a.contact_type IN ('Individual') )  OR  ( LOWER(civicrm_country.name) = 'zimbabwe' AND contact_a.contact_type IN ('Individual') )  )  OR  ( LOWER(civicrm_worldregion.name) = 'europe and central asia' AND contact_a.contact_type IN ('Individual') )  )   ORDER BY civicrm_group.title, civicrm_subscription_history.date ASC LIMIT 0, 3 [nativecode=126 ** Incorrect key file for table '/tmp/#sql_e1eb_1.MYI'; try to repair it]"]
)

Return to home page.

 

About TIES


As the world's oldest and largest international ecotourism association, TIES seeks to be the global source of knowledge and advocacy uniting communities/ conservation/ sustainable travel.

 

 

 

> The International Ecotourism Society 

 

ESTC


The Ecotourism and Sustainable Tourism Conference will highlight global challenges and local opportunities, supporting sustainable development of tourism and promoting solutions that balance conservation, communities and sustainable travel.

Connect to Us   


Become a Fan of TIES  Follow TIES on Twitter  Share Your Pictures with TIES  Share Your Videos with TIES

LinkedIn  Pinterest  Google Plus  Vimeo