8 | 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 (c2.id is not null OR c.is_public = TRUE)) ORDER BY p.id ASC, c__1 ASC, c.name ASC - () |
13 | main | Call "login->executeMenuLogin()" |