Видимо из за этого у пользователей не выводиться таблица (не формируется вьюс) у админа и у гостей все окей.

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay query: SELECT DISTINCT node.nid AS nid, node_data_field_year_concerts.field_year_concerts_value AS node_data_field_year_concerts_field_year_concerts_value, node.language AS node_language, node.type AS node_type, node.vid AS node_vid, node_data_field_month_concerts.field_month_concerts_value AS node_data_field_month_concerts_field_month_concerts_value, node_data_field_day_concerts.field_day_concerts_value AS node_data_field_day_concerts_field_day_concerts_value, node_data_field_city_concerts.field_city_concerts_value AS node_data_field_city_concerts_field_city_concerts_value, node_data_field_city_concerts.field_concertvenue_value AS node_data_field_city_concerts_field_concertvenue_value, node_data_field_city_concerts.field_photos_concerts_url AS node_data_field_city_concerts_field_photos_concerts_url, node_data_field_city_concerts.field_photos_concerts_title AS node_data_field_city_concerts_field_photos_concerts_title, node_data_field_city_concerts.field_photos_concerts_attributes AS node_data_field_city_concerts_field_photos_concerts_attributes, node_data_field_artist_concerts.field_artist_concerts_value AS node_data_field_artist_concerts_field_artist_concerts_value, node_data_field_city_concerts.field_type_concerts_value AS node_data_field_city_concerts_field_type_concerts_value, node_data_field_city_concerts.field_note_concerts_value AS node_data_field_city_concerts_field_note_concerts_value, flag_content.content_id AS flag_content_content_id, flag_content2.content_id AS flag_content2_content_id FROM node node LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND (flag_content_node.fid = 2 AND flag_content_node.uid = 7) LEFT JOIN flag_content flag_content_node_1 ON node.nid = flag_content_node_1.content_id AND (flag_content_node_1.fid = 3 AND flag_content_node_1.uid = 7) INNER JOIN content_type_concert node_data_field_condition_concert_value_0 ON node.vid = node_data_field_condition_concert_value_0.vid AND node_data_field_condition_concert_value_0.field_condition_concert_value = 'Запланирован' LEFT JOIN content_field_year_concerts node_data_field_year_concerts ON node.vid = node_data_field_year_concerts.vid LEFT JOIN content_field_month_concerts node_data_field_month_concerts ON node.vid = node_data_field_month_concerts.vid LEFT JOIN content_field_day_concerts node_data_field_day_concerts ON node.vid = node_data_field_day_concerts.vid LEFT JOIN content_type_concert node_data_field_city_concerts ON node.vid = node_data_field_city_concerts.vid LEFT JOIN content_field_artist_concerts node_data_field_artist_concerts ON node.vid = node_data_field_artist_concerts.vid LEFT JOIN flag_content flag_content ON node.nid = flag_content.content_id AND (flag_content.fid = 3 AND flag_content.uid = 7) LEFT JOIN flag_content flag_content2 ON node.nid = flag_content2.content_id AND (flag_content2.fid = 2 AND flag_content2.uid = 7) INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 7 AND na.realm = 'content_access_author') OR (na.gid = 2 AND na.realm = 'content_access_rid') OR (na.gid = 2 AND na.realm = 'nodeaccess_rid') OR (na.gid = 7 AND na.realm = 'nodeaccess_uid') OR (na.gid = 7 AND na.realm = 'nodeaccess_author') OR (na.gid = 7 AND na.realm = 'nodeaccess_nodereference') OR (na.gid = 7 AND na.realm = 'nodeaccess_userreference') OR (na.gid = 7 AND na.realm = 'userref_access_author') OR (na.gid = 5 AND na.realm = 'user_relationship_node_access_1') OR (na.gid = 7 AND na.realm = 'user_relationship_node_access_author') OR (na.gid = 2 AND na.realm = 'workflow_access') OR (na.gid = 7 AND na.realm = 'workflow_access_owner'))) AND ( (node.type in ('concert')) AND (node_data_field_condition_concert_value_0.field_condition_concert_value = 'Запланирован') )ORDER BY node_data_field_year_concerts_field_year_concerts_value DESC, node_data_field_month_concerts_field_month_concerts_value DESC, node_data_field_day_concerts_field_day_concerts_value DESC LIMIT 0, 10 в файле /home/a/warru/public_html/sites/all/modules/views/includes/view.inc в строке 765.