Warning (2): pg_connect() [http://php.net/function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server: Connection refused
	Is the server running on host "zygfryd.med.virginia.edu" (128.143.16.12) and accepting
	TCP/IP connections on port 5432? [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 120]
Warning (2): pg_query() expects parameter 1 to be resource, boolean given [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 168]
Warning (2): pg_last_error() expects parameter 1 to be resource, boolean given [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 346]
New York Center for Structural Genomics - Publications

Publications

Locations of collaborators (co-authors of NYSGRC and NYSGXRC papers)

Page 0 of 1, showing 1 records out of total, starting on record 0, ending on

Warning (2): Invalid argument supplied for foreach() [/var/www/unitrack/views/publications/unitrack_index.ctp, line 81]
Pmid Authors Title Journal Issn Year Vol Pages Center Target Pdb Type Times Cited
change view


<< previous | | next >>
(psipubs) 2 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS "count" FROM "publication" AS "Publication" LEFT JOIN "journal_alias" AS "JournalAlias" ON ("Publication"."journal_short" = "JournalAlias"."name") WHERE center like'%NYSGRC%' or center like '%NYSGXRC%' 2
2SELECT "Publication"."id" AS "Publication__id", "Publication"."pmid" AS "Publication__pmid", "Publication"."authors" AS "Publication__authors", "Publication"."title" AS "Publication__title", "Publication"."journal_short" AS "Publication__journal_short", "Publication"."issn" AS "Publication__issn", "Publication"."year" AS "Publication__year", "Publication"."vol" AS "Publication__vol", "Publication"."pages" AS "Publication__pages", "Publication"."center" AS "Publication__center", "Publication"."target_id" AS "Publication__target_id", "Publication"."pdb_id" AS "Publication__pdb_id", "Publication"."type" AS "Publication__type", "Publication"."status" AS "Publication__status", "Publication"."source" AS "Publication__source", "Publication"."remark" AS "Publication__remark", "Publication"."verified" AS "Publication__verified", "Publication"."frozen" AS "Publication__frozen", "Publication"."times_cited" AS "Publication__times_cited", "Publication"."times_cited_update" AS "Publication__times_cited_update", "Publication"."inserted" AS "Publication__inserted", "Publication"."updated" AS "Publication__updated", "Publication"."times_cited_status" AS "Publication__times_cited_status", "Publication"."pubmed_times_cited" AS "Publication__pubmed_times_cited", "Publication"."pubmed_times_cited_update" AS "Publication__pubmed_times_cited_update", "Publication"."pubmed_times_cited_status" AS "Publication__pubmed_times_cited_status", "Publication"."cover_image" AS "Publication__cover_image", "Publication"."initiative_id" AS "Publication__initiative_id", "Publication"."pmcid" AS "Publication__pmcid", "Publication"."doi" AS "Publication__doi", "Publication"."date_pubmed_created" AS "Publication__date_pubmed_created", "Publication"."date_pubmed_updated" AS "Publication__date_pubmed_updated", "Publication"."pub_month" AS "Publication__pub_month", "Publication"."pub_day" AS "Publication__pub_day", "Publication"."date_accepted" AS "Publication__date_accepted", "Publication"."date_pubmed_history" AS "Publication__date_pubmed_history", "Publication"."date_aheadofprint" AS "Publication__date_aheadofprint", "Publication"."cite_error_id" AS "Publication__cite_error_id", "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "publication" AS "Publication" LEFT JOIN "journal_alias" AS "JournalAlias" ON ("Publication"."journal_short" = "JournalAlias"."name") WHERE center like'%NYSGRC%' or center like '%NYSGXRC%' ORDER BY "year" desc, "id" desc LIMIT 100
(default) 2 queries took 7 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1005
2SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1002
(labdb) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)