The website encountered an unexpected error. Please try again later. Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_field_data_nid' in 'where clause': SELECT COUNT(*) AS expression
FROM
(SELECT users_field_data_media_field_data.name AS users_field_data_media_field_data_name, profile_users_field_data__profile__field_profile_first_name.field_profile_first_name_value AS profile_users_field_data__profile__field_profile_first_name_, profile_users_field_data__profile__field_profile_last_name.field_profile_last_name_value AS profile_users_field_data__profile__field_profile_last_name_f, media_field_data.mid AS media_field_data_mid, media_field_data.mid AS mid, MIN(media_field_data.mid) AS mid_1, MIN(group_content_field_data_media_field_data.id) AS group_content_field_data_media_field_data_id, MIN(groups_field_data_group_content_field_data.id) AS groups_field_data_group_content_field_data_id, MIN(users_field_data_media_field_data.uid) AS users_field_data_media_field_data_uid, MIN(profile_users_field_data.profile_id) AS profile_users_field_data_profile_id, 1 AS expression
FROM
{media_field_data} media_field_data
LEFT JOIN {group_content_field_data} group_content_field_data_media_field_data ON media_field_data.mid = group_content_field_data_media_field_data.entity_id AND group_content_field_data_media_field_data.type IN ( :views_join_condition_0__0, :views_join_condition_0__1, :views_join_condition_0__2 )
LEFT JOIN {groups_field_data} groups_field_data_group_content_field_data ON group_content_field_data_media_field_data.gid = groups_field_data_group_content_field_data.id
LEFT JOIN {users_field_data} users_field_data_media_field_data ON media_field_data.uid = users_field_data_media_field_data.uid
LEFT JOIN {profile} profile_users_field_data ON users_field_data_media_field_data.uid = profile_users_field_data.uid
LEFT JOIN {media__field_related_article} media__field_related_article ON media_field_data.mid = media__field_related_article.entity_id AND media__field_related_article.deleted = :views_join_condition_1 AND (media__field_related_article.langcode = media_field_data.langcode OR media__field_related_article.bundle = :views_join_condition_3)
LEFT JOIN {media__field_related_event} media__field_related_event ON media_field_data.mid = media__field_related_event.entity_id AND media__field_related_event.deleted = :views_join_condition_4 AND (media__field_related_event.langcode = media_field_data.langcode OR media__field_related_event.bundle = :views_join_condition_6)
LEFT JOIN {media__field_related_individual} media__field_related_individual ON media_field_data.mid = media__field_related_individual.entity_id AND media__field_related_individual.deleted = :views_join_condition_7 AND (media__field_related_individual.langcode = media_field_data.langcode OR media__field_related_individual.bundle = :views_join_condition_9)
LEFT JOIN {media__field_related_place} media__field_related_place ON media_field_data.mid = media__field_related_place.entity_id AND media__field_related_place.deleted = :views_join_condition_10 AND (media__field_related_place.langcode = media_field_data.langcode OR media__field_related_place.bundle = :views_join_condition_12)
LEFT JOIN {media__field_related_topic} media__field_related_topic ON media_field_data.mid = media__field_related_topic.entity_id AND media__field_related_topic.deleted = :views_join_condition_13
LEFT JOIN {group_content_field_data} membership ON media_field_data.mid = membership.entity_id
LEFT JOIN {media__field_media_visibility} field_visibility_relationship ON media_field_data.mid = field_visibility_relationship.entity_id
LEFT JOIN {profile__field_profile_first_name} profile_users_field_data__profile__field_profile_first_name ON profile_users_field_data.profile_id = profile_users_field_data__profile__field_profile_first_name.entity_id AND profile_users_field_data__profile__field_profile_first_name.deleted = :views_join_condition_14
LEFT JOIN {profile__field_profile_last_name} profile_users_field_data__profile__field_profile_last_name ON profile_users_field_data.profile_id = profile_users_field_data__profile__field_profile_last_name.entity_id AND profile_users_field_data__profile__field_profile_last_name.deleted = :views_join_condition_15
WHERE (field_visibility_relationship.field_media_visibility_value = :db_condition_placeholder_1) AND ((media_field_data.status = :db_condition_placeholder_2) AND (media_field_data.bundle IN (:db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5)) AND (media__field_related_event.field_related_event_target_id = :db_condition_placeholder_6))
GROUP BY media_field_data.mid, users_field_data_media_field_data_name, profile_users_field_data__profile__field_profile_first_name_, profile_users_field_data__profile__field_profile_last_name_f, media_field_data_mid) subquery
WHERE node_field_data_nid >= :db_condition_placeholder_0; Array
(
[:db_condition_placeholder_0] => 1274
[:db_condition_placeholder_1] => public
[:db_condition_placeholder_2] => 1
[:db_condition_placeholder_3] => google_photo
[:db_condition_placeholder_4] => image
[:db_condition_placeholder_5] => remote_video
[:db_condition_placeholder_6] => 1274
[:views_join_condition_1] => 0
[:views_join_condition_3] => image
[:views_join_condition_4] => 0
[:views_join_condition_6] => image
[:views_join_condition_7] => 0
[:views_join_condition_9] => image
[:views_join_condition_10] => 0
[:views_join_condition_12] => image
[:views_join_condition_13] => 0
[:views_join_condition_14] => 0
[:views_join_condition_15] => 0
[:views_join_condition_0__0] => group_content_type_49d4b00aa6a3b
[:views_join_condition_0__1] => flexible_group-group_media-image
[:views_join_condition_0__2] => group_content_type_282272852c41d
)
in Drupal\great_custom\CollectionNavigation\EntityCollectionNavigationLazyBuilder::lazyBuilder() (line 122 of modules/custom/great_custom/src/CollectionNavigation/EntityCollectionNavigationLazyBuilder.php).
