general_errors.There was an SQL error: ERROR: column "user_id" does not exist LINE 17: AND o.created_by_id=#user_id# ^ - SELECT COUNT(o.*) FROM cache_occurrences_functional o JOIN cache_occurrences_nonfunctional onf on onf.id=o.id JOIN cache_samples_nonfunctional snf on snf.id=o.sample_id JOIN cache_taxa_taxon_lists cttl on cttl.id=o.taxa_taxon_list_id JOIN websites w on w.id=o.website_id and w.deleted=false LEFT JOIN index_websites_website_agreements canEdit on canEdit.from_website_id=o.website_id and canEdit.to_website_id in (76) and canEdit.provide_for_editing=true JOIN users privacyusers ON privacyusers.id=o.created_by_id WHERE o.training=false AND (o.website_id in (76) OR privacyusers.id=1 OR privacyusers.allow_share_for_reporting=true OR privacyusers.allow_share_for_reporting IS NULL) AND o.website_id in (76) AND o.release_status='R' AND o.confidential='f' AND o.created_by_id=#user_id# AND snf.website_title || ' | ' || case when substring(snf.survey_title from 1 for length(snf.website_title)) = snf.website_title then trim(substring(snf.survey_title from length(snf.website_title)+1)) else snf.survey_title end ILIKE 'SERC Species | ROAM%'
general_errors.There was an SQL error: ERROR: column "user_id" does not exist LINE 13: AND o.created_by_id=#user_id# ^ - SELECT COUNT(DISTINCT o.taxon_meaning_id) FROM cache_occurrences_functional o JOIN cache_taxa_taxon_lists cttl on cttl.id=o.preferred_taxa_taxon_list_id JOIN users privacyusers ON privacyusers.id=o.created_by_id WHERE o.training=false AND (o.website_id in (76) OR privacyusers.id=1 OR privacyusers.allow_share_for_reporting=true OR privacyusers.allow_share_for_reporting IS NULL) AND o.website_id in (76) AND o.zero_abundance=false AND o.release_status='R' AND o.confidential='f' AND o.created_by_id=#user_id#