| 1 | SELECT DISTINCT `publication_id`,`researcher_id` FROM `score_tables` WHERE `score_tables`.`researcher_id`=? AND `score_tables`.`score1`>? AND `identified_author`=? , params[ 25138, 0.5, 0 ] | | 15 | 15 | 1 |
| 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, 25138 ] | | 1 | 1 | 1 |
| 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, 25138, 0 ] | | 1 | 1 | 1 |
| 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, 25138, 25138 ] | | 1 | 1 | 84 |
| 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 20, 10 , params[ authenticus, 25138, 0 ] | | 10 | 10 | 1 |
| 6 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 852640 ] | | 2 | 2 | 0 |
| 7 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 852640 ] | | 2 | 2 | 0 |
| 8 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 852640 ] | | 3 | 3 | 0 |
| 9 | SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 25138, 852640 ] | | 1 | 1 | 0 |
| 10 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 1220543 ] | | 1 | 1 | 0 |
| 11 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 1220543 ] | | 1 | 1 | 0 |
| 12 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 1220543 ] | | 1 | 1 | 0 |
| 13 | SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 25138, 1220543 ] | | 1 | 1 | 0 |
| 14 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 1220546 ] | | 1 | 1 | 0 |
| 15 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 1220546 ] | | 1 | 1 | 0 |
| 16 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 1220546 ] | | 1 | 1 | 0 |
| 17 | SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 25138, 1220546 ] | | 1 | 1 | 0 |
| 18 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 1220548 ] | | 1 | 1 | 0 |
| 19 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 1220548 ] | | 1 | 1 | 0 |
| 20 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 1220548 ] | | 1 | 1 | 0 |
| 21 | SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 25138, 1220548 ] | | 1 | 1 | 0 |
| 22 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 1220552 ] | | 1 | 1 | 0 |
| 23 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 1220552 ] | | 1 | 1 | 0 |
| 24 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 1220552 ] | | 1 | 1 | 0 |
| 25 | SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 25138, 1220552 ] | | 1 | 1 | 0 |
| 26 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 1220557 ] | | 1 | 1 | 0 |
| 27 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 1220557 ] | | 1 | 1 | 0 |
| 28 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 1220557 ] | | 1 | 1 | 0 |
| 29 | SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 25138, 1220557 ] | | 1 | 1 | 0 |
| 30 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 1220559 ] | | 1 | 1 | 0 |
| 31 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 1220559 ] | | 1 | 1 | 0 |
| 32 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 1220559 ] | | 1 | 1 | 0 |
| 33 | SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 25138, 1220559 ] | | 1 | 1 | 0 |
| 34 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 1220561 ] | | 1 | 1 | 0 |
| 35 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 1220561 ] | | 1 | 1 | 0 |
| 36 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 1220561 ] | | 1 | 1 | 0 |
| 37 | SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 25138, 1220561 ] | | 1 | 1 | 0 |
| 38 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 786626 ] | | 1 | 1 | 0 |
| 39 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 786626 ] | | 2 | 2 | 0 |
| 40 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 786626 ] | | 2 | 2 | 0 |
| 41 | SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 25138, 786626 ] | | 0 | 0 | 0 |
| 42 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 1220537 ] | | 1 | 1 | 0 |
| 43 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 1220537 ] | | 1 | 1 | 0 |
| 44 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 1220537 ] | | 1 | 1 | 0 |
| 45 | SELECT `type` FROM `researcher_publication_external_databases` WHERE `researcher_id`=? AND `publication_id`=? , params[ 25138, 1220537 ] | | 1 | 1 | 0 |
| 46 | SELECT `name` FROM `researchers` WHERE `id`=? , params[ 25138 ] | | 1 | 1 | 0 |
| 47 | SELECT `Article`.`id`, `Article`.`title_en`, `Article`.`title_pt` FROM `authenticus`.`articles` AS `Article` WHERE `controller` = 'profileOfResearchers' AND `published` = '1' | | 0 | 0 | 0 |
| 48 | SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 852640 ] | | 6 | 6 | 0 |
| 49 | SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 1220543 ] | | 5 | 5 | 0 |
| 50 | SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 1220546 ] | | 5 | 5 | 0 |
| 51 | SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 1220548 ] | | 5 | 5 | 0 |
| 52 | SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 1220552 ] | | 4 | 4 | 0 |
| 53 | SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 1220557 ] | | 3 | 3 | 0 |
| 54 | SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 1220559 ] | | 5 | 5 | 0 |
| 55 | SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 1220561 ] | | 11 | 11 | 0 |
| 56 | SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 786626 ] | | 3 | 3 | 0 |
| 57 | SELECT * FROM `publication_authors` LEFT JOIN `researchers` ON (`researchers`.`id`=`publication_authors`.`researcher_id`) WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 1220537 ] | | 8 | 8 | 0 |
WOS