| 1 |
0.72 ms |
SELECT t0.id AS id_1, t0.researcher_id AS researcher_id_2, t0.daisng_id AS daisng_id_3, t0.bio AS bio_4, t0.vigent AS vigent_5, t0.user_id AS user_id_6 FROM author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.researcher_id AS researcher_id_2, t0.daisng_id AS daisng_id_3, t0.bio AS bio_4, t0.vigent AS vigent_5, t0.user_id AS user_id_6 FROM author t0 WHERE t0.id = '26';
|
| 2 |
1.45 ms |
SELECT CONCAT(e0_.firstname, ' ', e0_.lastname) AS sclr_0, COUNT(p1_.id) AS sclr_1, CONCAT(e0_.gender, ' p(', e0_.gender_probability, ')') AS sclr_2, e0_.id AS id_3 FROM external_author e0_ INNER JOIN publication_author p2_ ON e0_.id = p2_.external_author_id INNER JOIN publication p1_ ON p2_.publication_id = p1_.id INNER JOIN publication_author p3_ ON p1_.id = p3_.publication_id INNER JOIN author a4_ ON p3_.author_id = a4_.id WHERE a4_.id = ? AND p1_.validated = 1 GROUP BY e0_.id ORDER BY COUNT(p1_.id) DESC
SELECT CONCAT(e0_.firstname, ' ', e0_.lastname) AS sclr_0, COUNT(p1_.id) AS sclr_1, CONCAT(e0_.gender, ' p(', e0_.gender_probability, ')') AS sclr_2, e0_.id AS id_3 FROM external_author e0_ INNER JOIN publication_author p2_ ON e0_.id = p2_.external_author_id INNER JOIN publication p1_ ON p2_.publication_id = p1_.id INNER JOIN publication_author p3_ ON p1_.id = p3_.publication_id INNER JOIN author a4_ ON p3_.author_id = a4_.id WHERE a4_.id = 26 AND p1_.validated = 1 GROUP BY e0_.id ORDER BY COUNT(p1_.id) DESC;
|
| 3 |
0.52 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12991;
|
| 4 |
0.31 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 5292;
|
| 5 |
0.25 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13001;
|
| 6 |
0.23 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12999;
|
| 7 |
0.25 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12992;
|
| 8 |
0.22 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12997;
|
| 9 |
0.18 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8828;
|
| 10 |
0.22 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13008;
|
| 11 |
0.23 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8821;
|
| 12 |
0.23 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12995;
|
| 13 |
0.25 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12988;
|
| 14 |
0.19 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13012;
|
| 15 |
0.17 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8825;
|
| 16 |
0.24 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 5296;
|
| 17 |
0.18 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13005;
|
| 18 |
0.19 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8829;
|
| 19 |
0.19 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13009;
|
| 20 |
0.16 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8822;
|
| 21 |
0.20 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 5293;
|
| 22 |
0.17 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13002;
|
| 23 |
0.19 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12996;
|
| 24 |
0.27 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12989;
|
| 25 |
0.24 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8826;
|
| 26 |
0.19 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8819;
|
| 27 |
0.20 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13006;
|
| 28 |
0.18 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13000;
|
| 29 |
0.36 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12993;
|
| 30 |
0.20 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8830;
|
| 31 |
0.22 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13010;
|
| 32 |
0.17 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8823;
|
| 33 |
0.20 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 5294;
|
| 34 |
0.17 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13003;
|
| 35 |
0.18 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12990;
|
| 36 |
0.17 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8827;
|
| 37 |
0.25 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8820;
|
| 38 |
0.19 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13007;
|
| 39 |
0.19 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 9402;
|
| 40 |
0.17 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12994;
|
| 41 |
0.18 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12987;
|
| 42 |
0.19 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13011;
|
| 43 |
0.19 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8824;
|
| 44 |
0.18 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 5295;
|
| 45 |
0.17 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13004;
|
| 46 |
0.18 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 12998;
|
| 47 |
1.07 ms |
SELECT CONCAT(u0_.name, ' ', u0_.last_name) AS sclr_0, COUNT(a1_.id) AS sclr_1, a1_.id AS id_2, a1_.vigent AS vigent_3 FROM author a1_ INNER JOIN publication_author p2_ ON a1_.id = p2_.author_id INNER JOIN publication p3_ ON p2_.publication_id = p3_.id INNER JOIN publication_author p4_ ON p3_.id = p4_.publication_id INNER JOIN author a5_ ON p4_.author_id = a5_.id INNER JOIN `user` u0_ ON a1_.user_id = u0_.id WHERE a5_.id = ? AND a1_.id <> a5_.id AND p3_.validated = 1 GROUP BY a1_.id, u0_.name, u0_.last_name ORDER BY COUNT(a1_.id) DESC
SELECT CONCAT(u0_.name, ' ', u0_.last_name) AS sclr_0, COUNT(a1_.id) AS sclr_1, a1_.id AS id_2, a1_.vigent AS vigent_3 FROM author a1_ INNER JOIN publication_author p2_ ON a1_.id = p2_.author_id INNER JOIN publication p3_ ON p2_.publication_id = p3_.id INNER JOIN publication_author p4_ ON p3_.id = p4_.publication_id INNER JOIN author a5_ ON p4_.author_id = a5_.id INNER JOIN `user` u0_ ON a1_.user_id = u0_.id WHERE a5_.id = 26 AND a1_.id <> a5_.id AND p3_.validated = 1 GROUP BY a1_.id, u0_.name, u0_.last_name ORDER BY COUNT(a1_.id) DESC;
|
| 48 |
0.40 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.author_id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.author_id = 26;
|
| 49 |
0.42 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = 135;
|
| 50 |
0.50 ms |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 135;
|
| 51 |
0.55 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = 136;
|
| 52 |
0.47 ms |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 136;
|
| 53 |
0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = 1550;
|
| 54 |
0.43 ms |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 1550;
|
| 55 |
0.39 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = 1551;
|
| 56 |
0.43 ms |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 1551;
|
| 57 |
0.39 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = 1552;
|
| 58 |
0.42 ms |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 1552;
|
| 59 |
0.39 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = 2083;
|
| 60 |
0.35 ms |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 2083;
|
| 61 |
0.31 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = 3017;
|
| 62 |
0.37 ms |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 3017;
|
| 63 |
0.31 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = 3018;
|
| 64 |
0.31 ms |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 3018;
|
| 65 |
0.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = 3019;
|
| 66 |
0.35 ms |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 3019;
|
| 67 |
0.31 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = 1550;
|
| 68 |
0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 10012;
|
| 69 |
0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 10013;
|
| 70 |
0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 10014;
|
| 71 |
0.31 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = 1551;
|
| 72 |
0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 10015;
|
| 73 |
0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 10016;
|
| 74 |
0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 10017;
|
| 75 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 10018;
|
| 76 |
0.27 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = 2083;
|
| 77 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15577;
|
| 78 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15578;
|
| 79 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15579;
|
| 80 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15580;
|
| 81 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15581;
|
| 82 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15582;
|
| 83 |
0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15583;
|
| 84 |
0.73 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15584;
|
| 85 |
0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15585;
|
| 86 |
0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15586;
|
| 87 |
0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15587;
|
| 88 |
0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15588;
|
| 89 |
0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 15589;
|
| 90 |
0.55 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = 3017;
|
| 91 |
0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27687;
|
| 92 |
0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27688;
|
| 93 |
0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27689;
|
| 94 |
0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27690;
|
| 95 |
0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27691;
|
| 96 |
0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27692;
|
| 97 |
0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27693;
|
| 98 |
0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27694;
|
| 99 |
0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27695;
|
| 100 |
0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27696;
|
| 101 |
0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27697;
|
| 102 |
0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27698;
|
| 103 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27699;
|
| 104 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27700;
|
| 105 |
0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27701;
|
| 106 |
0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27702;
|
| 107 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27703;
|
| 108 |
0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27704;
|
| 109 |
0.28 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = 3018;
|
| 110 |
0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27705;
|
| 111 |
0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27706;
|
| 112 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27707;
|
| 113 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27708;
|
| 114 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27709;
|
| 115 |
0.28 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = 3019;
|
| 116 |
0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27710;
|
| 117 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27711;
|
| 118 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27712;
|
| 119 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27713;
|
| 120 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27714;
|
| 121 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27715;
|
| 122 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27716;
|
| 123 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27717;
|
| 124 |
0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27718;
|
| 125 |
0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27719;
|
| 126 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27720;
|
| 127 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27721;
|
| 128 |
0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 27722;
|
| 129 |
0.26 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = 27;
|
| 130 |
0.34 ms |
SELECT t0.id AS id_1, t0.research_line AS research_line_2, t0.sort AS sort_3 FROM research_line t0 INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id WHERE author_research_line.author_id = ?
SELECT t0.id AS id_1, t0.research_line AS research_line_2, t0.sort AS sort_3 FROM research_line t0 INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id WHERE author_research_line.author_id = 26;
|