ProfileOfResearchers

Identificadas 1

TÃTULO: Helicobacter pylori Diagnostic Tests Used in Europe: Results of over 34,000 Patients from the European Registry on Helicobacter pylori Management
AUTORES: Garcia Morales, Natalia; Perez Aisa, Angeles; Fiorini, Giulia; Tepes, Bojan; Castro Fernandez, Manuel; Lucendo, Alfredo; Voynovan, Irina; Bujanda, Luis; Garre, Ana; Rodrigo, Luis; Martinez Dominguez, Samuel Jesus; Denkovski, Maja; Huguet Malaves, Jose M.; Jonaitis, Laimas; Bumane, Renate; Zaytsev, Oleg; Mata Romero, Pilar; Barrio, Jesus; Fernandez Salazar, Luis; Sarsenbaeva, Aiman Silkanovna; Ortiz Polo, Inmaculada; Alekseenko, Sergey; Saracino, Ilaria Maria; Vaira, Dino; Keco Huerga, Alma; Bordin, Dmitry; Gasbarrini, Antonio; Lerang, Frode; Rokkas, Theodore; Kupcinskas, Juozas; Leja, Marcis; Babayeva, Gulustan; Marcos Pinto, Ricardo ; Tonkic, Ante; Smith, Sinead; Phull, Perminder; Buzas, Gyorgy; Simsek, Halis; Boltin, Doron; Gridnyev, Oleksiy; Venerito, Marino; Milivojevic, Vladimir; Tora, Nuria; Cano Catala, Anna; Moreira, Leticia; Nyssen, Olga P.; Megraud, Francis; O'Morain, Colm; Gisbert, Javier P.; Puig, Ignasi; ...Mais
PUBLICAÇÃO: 2023, FONTE: JOURNAL OF CLINICAL MEDICINE, VOLUME: 12, NÚMERO: 13

INDEXADO EM:

Scopus

WOS

(default) 12 queries took 83 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT DISTINCT `publication_id`,`researcher_id` FROM `score_tables` WHERE `score_tables`.`researcher_id`=? AND `score_tables`.`score1`>? AND `identified_author`=? , params[ 652794, 0.5, 0 ]	1	1	0
2	SELECT COUNT(*) AS `count` FROM `researcher_selected_publications` JOIN `publications` ON (`researcher_selected_publications`.`publication_id`=`publications`.`id`) JOIN `publication_document_types` ON (`publications`.`id`=`publication_document_types`.`publication_id` AND `publication_document_types`.`type`=?) WHERE `researcher_selected_publications`.`researcher_id`=? , params[ authenticus, 652794 ]	1	1	0
3	SELECT COUNT(*) AS `count` FROM `publication_authors` JOIN `publications` ON (`publication_authors`.`publication_id`=`publications`.`id`) JOIN `publication_document_types` AS `publication_dt` ON (`publications`.`id`=`publication_dt`.`publication_id` AND `publication_dt`.`type`=?) WHERE `publication_authors`.`researcher_id`=? AND `publication_authors`.`validated`=? , params[ authenticus, 652794, 0 ]	1	1	0
4	SELECT COUNT(*) AS `count` FROM `publication_duplicates` WHERE `enable`>? AND (`pub_id_1` IN (SELECT `publication_id` FROM `publication_authors` WHERE `researcher_id`=?) OR `pub_id_2` IN (SELECT `publication_id` FROM `publication_authors` WHERE `researcher_id`=?)) , params[ 0, 652794, 652794 ]	1	1	82
5	SELECT `publications`.`id`,`publication_dt`.`document_type`,`document_title`,`subtitle`,`publication_name`,`conference_title`,`volume`,`issue`,`page_count`,`publications`.`year_published` FROM `publication_authors` JOIN `publications` ON (`publication_authors`.`publication_id`=`publications`.`id`) JOIN `publication_document_types` AS `publication_dt` ON (`publications`.`id`=`publication_dt`.`publication_id` AND `publication_dt`.`type`=?) WHERE `publication_authors`.`researcher_id`=? AND `publication_authors`.`validated`=? ORDER BY `publications`.`year_published` DESC, `publications`.`id` ASC LIMIT 10 , params[ authenticus, 652794, 0 ]	1	1	0
6	SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 1009350 ]	2	2	0
7	SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 1009350 ]	2	2	0
8	SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 1009350 ]	3	3	0
9	SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 652794, 1009350 ]	0	0	0
10	SELECT `name` FROM `researchers` WHERE `id`=? , params[ 652794 ]	1	1	0
11	SELECT `Article`.`id`, `Article`.`title_en`, `Article`.`title_pt` FROM `authenticus`.`articles` AS `Article` WHERE `controller` = 'profileOfResearchers' AND `published` = '1'	0	0	0
12	SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 1009350 ]	50	50	1

(default) 12 queries took 83 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT DISTINCT `publication_id`,`researcher_id` FROM `score_tables` WHERE `score_tables`.`researcher_id`=? AND `score_tables`.`score1`>? AND `identified_author`=? , params[ 652794, 0.5, 0 ]

SELECT COUNT(*) AS `count` FROM `researcher_selected_publications` JOIN `publications` ON (`researcher_selected_publications`.`publication_id`=`publications`.`id`) JOIN `publication_document_types` ON (`publications`.`id`=`publication_document_types`.`publication_id` AND `publication_document_types`.`type`=?) WHERE `researcher_selected_publications`.`researcher_id`=? , params[ authenticus, 652794 ]

SELECT COUNT(*) AS `count` FROM `publication_authors` JOIN `publications` ON (`publication_authors`.`publication_id`=`publications`.`id`) JOIN `publication_document_types` AS `publication_dt` ON (`publications`.`id`=`publication_dt`.`publication_id` AND `publication_dt`.`type`=?) WHERE `publication_authors`.`researcher_id`=? AND `publication_authors`.`validated`=? , params[ authenticus, 652794, 0 ]

SELECT COUNT(*) AS `count` FROM `publication_duplicates` WHERE `enable`>? AND (`pub_id_1` IN (SELECT `publication_id` FROM `publication_authors` WHERE `researcher_id`=?) OR `pub_id_2` IN (SELECT `publication_id` FROM `publication_authors` WHERE `researcher_id`=?)) , params[ 0, 652794, 652794 ]

SELECT `publications`.`id`,`publication_dt`.`document_type`,`document_title`,`subtitle`,`publication_name`,`conference_title`,`volume`,`issue`,`page_count`,`publications`.`year_published` FROM `publication_authors` JOIN `publications` ON (`publication_authors`.`publication_id`=`publications`.`id`) JOIN `publication_document_types` AS `publication_dt` ON (`publications`.`id`=`publication_dt`.`publication_id` AND `publication_dt`.`type`=?) WHERE `publication_authors`.`researcher_id`=? AND `publication_authors`.`validated`=? ORDER BY `publications`.`year_published` DESC, `publications`.`id` ASC LIMIT 10 , params[ authenticus, 652794, 0 ]

SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 1009350 ]

SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 1009350 ]

SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 1009350 ]

SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 652794, 1009350 ]

SELECT `name` FROM `researchers` WHERE `id`=? , params[ 652794 ]

SELECT `Article`.`id`, `Article`.`title_en`, `Article`.`title_pt` FROM `authenticus`.`articles` AS `Article` WHERE `controller` = 'profileOfResearchers' AND `published` = '1'

SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 1009350 ]

(user_permissions) 4 queries took 0 ms
Nr	Query	Affected	Num. rows
1	SELECT `permissions_groups`.`name`,`permissions_groups`.`require_extra_id` FROM `permissions_objects_groups` JOIN `permissions_objects` ON (`permissions_objects_groups`.`object_id`=`permissions_objects`.`id`) JOIN `permissions_groups` ON (`permissions_objects_groups`.`group_id`=`permissions_groups`.`id`) WHERE `permissions_objects`.`name`=? , params[ controller/profileOfResearchers/validatePublications ]	5	5
2	SELECT `field`,`required_level` FROM `researcher_privacy_settings` WHERE `researcher_id`=? , params[ 652794 ]	0	0
3	SELECT `field`,`required_level` FROM `researcher_privacy_settings` WHERE `researcher_id`=? , params[ 652794 ]	0	0
4	SELECT `field`,`required_level` FROM `researcher_privacy_settings` WHERE `researcher_id`=? , params[ 652794 ]	0	0

(user_permissions) 4 queries took 0 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `permissions_groups`.`name`,`permissions_groups`.`require_extra_id` FROM `permissions_objects_groups` JOIN `permissions_objects` ON (`permissions_objects_groups`.`object_id`=`permissions_objects`.`id`) JOIN `permissions_groups` ON (`permissions_objects_groups`.`group_id`=`permissions_groups`.`id`) WHERE `permissions_objects`.`name`=? , params[ controller/profileOfResearchers/validatePublications ]

SELECT `field`,`required_level` FROM `researcher_privacy_settings` WHERE `researcher_id`=? , params[ 652794 ]

Renate Bumane

Publicações a aguardar confirmação

Links Úteis

Ajuda

Autenticação Federada (Clique na imagem)

Renate Bumane

Publicações a aguardar confirmação

Links Úteis

Ajuda