mySQL query error: SELECT COUNT(*) as total FROM x_utf_invision_ccs_custom_database_1 r LEFT JOIN x_utf_invision_ccs_database_categories cat ON ( r.category_id=cat.category_id )
LEFT JOIN x_utf_invision_permission_index p ON ( p.app='ccs' AND p.perm_type='categories' AND p.perm_type_id=cat.category_id )
LEFT JOIN x_utf_invision_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('ccs',';','records-1',';',r.primary_id_field)) ) WHERE r.category_id IN(1,2,3,11,12,13,14,15,16,17,18,19,20,21,80) AND (cat.category_has_perms=0 OR p.perm_view REGEXP ',2,|\\*') AND r.record_approved=1 AND r.primary_id_field IN(1264)
This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above.