|
||
Specimen search criteria |
||
|
options: path_info_key: PATH_INFO path_info_array: SERVER http_port: null https_port: null default_format: null trust_proxy: true logging: '1' relative_url_root: null formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml } no_script_name: false parameterHolder: action: search module: search attributeHolder: sf_route: 'sfRoute Object()'
status: code: 200 text: OK options: http_protocol: HTTP/1.0 logging: '1' charset: utf-8 send_http_headers: false content_type: 'text/html; charset=utf-8' cookies: { } httpHeaders: Content-Type: 'text/html; charset=utf-8' javascripts: jquery-1.7.1.min.js: { } jquery.ui.all.min.js: { } core.js: { } stylesheets: reset.css: { } menu_pub.css: { } content.css: { } metas: title: 'Darwin 2' httpMetas: Content-Type: 'text/html; charset=utf-8'
options: auto_shutdown: false culture: null default_culture: en use_flash: true logging: '1' timeout: 14400 attributeHolder: { } culture: en authenticated: false credentials: { } lastRequest: 1714817904
app_ldap_attr_displayname: displayName app_ldap_attr_id: samaccountname app_ldap_attr_mail: mail app_ldap_baseuser: 'cn=Users, dc=rbins, dc=be' app_ldap_host: dc2012.rbins.be app_ldap_ldap_enabled: true app_ldap_pass: adReader2! app_ldap_port: 389 app_ldap_user: adreader2 app_ldap_version: 3 dw_allowed_ip_ranges: rmca: 193.190.234 dw_analytics_code: UA-25371885-5 dw_analytics_enabled: true dw_bing_key: Ap3eFRefFd94_D4cqsicw-Fk1-d4kRat9pstTO4oo_i9anyUqrfQcqL9Ew9CJahg dw_catalogueRecLimit: 200 dw_contactMail: darwin-ict@naturalsciences.be dw_dateLowerBound: 0001/01/01 dw_dateUpperBound: 2038/12/31 dw_defaultInstitutionRef: 47859 dw_disableXSDValidation: false dw_domain_disable_menu: 'http://collections.naturalsciences.be' dw_gbif_url: 'https://www.gbif.org/species/search?q=' dw_iiif_viewer: 'https://virtual-collections.naturalsciences.be/mirador/index.php?manifest=' dw_mailer_sender: darwin-ict@naturalsciences.be dw_pagerSlidingSize: 5 dw_php_console: php dw_preview_max_size: 10 dw_queryTimeout: 600000 dw_recPerPage: 10 dw_recaptcha_private_key: 6Le-P1gUAAAAANoyBu1hwmNHU_Z0nu7nQPXV9Cty dw_recaptcha_proxy_host: 193.190.234.40 dw_recaptcha_proxy_port: 3128 dw_recaptcha_public_key: 6Le-P1gUAAAAAFskoU9q9lK1oMMUlAnU5n9dvgKo dw_report_server: 'https://jasperadmin:jasperadmin@darwin.naturalsciences.be/jasperserver' dw_reports_names_and_options: default: { server: main, language_added_to_name: false } loans_form_complete: { path: loans } annual_stat_collection: { language_added_to_name: true } dw_reports_servers: main: { server: darwin.naturalsciences.be, username: jasperadmin, password: jasperadmin, protocol: https, port: '443', base_path: /jasperserver/rest_v2/reports/darwin } dw_root_url_darwin: 'https://darwin.naturalsciences.be' dw_root_url_uuid: 'https://darwin.naturalsciences.be/darwin/search/view/uuid/' dw_root_url_wfs: 'https://darwin.naturalsciences.be/geoserver/' dw_salt: mySecret$alt dw_tagsDisplayLimit: 10 dw_tagsLowerLimit: 4 dw_tempFilePath: /tmp/temp_file dw_tracking_enabled: true dw_wfs_layers: rbins_natural_earth_adm: 'Natural Earth Administrative' rbins_natural_earth_physical: 'Natural Earth Physical' flanders_marine_institute_layers: 'Flanders Marine Institute' rbins_osm: 'Open Street Map' rbins_generic: 'RBINS Other layers' dw_yearRangeMax: 2026 dw_yearRangeMin: 1700 dw_yearUpperBound: '2038' mod_login_enabled: true mod_login_view_class: sfPHP mod_search_enabled: true mod_search_view_class: sfPHP sf_admin_module_web_dir: /sfDoctrinePlugin sf_admin_web_dir: /sf/sf_admin sf_app: public sf_app_base_cache_dir: /var/www/html/darwin/cache/public sf_app_cache_dir: /var/www/html/darwin/cache/public/dev sf_app_config_dir: /var/www/html/darwin/apps/public/config sf_app_dir: /var/www/html/darwin/apps/public sf_app_i18n_dir: /var/www/html/darwin/apps/public/i18n sf_app_lib_dir: /var/www/html/darwin/apps/public/lib sf_app_module_dir: /var/www/html/darwin/apps/public/modules sf_app_template_dir: /var/www/html/darwin/apps/public/templates sf_apps_dir: /var/www/html/darwin/apps sf_cache: false sf_cache_dir: /var/www/html/darwin/cache sf_charset: utf-8 sf_check_lock: on sf_cli: false sf_compressed: false sf_config_cache_dir: /var/www/html/darwin/cache/public/dev/config sf_config_dir: /var/www/html/darwin/config sf_csrf_secret: TemporarySecret sf_data_dir: /var/www/html/darwin/data sf_debug: true sf_default_culture: en sf_enabled_modules: - default sf_environment: dev sf_error_404_action: error404 sf_error_404_module: default sf_error_reporting: 32767 sf_escaping_method: ESC_SPECIALCHARS sf_escaping_strategy: on sf_etag: false sf_file_link_format: null sf_i18n: on sf_i18n_cache_dir: /var/www/html/darwin/cache/public/dev/i18n sf_lib_dir: /var/www/html/darwin/lib sf_log_dir: /var/www/html/darwin/log sf_logging_enabled: true sf_login_action: login sf_login_module: default sf_module_cache_dir: /var/www/html/darwin/cache/public/dev/modules sf_module_disabled_action: disabled sf_module_disabled_module: default sf_no_script_name: false sf_orm: doctrine sf_plugins_dir: /var/www/html/darwin/plugins sf_psr_logger: false sf_root_dir: /var/www/html/darwin sf_secure_action: secure sf_secure_module: default sf_standard_helpers: - Partial - Cache - I18N - Asset sf_symfony_lib_dir: /var/www/html/darwin/lib/vendor/symfony/lib sf_template_cache_dir: /var/www/html/darwin/cache/public/dev/template sf_test_cache_dir: /var/www/html/darwin/cache/public/dev/test sf_test_dir: /var/www/html/darwin/test sf_upload_dir: /var/www/html/darwin/web/uploads sf_upload_dir_name: uploads sf_use_database: true sf_web_debug: true sf_web_debug_web_dir: /sf/sf_web_debug sf_web_dir: /var/www/html/darwin/web symfony.asset.javascripts_included: true symfony.asset.stylesheets_included: true symfony.view.search_search_template: index tpl_authorizedversion: taxonomy: [1.2, 1.3] specimens: [1.4]
cookie: { } env: { } files: { } get: { } post: { } server: CONTEXT_DOCUMENT_ROOT: /var/www/html/darwin/web/ CONTEXT_PREFIX: '' DOCUMENT_ROOT: /var/www/html/darwin/web/ FCGI_ROLE: RESPONDER GATEWAY_INTERFACE: CGI/1.1 HOME: /var/www HTTPS: on HTTP_ACCEPT: '*/*' HTTP_CONNECTION: close HTTP_HOST: darwin.naturalsciences.be HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' HTTP_X_FORWARDED_FOR: 3.137.185.180 HTTP_X_FORWARDED_PROTO: https HTTP_X_REAL_IP: 3.137.185.180 PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' PATH_INFO: /search/search PATH_TRANSLATED: 'https://darwin.naturalsciences.be/dw_public/form//search' PHP_SELF: /public_dev.php/search/search QUERY_STRING: '' REMOTE_ADDR: 193.190.146.36 REMOTE_PORT: '59146' REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1714817904 REQUEST_TIME_FLOAT: 1714817904.754 REQUEST_URI: /public_dev.php/search/search SCRIPT_FILENAME: //var/www/html/darwin/web/public_dev.php SCRIPT_NAME: /public_dev.php SCRIPT_URI: 'https://darwin.naturalsciences.be/public_dev.php/search/search' SCRIPT_URL: /public_dev.php/search/search SERVER_ADDR: 192.168.36.184 SERVER_ADMIN: webmaster@localhost SERVER_NAME: darwin.naturalsciences.be SERVER_PORT: '443' SERVER_PROTOCOL: HTTP/1.0 SERVER_SIGNATURE: "<address>Apache/2.4.59 (Debian) Server at darwin.naturalsciences.be Port 443</address>\n" SERVER_SOFTWARE: 'Apache/2.4.59 (Debian)' SSL_CIPHER: ECDHE-RSA-AES256-GCM-SHA384 SSL_CIPHER_ALGKEYSIZE: '256' SSL_CIPHER_EXPORT: 'false' SSL_CIPHER_USEKEYSIZE: '256' SSL_CLIENT_VERIFY: NONE SSL_COMPRESS_METHOD: 'NULL' SSL_PROTOCOL: TLSv1.2 SSL_SECURE_RENEG: 'true' SSL_SERVER_A_KEY: rsaEncryption SSL_SERVER_A_SIG: sha384WithRSAEncryption SSL_SERVER_I_DN: 'CN=GEANT OV RSA CA 4,O=GEANT Vereniging,C=NL' SSL_SERVER_I_DN_C: NL SSL_SERVER_I_DN_CN: 'GEANT OV RSA CA 4' SSL_SERVER_I_DN_O: 'GEANT Vereniging' SSL_SERVER_M_SERIAL: 4CE88C7711A7342AC85DE1EB018977CD SSL_SERVER_M_VERSION: '3' SSL_SERVER_SAN_DNS_0: '*.naturalsciences.be' SSL_SERVER_SAN_DNS_1: naturalsciences.be SSL_SERVER_S_DN: 'CN=*.naturalsciences.be,O=Institut royal des Sciences naturelles de Belgique,ST=Bruxelles-Capitale\, Région de,C=BE' SSL_SERVER_S_DN_C: BE SSL_SERVER_S_DN_CN: '*.naturalsciences.be' SSL_SERVER_S_DN_O: 'Institut royal des Sciences naturelles de Belgique' SSL_SERVER_S_DN_ST: 'Bruxelles-Capitale, Région de' SSL_SERVER_V_END: 'Jan 3 23:59:59 2025 GMT' SSL_SERVER_V_START: 'Jan 4 00:00:00 2024 GMT' SSL_SESSION_RESUMED: Initial SSL_VERSION_INTERFACE: mod_ssl/2.4.59 SSL_VERSION_LIBRARY: OpenSSL/1.1.1w USER: www-data proxy-nokeepalive: '1' proxy-sendchunked: '' session: { }
php: 8.2.15 os: 'Linux diptera1 5.10.0-20-amd64 #1 SMP Debian 5.10.158-2 (2022-12-13) x86_64' extensions: 18: 'apcu (5.1.23)' 19: 'bz2 (8.2.15)' 20: 'calendar (8.2.15)' 15: 'cgi-fcgi (8.2.15)' 0: 'Core (8.2.15)' 21: 'ctype (8.2.15)' 22: 'curl (8.2.15)' 1: 'date (8.2.15)' 23: 'dom (20031129)' 33: 'exif (8.2.15)' 25: 'FFI (8.2.15)' 26: 'fileinfo (8.2.15)' 6: 'filter (8.2.15)' 27: 'ftp (8.2.15)' 28: 'gettext (8.2.15)' 7: 'hash (8.2.15)' 29: 'iconv (8.2.15)' 30: 'igbinary (3.2.15)' 31: 'intl (8.2.15)' 8: 'json (8.2.15)' 32: 'ldap (8.2.15)' 2: 'libxml (8.2.15)' 24: 'mbstring (8.2.15)' 34: 'memcache (8.2)' 51: 'memcached (3.2.0)' 35: 'msgpack (2.2.0)' 3: 'openssl (8.2.15)' 4: 'pcre (8.2.15)' 16: 'PDO (8.2.15)' 36: 'pdo_pgsql (8.2.15)' 37: 'pgsql (8.2.15)' 38: 'Phar (8.2.15)' 39: 'posix (8.2.15)' 9: 'random (8.2.15)' 40: 'readline (8.2.15)' 10: 'Reflection (8.2.15)' 12: 'session (8.2.15)' 41: 'shmop (8.2.15)' 42: 'SimpleXML (8.2.15)' 43: 'sockets (8.2.15)' 14: 'sodium (8.2.15)' 11: 'SPL (8.2.15)' 13: 'standard (8.2.15)' 44: 'sysvmsg (8.2.15)' 45: 'sysvsem (8.2.15)' 46: 'sysvshm (8.2.15)' 47: 'tokenizer (8.2.15)' 17: 'xml (8.2.15)' 48: 'xmlreader (8.2.15)' 49: 'xmlwriter (8.2.15)' 50: 'xsl (8.2.15)' 52: 'Zend OPcache (8.2.15)' 5: 'zlib (8.2.15)'
version: 1.5.12-dev path: /var/www/html/darwin/lib/vendor/symfony/lib
Parameters:
$pagerSlidingSize
(integer)$currentPage
(integer)$is_choose
(integer)$orderBy
(string)$orderDir
(string)$o_url
(string)$s_url
(string)$form
(PublicSearchFormFilter)
$form['taxon_name']
(sfWidgetFormInputText)
$form['taxon_level_ref']
(sfWidgetFormDarwinDoctrineChoice)
$form['litho_name']
(sfWidgetFormInputText)
$form['litho_level_ref']
(sfWidgetFormDarwinDoctrineChoice)
$form['chrono_name']
(sfWidgetFormInputText)
$form['chrono_level_ref']
(sfWidgetFormDarwinDoctrineChoice)
$form['lithology_name']
(sfWidgetFormInputText)
$form['lithology_level_ref']
(sfWidgetFormDarwinDoctrineChoice)
$form['mineral_name']
(sfWidgetFormInputText)
$form['mineral_level_ref']
(sfWidgetFormDarwinDoctrineChoice)
$form['rec_per_page']
(sfWidgetFormChoice)
$form['taxon_common_name']
(sfWidgetFormInputText)
$form['lithology_common_name']
(sfWidgetFormInputText)
$form['litho_common_name']
(sfWidgetFormInputText)
$form['chrono_common_name']
(sfWidgetFormInputText)
$form['mineral_common_name']
(sfWidgetFormInputText)
$form['col_fields']
(sfWidgetFormInputHidden)
$form['search_type']
(sfWidgetFormInputHidden)
$form['collection_ref']
(sfWidgetCollectionList)
$form['include_sub_collections']
(sfWidgetFormInputCheckbox)
$form['tags']
(sfWidgetFormTextarea)
$form['type']
(sfWidgetFormDarwinDoctrineChoice)
$form['sex']
(sfWidgetFormDarwinDoctrineChoice)
$form['stage']
(sfWidgetFormDarwinDoctrineChoice)
$form['codes']
(sfWidgetFormInputText)
$form['ig_num']
(sfWidgetFormInputText)
$form['_csrf_token']
(sfWidgetFormInputHidden)
$form['order_dir']
(sfWidgetFormInputHidden)
$form['order_by']
(sfWidgetFormInputHidden)
$form['current_page']
(sfWidgetFormInputHidden)
$form['institution_protocol']
(sfWidgetFormChoice)
$form['institution_identifier']
(sfWidgetFormInput)
$form['people_protocol']
(sfWidgetFormChoice)
$form['people_identifier']
(sfWidgetFormInput)
$form['people_identifier_role']
(sfWidgetFormChoice)
$form['link_type']
(sfWidgetFormChoice)
$form['link_url']
(sfWidgetFormInputText)
$form['public_query']
(sfWidgetFormDarwinDoctrineChoice)
No parameters were passed to this template.
Parameters:
No parameters were passed to this template.
# | type | message |
---|---|---|
1 | sfPatternRouting | Match route "search" (/search/search) for /search/search with parameters array ( 'module' => 'search', 'action' => 'search',) |
2 | sfFilterChain | Executing filter "sfRenderingFilter" |
3 | sfFilterChain | Executing filter "sfExecutionFilter" |
4 | searchActions | Call "searchActions->executeSearch()" |
5 | Doctrine_Connection_Pgsql | exec : SET NAMES 'UTF8' - () |
6 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.pref_key AS p__pref_key, p.pref_value AS p__pref_value, p.user_ref AS p__user_ref FROM preferences p WHERE (p.user_ref = ? AND p.pref_key = ?) - (-1, default_search_rec_pp) |
7 | Doctrine_Connection_Statement | execute : SELECT f.id AS f__id, f.dict_value AS f__0, f.dict_value AS f__0 FROM flat_dict f WHERE (f.dict_field = ? AND f.referenced_relation = ?) ORDER BY darwin2.fct_rcma_sort_letter_before_numbers(f.dict_value) ASC - (protocol, identifiers) |
8 | searchActions | Change template to "CURRENT/index" |
9 | sfPHPView | Render "sf_app_dir/modules/search/templates/indexSuccess.php" |
10 | main | Set slot "title" |
11 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.level_type AS c__level_type, c.level_name AS c__level_name, c.level_sys_name AS c__level_sys_name, c.optional_level AS c__optional_level, c.level_order AS c__level_order FROM catalogue_levels c WHERE (c.level_type = ?) ORDER BY c.id - (taxonomy) |
12 | Doctrine_Connection_Pgsql | query : SELECT p.id AS p__id, p.is_physical AS p__is_physical, p.sub_type AS p__sub_type, p.formated_name AS p__formated_name, p.formated_name_indexed AS p__formated_name_indexed, p.title AS p__title, p.family_name AS p__family_name, p.given_name AS p__given_name, p.additional_names AS p__additional_names, p.birth_date_mask AS p__birth_date_mask, p.birth_date AS p__birth_date, p.gender AS p__gender, p.end_date_mask AS p__end_date_mask, p.end_date AS p__end_date, p.activity_date_from AS p__activity_date_from, p.activity_date_from_mask AS p__activity_date_from_mask, p.activity_date_to AS p__activity_date_to, p.activity_date_to_mask AS p__activity_date_to_mask, c.id AS c__id, c.collection_type AS c__collection_type, c.code AS c__code, c.name AS c__name, c.name_indexed AS c__name_indexed, c.institution_ref AS c__institution_ref, c.main_manager_ref AS c__main_manager_ref, c.staff_ref AS c__staff_ref, c.parent_ref AS c__parent_ref, c.path AS c__path, c.code_auto_increment AS c__code_auto_increment, c.code_auto_increment_for_insert_only AS c__code_auto_increment_for_insert_only, c.code_last_value AS c__code_last_value, c.code_prefix AS c__code_prefix, c.code_prefix_separator AS c__code_prefix_separator, c.code_suffix AS c__code_suffix, c.code_suffix_separator AS c__code_suffix_separator, c.code_specimen_duplicate AS c__code_specimen_duplicate, c.is_public AS c__is_public, c.code_mask AS c__code_mask, c.allow_duplicates AS c__allow_duplicates, c.code_ai_inherit AS c__code_ai_inherit, c.nagoya AS c__nagoya, c.preferred_taxonomy AS c__preferred_taxonomy, c.uid AS c__uid, c2.id AS c2__id, c2.db_user_type AS c2__db_user_type, c.path || c.id || E'/' AS c__0, regexp_split_to_array(c.path || c.id || E'/', E'/') AS c__1 FROM people p INNER JOIN collections c ON p.id = c.institution_ref LEFT JOIN collections_rights c2 ON ((c.id = c2.collection_ref AND c2.user_ref = -1)) WHERE (p.is_physical = false AND c.is_public = TRUE) ORDER BY p.id ASC, c__1 ASC, c.name ASC - () |
13 | Doctrine_Connection_Statement | execute : SELECT f.id AS f__id, f.dict_field AS f__dict_field, f.dict_value AS f__dict_value FROM flat_dict f WHERE (f.referenced_relation = ?) ORDER BY f.dict_value ASC - (specimens) |
14 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
15 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
16 | main | Get slot "title" |
17 | sfPartialView | Render "sf_app_dir/templates/_head_menu.php" |
18 | main | Call "login->executeMenuLogin()" |
19 | sfPartialView | Render "sf_app_dir/modules/login/templates/_MenuLogin.php" |
20 | sfPartialView | Render "sf_app_dir/templates/_analytics.php" |
21 | sfWebResponse | Send status "HTTP/1.0 200 OK" |
22 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
type | calls | time (ms) | time (%) |
---|---|---|---|
Configuration | 14 | 46.94 | 6 |
Factories | 1 | 1.42 | 0 |
Action "search/search" | 1 | 36.79 | 4 |
Database (Doctrine) | 6 | 61.74 | 7 |
View "Success" for "search/search" | 1 | 678.44 | 87 |
Partial "global/_head_menu" | 1 | 1.09 | 0 |
Component "login/MenuLogin" | 1 | 0.17 | 0 |
Partial "login/_MenuLogin" | 1 | 0.24 | 0 |
Partial "global/_analytics" | 1 | 0.06 | 0 |
SET NAMES 'UTF8'
SELECT p.id AS p__id, p.pref_key AS p__pref_key, p.pref_value AS p__pref_value, p.user_ref AS p__user_ref FROM preferences p WHERE (p.user_ref = '-1' AND p.pref_key = 'default_search_rec_pp')
SELECT f.id AS f__id, f.dict_value AS f__0, f.dict_value AS f__0 FROM flat_dict f WHERE (f.dict_field = 'protocol' AND f.referenced_relation = 'identifiers') ORDER BY darwin2.fct_rcma_sort_letter_before_numbers(f.dict_value) ASC
SELECT c.id AS c__id, c.level_type AS c__level_type, c.level_name AS c__level_name, c.level_sys_name AS c__level_sys_name, c.optional_level AS c__optional_level, c.level_order AS c__level_order FROM catalogue_levels c WHERE (c.level_type = 'taxonomy') ORDER BY c.id
SELECT p.id AS p__id, p.is_physical AS p__is_physical, p.sub_type AS p__sub_type, p.formated_name AS p__formated_name, p.formated_name_indexed AS p__formated_name_indexed, p.title AS p__title, p.family_name AS p__family_name, p.given_name AS p__given_name, p.additional_names AS p__additional_names, p.birth_date_mask AS p__birth_date_mask, p.birth_date AS p__birth_date, p.gender AS p__gender, p.end_date_mask AS p__end_date_mask, p.end_date AS p__end_date, p.activity_date_from AS p__activity_date_from, p.activity_date_from_mask AS p__activity_date_from_mask, p.activity_date_to AS p__activity_date_to, p.activity_date_to_mask AS p__activity_date_to_mask, c.id AS c__id, c.collection_type AS c__collection_type, c.code AS c__code, c.name AS c__name, c.name_indexed AS c__name_indexed, c.institution_ref AS c__institution_ref, c.main_manager_ref AS c__main_manager_ref, c.staff_ref AS c__staff_ref, c.parent_ref AS c__parent_ref, c.path AS c__path, c.code_auto_increment AS c__code_auto_increment, c.code_auto_increment_for_insert_only AS c__code_auto_increment_for_insert_only, c.code_last_value AS c__code_last_value, c.code_prefix AS c__code_prefix, c.code_prefix_separator AS c__code_prefix_separator, c.code_suffix AS c__code_suffix, c.code_suffix_separator AS c__code_suffix_separator, c.code_specimen_duplicate AS c__code_specimen_duplicate, c.is_public AS c__is_public, c.code_mask AS c__code_mask, c.allow_duplicates AS c__allow_duplicates, c.code_ai_inherit AS c__code_ai_inherit, c.nagoya AS c__nagoya, c.preferred_taxonomy AS c__preferred_taxonomy, c.uid AS c__uid, c2.id AS c2__id, c2.db_user_type AS c2__db_user_type, c.path || c.id || E'/' AS c__0, regexp_split_to_array(c.path || c.id || E'/', E'/') AS c__1 FROM people p INNER JOIN collections c ON p.id = c.institution_ref LEFT JOIN collections_rights c2 ON ((c.id = c2.collection_ref AND c2.user_ref = -1)) WHERE (p.is_physical = false AND c.is_public = TRUE) ORDER BY p.id ASC, c__1 ASC, c.name ASC
SELECT f.id AS f__id, f.dict_field AS f__dict_field, f.dict_value AS f__dict_value FROM flat_dict f WHERE (f.referenced_relation = 'specimens') ORDER BY f.dict_value ASC