SELECT `Biobank`.`id`, `Biobank`.`user_id`, `Biobank`.`country_id`, `Biobank`.`institution_id`, `Biobank`.`biobank_code`, `Biobank`.`name`, `Biobank`.`acronym`, `Biobank`.`website`, `Biobank`.`email`, `Biobank`.`address_street`, `Biobank`.`address_city`, `Biobank`.`address_province`, `Biobank`.`address_code`, `Biobank`.`health_authorities`, `Biobank`.`university`, `Biobank`.`research_institute`, `Biobank`.`investigator`, `Biobank`.`investigator_cv_filename`, `Biobank`.`leaders_1_name`, `Biobank`.`leaders_1_position`, `Biobank`.`leaders_1_email`, `Biobank`.`leaders_2_name`, `Biobank`.`leaders_2_position`, `Biobank`.`leaders_2_email`, `Biobank`.`objective`, `Biobank`.`keywords`, `Biobank`.`staff_full_time`, `Biobank`.`staff_part_time`, `Biobank`.`network`, `Biobank`.`network_name`, `Biobank`.`network_url`, `Biobank`.`user_type`, `Biobank`.`user_types_within_inst`, `Biobank`.`user_types_within_ca`, `Biobank`.`user_types_outside_ca`, `Biobank`.`user_types_industry`, `Biobank`.`consent_preprocedure`, `Biobank`.`consent_postprocedure`, `Biobank`.`consent_waiver`, `Biobank`.`retrospective_collection`, `Biobank`.`consent_description`, `Biobank`.`eligibility_criteria`, `Biobank`.`research_focus_musculoskeletal_health_and_arthritis`, `Biobank`.`research_focus_aging`, `Biobank`.`research_focus_cancer`, `Biobank`.`research_focus_respiratory_health`, `Biobank`.`research_focus_gender_and_health`, `Biobank`.`research_focus_genetics`, `Biobank`.`research_focus_health_services_and_policy`, `Biobank`.`research_focus_human_development`, `Biobank`.`research_focus_infection_and_immunity`, `Biobank`.`research_focus_indigenous`, `Biobank`.`research_focus_neurosciences`, `Biobank`.`research_focus_nutrition`, `Biobank`.`research_focus_population`, `Biobank`.`research_focus_other`, `Biobank`.`accrual_target`, `Biobank`.`accrual_total`, `Biobank`.`accrual_12mo`, `Biobank`.`declined_12mo`, `Biobank`.`collected_directly`, `Biobank`.`collected_separately`, `Biobank`.`collected_separately_explain`, `Biobank`.`collected_outside_ca`, `Biobank`.`collected_outside_ca_explain`, `Biobank`.`biospecimen_types_formalin`, `Biobank`.`biospecimen_types_frozen`, `Biobank`.`biospecimen_types_fresh`, `Biobank`.`biospecimen_types_blood`, `Biobank`.`biospecimen_types_urine`, `Biobank`.`biospecimen_types_saliva`, `Biobank`.`biospecimen_types_other`, `Biobank`.`biospecimen_other`, `Biobank`.`identifiable_data_collected`, `Biobank`.`data_from_participants_single`, `Biobank`.`data_from_participants_long`, `Biobank`.`data_from_participants_other`, `Biobank`.`data_from_records_single`, `Biobank`.`data_from_records_long`, `Biobank`.`data_from_records_other`, `Biobank`.`data_from_other_single`, `Biobank`.`data_from_other_long`, `Biobank`.`data_from_other_other`, `Biobank`.`data_from_other_explain`, `Biobank`.`data_non_anonymous`, `Biobank`.`identifiable_data_transmitted`, `Biobank`.`identifiable_data_transmitted_explain`, `Biobank`.`hosting_institution`, `Biobank`.`funding_resource_academic_grant`, `Biobank`.`funding_resource_nonacademic_grant`, `Biobank`.`funding_resource_nonacademic_contract`, `Biobank`.`funding_resource_institution`, `Biobank`.`funding_resource_public_donations`, `Biobank`.`funding_resource_user_fees`, `Biobank`.`funding_resource_other`, `Biobank`.`funding_other`, `Biobank`.`oversight_bodies`, `Biobank`.`require_return_biospecimens`, `Biobank`.`require_return_raw_research_data`, `Biobank`.`require_return_summary_research_data`, `Biobank`.`require_return_publication_notification`, `Biobank`.`comments`, `Biobank`.`signature`, `Biobank`.`deny_stats_consent`, `Biobank`.`deny_online_registry`, `Biobank`.`last_completed`, `Biobank`.`reg_certificate_filename`, `Biobank`.`registration_status`, `Biobank`.`registration_page`, `Biobank`.`document_type`, `Biobank`.`document_title`, `Biobank`.`document_path`, `Biobank`.`leadership_type`, `Biobank`.`participant_eligibility_criteria`, `Biobank`.`started_certification`, `Biobank`.`confirmed_registration_information`, `Biobank`.`authorized_for_anonymized_statistics`, `Biobank`.`permission_to_list_in_locator`, `Biobank`.`certification_status`, `Biobank`.`certification_category`, `Biobank`.`canadian_cancer_biobank`, `Biobank`.`eligibility_healthy`, `Biobank`.`eligibility_cancer`, `Biobank`.`eligibility_disease`, `Biobank`.`eligibility_pediatric`, `Biobank`.`eligibility_nextofkin`, `Biobank`.`eligibility_injury`, `Biobank`.`eligibility_other`, `Biobank`.`participate_cert_progr`, `Biobank`.`declaration_signature`, `Biobank`.`start_review_date`, `Biobank`.`notified_recertification_date`, `Biobank`.`completed_registration`, `Biobank`.`completed_certification`, `Biobank`.`expiration_certification`, `Biobank`.`created`, `Biobank`.`modified`, `Biobank`.`certification_page`, `Biobank`.`expired`, `Biobank`.`biobank_cloned_id`, `Biobank`.`cohort_highlights`, `Biobank`.`services_to_external_parties`, `Biobank`.`consenting_services`, `Biobank`.`biospecimen_collection_services`, `Biobank`.`biospecimen_collections_type`, `Biobank`.`biospecimen_disease_states`, `Biobank`.`organ_tissues_sites`, `Biobank`.`tissue_format`, `Biobank`.`timepoints_able_to_collect_biospecimens_relative`, `Biobank`.`biospecimen_processing_services`, `Biobank`.`biospecimen_processing_type`, `Biobank`.`training_services`, `Biobank`.`training_services_type`, `Biobank`.`storage_services`, `Biobank`.`storage_services_type`, `Biobank`.`data_services`, `Biobank`.`data_services_type`, `Biobank`.`additional_services`, `User`.`id`, `User`.`country_id`, `User`.`institution_id`, `User`.`project`, `User`.`username`, `User`.`password`, `User`.`resetkey`, `User`.`passwd`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`role`, `User`.`last_visit`, `User`.`account_type`, `User`.`education_access_module_one`, `User`.`education_access_specialty_modules`, `User`.`biobank_registration_access`, `User`.`biobank_certification_access`, `User`.`tools_access`, `User`.`templates_access`, `User`.`account_expired`, `User`.`license_key`, `User`.`active`, `User`.`comments`, `User`.`created`, `User`.`modified`, `User`.`ber_code`, `User`.`custom_institution`, `User`.`pi_name`, `User`.`pi_email`, `User`.`province`, `User`.`address_street`, `User`.`address_city`, `User`.`address_province`, `User`.`address_code`, `User`.`years_in_position`, `User`.`profession`, `User`.`give_permission`, `User`.`prs_step_certificate`, `User`.`education_access_module_ten`, `User`.`declaration_signature`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name`, `Country`.`id`, `Country`.`country_code`, `Country`.`country_name`, `Country`.`continent_name`, `Institution`.`id`, `Institution`.`code`, `Institution`.`name`, `Institution`.`city`, `Institution`.`province_state`, `Institution`.`country`, `BiobankDocumentChecklist`.`id`, `BiobankDocumentChecklist`.`biobank_id`, `BiobankDocumentChecklist`.`study`, `BiobankDocumentChecklist`.`confidentiality_agreement`, `BiobankDocumentChecklist`.`informed_consent_form`, `BiobankDocumentChecklist`.`consent_procedure_sop`, `BiobankDocumentChecklist`.`sop_related_consent_withdrawal`, `BiobankDocumentChecklist`.`biobank_formal_business_plan`, `BiobankDocumentChecklist`.`material_transfer_agreement`, `BiobankDocumentChecklist`.`material_access`, `BiobankDocumentChecklist`.`access_fee_schedule`, `BiobankDocumentChecklist`.`shipping_receiving_sop`, `BiobankDocumentChecklist`.`complete_list_sop`, `BiobankDocumentChecklist`.`quality_control_biospecimen`, `BiobankDocumentChecklist`.`education_training`, `BiobankDocumentChecklist`.`documentation_staff_training`, `BiobankDocumentChecklist`.`data_storage`, `BiobankDocumentChecklist`.`policy_data_security`, `BiobankDocumentChecklist`.`storage`, `BiobankDocumentChecklist`.`description_security_access_control`, `BiobankDocumentChecklist`.`emergency_procedure`, `BiobankDocumentChecklist`.`created`, `BiobankDocumentChecklist`.`modified`, `BiobankAuditChecklist`.`id`, `BiobankAuditChecklist`.`biobank_id`, `BiobankAuditChecklist`.`correct_language`, `BiobankAuditChecklist`.`name_consistent`, `BiobankAuditChecklist`.`current_date`, `BiobankAuditChecklist`.`project_approved`, `BiobankAuditChecklist`.`pi_name_consistent`, `BiobankAuditChecklist`.`affiliations_consistent`, `BiobankAuditChecklist`.`governance_template`, `BiobankAuditChecklist`.`external_oversight_mentioned`, `BiobankAuditChecklist`.`pi_mentioned_in_chart`, `BiobankAuditChecklist`.`sop_documented`, `BiobankAuditChecklist`.`responsibilities_mentioned`, `BiobankAuditChecklist`.`steps_handle_biospecimens`, `BiobankAuditChecklist`.`safety_measures`, `BiobankAuditChecklist`.`laboratory_equipment`, `BiobankAuditChecklist`.`collection_of_biospecimens`, `BiobankAuditChecklist`.`processing_of_biospecimens`, `BiobankAuditChecklist`.`labelling_of_biospecimens`, `BiobankAuditChecklist`.`storage_conditions`, `BiobankAuditChecklist`.`inventory_system`, `BiobankAuditChecklist`.`link_sop`, `BiobankAuditChecklist`.`auditor_note`, `BiobankAuditChecklist`.`created`, `BiobankAuditChecklist`.`modified`, `Services`.`id`, `Services`.`biobank_id`, `Services`.`services_to_external_parties`, `Services`.`consenting_services`, `Services`.`biospecimen_collection_services`, `Services`.`biospecimen_collections_type_blood`, `Services`.`biospecimen_collections_type_solid_tumour`, `Services`.`biospecimen_collections_type_ascites`, `Services`.`biospecimen_collections_type_urine`, `Services`.`biospecimen_collections_type_saliva`, `Services`.`biospecimen_collections_type_swabs`, `Services`.`biospecimen_collections_type_csf`, `Services`.`biospecimen_collections_type_hair`, `Services`.`biospecimen_collections_type_nails`, `Services`.`biospecimen_collections_type_fecalsamples`, `Services`.`biospecimen_collections_type_teeth`, `Services`.`biospecimen_collections_type_other`, `Services`.`biospecimen_collections_text_other`, `Services`.`biospecimen_tissue_format_type_fresh`, `Services`.`biospecimen_tissue_format_type_preserved_frozen`, `Services`.`biospecimen_tissue_format_type_formalin_fixed`, `Services`.`biospecimen_tissue_format_type_formalin_fixed_paraffin_embedded`, `Services`.`biospecimen_tissue_format_other`, `Services`.`biospecimen_tissue_format_other_text`, `Services`.`biospecimen_timepoints_type_preoperative`, `Services`.`biospecimen_timepoints_type_perioperative`, `Services`.`biospecimen_timepoints_type_postoperative`, `Services`.`biospecimen_timepoints_type_serial`, `Services`.`biospecimen_timepoints_other`, `Services`.`biospecimen_timepoints_text_other`, `Services`.`biospecimen_processing_services`, `Services`.`biospecimen_processing_services_slide_assembly`, `Services`.`biospecimen_processing_services_slide_staining`, `Services`.`biospecimen_processing_services_tma_construction`, `Services`.`biospecimen_processing_services_dna_extraction`, `Services`.`biospecimen_processing_services_rna_extraction`, `Services`.`biospecimen_processing_services_protein_extraction`, `Services`.`biospecimen_processing_services_blood_fractionation`, `Services`.`biospecimen_processing_services_cell_preservation`, `Services`.`biospecimen_processing_services_organoid_preservation`, `Services`.`biospecimen_processing_services_xenograft_generation`, `Services`.`biospecimen_processing_services_other`, `Services`.`biospecimen_processing_services_text_other`, `Services`.`training_services`, `Services`.`biospecimen_training_services_consenting_skills`, `Services`.`biospecimen_training_services_laboratory_skills`, `Services`.`biospecimen_training_services_other`, `Services`.`biospecimen_training_services_text_other`, `Services`.`storage_services`, `Services`.`biospecimen_storage_services_ffpe_materials`, `Services`.`biospecimen_storage_services_frozen_materials`, `Services`.`biospecimen_storage_services_laboratory_skills`, `Services`.`biospecimen_storage_services_other`, `Services`.`biospecimen_storage_services_text_other`, `Services`.`data_services`, `Services`.`biospecimen_data_collection`, `Services`.`biospecimen_inventory_management`, `Services`.`biospecimen_data_services_other`, `Services`.`biospecimen_data_services_text_other`, `Services`.`additional_services`, `Services`.`created`, `Services`.`modified` FROM `brc`.`biobanks` AS `Biobank` LEFT JOIN `brc`.`users` AS `User` ON (`Biobank`.`user_id` = `User`.`id`) LEFT JOIN `brc`.`countries` AS `Country` ON (`Biobank`.`country_id` = `Country`.`id`) LEFT JOIN `brc`.`institutions` AS `Institution` ON (`Biobank`.`institution_id` = `Institution`.`id`) LEFT JOIN `brc`.`biobank_document_checklists` AS `BiobankDocumentChecklist` ON (`BiobankDocumentChecklist`.`biobank_id` = `Biobank`.`id`) LEFT JOIN `brc`.`biobank_audit_checklists` AS `BiobankAuditChecklist` ON (`BiobankAuditChecklist`.`biobank_id` = `Biobank`.`id`) LEFT JOIN `brc`.`services` AS `Services` ON (`Services`.`biobank_id` = `Biobank`.`id`) WHERE `Biobank`.`id` = 237 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Services`.`id`, `Services`.`biobank_id`, `Services`.`services_to_external_parties`, `Services`.`consenting_services`, `Services`.`biospecimen_collection_services`, `Services`.`biospecimen_collections_type_blood`, `Services`.`biospecimen_collections_type_solid_tumour`, `Services`.`biospecimen_collections_type_ascites`, `Services`.`biospecimen_collections_type_urine`, `Services`.`biospecimen_collections_type_saliva`, `Services`.`biospecimen_collections_type_swabs`, `Services`.`biospecimen_collections_type_csf`, `Services`.`biospecimen_collections_type_hair`, `Services`.`biospecimen_collections_type_nails`, `Services`.`biospecimen_collections_type_fecalsamples`, `Services`.`biospecimen_collections_type_teeth`, `Services`.`biospecimen_collections_type_other`, `Services`.`biospecimen_collections_text_other`, `Services`.`biospecimen_tissue_format_type_fresh`, `Services`.`biospecimen_tissue_format_type_preserved_frozen`, `Services`.`biospecimen_tissue_format_type_formalin_fixed`, `Services`.`biospecimen_tissue_format_type_formalin_fixed_paraffin_embedded`, `Services`.`biospecimen_tissue_format_other`, `Services`.`biospecimen_tissue_format_other_text`, `Services`.`biospecimen_timepoints_type_preoperative`, `Services`.`biospecimen_timepoints_type_perioperative`, `Services`.`biospecimen_timepoints_type_postoperative`, `Services`.`biospecimen_timepoints_type_serial`, `Services`.`biospecimen_timepoints_other`, `Services`.`biospecimen_timepoints_text_other`, `Services`.`biospecimen_processing_services`, `Services`.`biospecimen_processing_services_slide_assembly`, `Services`.`biospecimen_processing_services_slide_staining`, `Services`.`biospecimen_processing_services_tma_construction`, `Services`.`biospecimen_processing_services_dna_extraction`, `Services`.`biospecimen_processing_services_rna_extraction`, `Services`.`biospecimen_processing_services_protein_extraction`, `Services`.`biospecimen_processing_services_blood_fractionation`, `Services`.`biospecimen_processing_services_cell_preservation`, `Services`.`biospecimen_processing_services_organoid_preservation`, `Services`.`biospecimen_processing_services_xenograft_generation`, `Services`.`biospecimen_processing_services_other`, `Services`.`biospecimen_processing_services_text_other`, `Services`.`training_services`, `Services`.`biospecimen_training_services_consenting_skills`, `Services`.`biospecimen_training_services_laboratory_skills`, `Services`.`biospecimen_training_services_other`, `Services`.`biospecimen_training_services_text_other`, `Services`.`storage_services`, `Services`.`biospecimen_storage_services_ffpe_materials`, `Services`.`biospecimen_storage_services_frozen_materials`, `Services`.`biospecimen_storage_services_laboratory_skills`, `Services`.`biospecimen_storage_services_other`, `Services`.`biospecimen_storage_services_text_other`, `Services`.`data_services`, `Services`.`biospecimen_data_collection`, `Services`.`biospecimen_inventory_management`, `Services`.`biospecimen_data_services_other`, `Services`.`biospecimen_data_services_text_other`, `Services`.`additional_services`, `Services`.`created`, `Services`.`modified`, `Biobank`.`id`, `Biobank`.`user_id`, `Biobank`.`country_id`, `Biobank`.`institution_id`, `Biobank`.`biobank_code`, `Biobank`.`name`, `Biobank`.`acronym`, `Biobank`.`website`, `Biobank`.`email`, `Biobank`.`address_street`, `Biobank`.`address_city`, `Biobank`.`address_province`, `Biobank`.`address_code`, `Biobank`.`health_authorities`, `Biobank`.`university`, `Biobank`.`research_institute`, `Biobank`.`investigator`, `Biobank`.`investigator_cv_filename`, `Biobank`.`leaders_1_name`, `Biobank`.`leaders_1_position`, `Biobank`.`leaders_1_email`, `Biobank`.`leaders_2_name`, `Biobank`.`leaders_2_position`, `Biobank`.`leaders_2_email`, `Biobank`.`objective`, `Biobank`.`keywords`, `Biobank`.`staff_full_time`, `Biobank`.`staff_part_time`, `Biobank`.`network`, `Biobank`.`network_name`, `Biobank`.`network_url`, `Biobank`.`user_type`, `Biobank`.`user_types_within_inst`, `Biobank`.`user_types_within_ca`, `Biobank`.`user_types_outside_ca`, `Biobank`.`user_types_industry`, `Biobank`.`consent_preprocedure`, `Biobank`.`consent_postprocedure`, `Biobank`.`consent_waiver`, `Biobank`.`retrospective_collection`, `Biobank`.`consent_description`, `Biobank`.`eligibility_criteria`, `Biobank`.`research_focus_musculoskeletal_health_and_arthritis`, `Biobank`.`research_focus_aging`, `Biobank`.`research_focus_cancer`, `Biobank`.`research_focus_respiratory_health`, `Biobank`.`research_focus_gender_and_health`, `Biobank`.`research_focus_genetics`, `Biobank`.`research_focus_health_services_and_policy`, `Biobank`.`research_focus_human_development`, `Biobank`.`research_focus_infection_and_immunity`, `Biobank`.`research_focus_indigenous`, `Biobank`.`research_focus_neurosciences`, `Biobank`.`research_focus_nutrition`, `Biobank`.`research_focus_population`, `Biobank`.`research_focus_other`, `Biobank`.`accrual_target`, `Biobank`.`accrual_total`, `Biobank`.`accrual_12mo`, `Biobank`.`declined_12mo`, `Biobank`.`collected_directly`, `Biobank`.`collected_separately`, `Biobank`.`collected_separately_explain`, `Biobank`.`collected_outside_ca`, `Biobank`.`collected_outside_ca_explain`, `Biobank`.`biospecimen_types_formalin`, `Biobank`.`biospecimen_types_frozen`, `Biobank`.`biospecimen_types_fresh`, `Biobank`.`biospecimen_types_blood`, `Biobank`.`biospecimen_types_urine`, `Biobank`.`biospecimen_types_saliva`, `Biobank`.`biospecimen_types_other`, `Biobank`.`biospecimen_other`, `Biobank`.`identifiable_data_collected`, `Biobank`.`data_from_participants_single`, `Biobank`.`data_from_participants_long`, `Biobank`.`data_from_participants_other`, `Biobank`.`data_from_records_single`, `Biobank`.`data_from_records_long`, `Biobank`.`data_from_records_other`, `Biobank`.`data_from_other_single`, `Biobank`.`data_from_other_long`, `Biobank`.`data_from_other_other`, `Biobank`.`data_from_other_explain`, `Biobank`.`data_non_anonymous`, `Biobank`.`identifiable_data_transmitted`, `Biobank`.`identifiable_data_transmitted_explain`, `Biobank`.`hosting_institution`, `Biobank`.`funding_resource_academic_grant`, `Biobank`.`funding_resource_nonacademic_grant`, `Biobank`.`funding_resource_nonacademic_contract`, `Biobank`.`funding_resource_institution`, `Biobank`.`funding_resource_public_donations`, `Biobank`.`funding_resource_user_fees`, `Biobank`.`funding_resource_other`, `Biobank`.`funding_other`, `Biobank`.`oversight_bodies`, `Biobank`.`require_return_biospecimens`, `Biobank`.`require_return_raw_research_data`, `Biobank`.`require_return_summary_research_data`, `Biobank`.`require_return_publication_notification`, `Biobank`.`comments`, `Biobank`.`signature`, `Biobank`.`deny_stats_consent`, `Biobank`.`deny_online_registry`, `Biobank`.`last_completed`, `Biobank`.`reg_certificate_filename`, `Biobank`.`registration_status`, `Biobank`.`registration_page`, `Biobank`.`document_type`, `Biobank`.`document_title`, `Biobank`.`document_path`, `Biobank`.`leadership_type`, `Biobank`.`participant_eligibility_criteria`, `Biobank`.`started_certification`, `Biobank`.`confirmed_registration_information`, `Biobank`.`authorized_for_anonymized_statistics`, `Biobank`.`permission_to_list_in_locator`, `Biobank`.`certification_status`, `Biobank`.`certification_category`, `Biobank`.`canadian_cancer_biobank`, `Biobank`.`eligibility_healthy`, `Biobank`.`eligibility_cancer`, `Biobank`.`eligibility_disease`, `Biobank`.`eligibility_pediatric`, `Biobank`.`eligibility_nextofkin`, `Biobank`.`eligibility_injury`, `Biobank`.`eligibility_other`, `Biobank`.`participate_cert_progr`, `Biobank`.`declaration_signature`, `Biobank`.`start_review_date`, `Biobank`.`notified_recertification_date`, `Biobank`.`completed_registration`, `Biobank`.`completed_certification`, `Biobank`.`expiration_certification`, `Biobank`.`created`, `Biobank`.`modified`, `Biobank`.`certification_page`, `Biobank`.`expired`, `Biobank`.`biobank_cloned_id`, `Biobank`.`cohort_highlights`, `Biobank`.`services_to_external_parties`, `Biobank`.`consenting_services`, `Biobank`.`biospecimen_collection_services`, `Biobank`.`biospecimen_collections_type`, `Biobank`.`biospecimen_disease_states`, `Biobank`.`organ_tissues_sites`, `Biobank`.`tissue_format`, `Biobank`.`timepoints_able_to_collect_biospecimens_relative`, `Biobank`.`biospecimen_processing_services`, `Biobank`.`biospecimen_processing_type`, `Biobank`.`training_services`, `Biobank`.`training_services_type`, `Biobank`.`storage_services`, `Biobank`.`storage_services_type`, `Biobank`.`data_services`, `Biobank`.`data_services_type`, `Biobank`.`additional_services` FROM `brc`.`services` AS `Services` LEFT JOIN `brc`.`biobanks` AS `Biobank` ON (`Services`.`biobank_id` = `Biobank`.`id`) WHERE `Services`.`biobank_id` = 237 | 0 | 0 | 0 | |