| 1 |
0.44 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 = '83';
|
| 2 |
1.02 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 = 83 AND p1_.validated = 1 GROUP BY e0_.id ORDER BY COUNT(p1_.id) DESC;
|
| 3 |
0.28 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 = 8259;
|
| 4 |
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 = 8266;
|
| 5 |
0.21 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 = 8260;
|
| 6 |
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 = 7877;
|
| 7 |
0.21 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 = 10358;
|
| 8 |
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 = 486;
|
| 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 = 956;
|
| 10 |
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 = 14029;
|
| 11 |
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 = 13049;
|
| 12 |
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 = 8268;
|
| 13 |
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 = 8262;
|
| 14 |
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 = 8258;
|
| 15 |
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 = 14030;
|
| 16 |
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 = 1560;
|
| 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 = 8272;
|
| 18 |
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 = 8265;
|
| 19 |
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 = 8261;
|
| 20 |
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 = 13300;
|
| 21 |
0.26 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 = 13046;
|
| 22 |
0.21 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 = 8269;
|
| 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 = 8263;
|
| 24 |
0.54 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 = 12915;
|
| 25 |
0.34 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 = 13047;
|
| 26 |
0.48 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 = 8273;
|
| 27 |
0.33 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 = 14027;
|
| 28 |
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 = 1544;
|
| 29 |
0.49 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 = 8270;
|
| 30 |
0.47 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 = 4473;
|
| 31 |
0.38 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 = 13048;
|
| 32 |
0.29 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 = 929;
|
| 33 |
0.32 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 = 8267;
|
| 34 |
0.57 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 = 4469;
|
| 35 |
0.51 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 = 485;
|
| 36 |
0.49 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 = 8271;
|
| 37 |
0.56 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 = 8264;
|
| 38 |
2.99 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 = 83 AND a1_.id <> a5_.id AND p3_.validated = 1 GROUP BY a1_.id, u0_.name, u0_.last_name ORDER BY COUNT(a1_.id) DESC;
|
| 39 |
0.97 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 = 83;
|
| 40 |
0.72 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 = 197;
|
| 41 |
0.74 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 = 197;
|
| 42 |
0.62 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 = 381;
|
| 43 |
0.40 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 = 381;
|
| 44 |
0.32 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 = 385;
|
| 45 |
0.30 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 = 385;
|
| 46 |
0.51 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 = 386;
|
| 47 |
0.33 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 = 386;
|
| 48 |
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 = 390;
|
| 49 |
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 = 390;
|
| 50 |
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 = 391;
|
| 51 |
0.36 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 = 391;
|
| 52 |
0.43 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 = 392;
|
| 53 |
0.39 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 = 392;
|
| 54 |
0.34 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 = 393;
|
| 55 |
0.34 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 = 393;
|
| 56 |
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 = 492;
|
| 57 |
0.62 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 = 492;
|
| 58 |
0.52 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 = 494;
|
| 59 |
0.76 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 = 494;
|
| 60 |
0.62 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 = 616;
|
| 61 |
0.52 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 = 616;
|
| 62 |
0.46 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 = 617;
|
| 63 |
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 = 617;
|
| 64 |
0.68 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 = 618;
|
| 65 |
0.57 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 = 618;
|
| 66 |
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 = 619;
|
| 67 |
0.51 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 = 619;
|
| 68 |
0.58 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 = 620;
|
| 69 |
0.60 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 = 620;
|
| 70 |
0.52 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 = 621;
|
| 71 |
0.48 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 = 621;
|
| 72 |
0.46 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 = 622;
|
| 73 |
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 = 622;
|
| 74 |
0.56 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 = 623;
|
| 75 |
0.54 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 = 623;
|
| 76 |
0.52 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 = 1661;
|
| 77 |
0.54 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 = 1661;
|
| 78 |
0.49 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 = 1925;
|
| 79 |
0.58 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 = 1925;
|
| 80 |
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 = 1926;
|
| 81 |
0.81 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 = 1926;
|
| 82 |
0.77 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 = 1927;
|
| 83 |
1.07 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 = 1927;
|
| 84 |
1.02 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 = 3037;
|
| 85 |
0.80 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 = 3037;
|
| 86 |
0.93 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 = 3038;
|
| 87 |
0.91 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 = 3038;
|
| 88 |
0.81 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 = 3128;
|
| 89 |
0.74 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 = 3128;
|
| 90 |
0.88 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 = 3269;
|
| 91 |
0.77 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 = 3269;
|
| 92 |
0.80 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 = 3270;
|
| 93 |
0.73 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 = 3270;
|
| 94 |
0.73 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 = 3563;
|
| 95 |
0.91 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 = 3563;
|
| 96 |
0.88 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 = 1925;
|
| 97 |
0.80 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 = 14662;
|
| 98 |
0.78 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 = 14663;
|
| 99 |
0.92 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 = 14664;
|
| 100 |
0.85 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 = 14665;
|
| 101 |
0.75 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 = 14666;
|
| 102 |
0.70 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 = 14667;
|
| 103 |
0.69 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 = 14668;
|
| 104 |
0.69 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 = 14669;
|
| 105 |
0.64 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 = 1926;
|
| 106 |
0.51 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 = 14670;
|
| 107 |
0.45 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 = 14671;
|
| 108 |
0.56 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 = 14672;
|
| 109 |
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 = 14673;
|
| 110 |
0.45 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 = 14674;
|
| 111 |
0.50 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 = 14675;
|
| 112 |
0.51 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 = 14676;
|
| 113 |
0.54 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 = 14677;
|
| 114 |
0.57 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 = 1927;
|
| 115 |
0.52 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 = 14678;
|
| 116 |
0.50 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 = 14679;
|
| 117 |
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 = 14680;
|
| 118 |
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 = 14681;
|
| 119 |
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 = 14682;
|
| 120 |
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 = 14683;
|
| 121 |
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 = 14684;
|
| 122 |
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 = 14685;
|
| 123 |
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 = 14686;
|
| 124 |
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 = 14687;
|
| 125 |
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 = 14688;
|
| 126 |
0.33 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 = 3037;
|
| 127 |
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 = 27797;
|
| 128 |
0.34 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 = 27798;
|
| 129 |
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 = 27799;
|
| 130 |
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 = 27800;
|
| 131 |
0.34 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 = 3038;
|
| 132 |
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 = 27801;
|
| 133 |
0.34 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 = 27802;
|
| 134 |
0.34 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 = 27803;
|
| 135 |
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 = 27804;
|
| 136 |
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 = 27805;
|
| 137 |
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 = 27806;
|
| 138 |
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 = 27807;
|
| 139 |
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 = 27808;
|
| 140 |
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.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 = 3128;
|
| 141 |
0.51 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 = 28335;
|
| 142 |
0.46 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 = 28336;
|
| 143 |
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 = 28337;
|
| 144 |
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 = 28338;
|
| 145 |
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 = 28339;
|
| 146 |
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 = 28340;
|
| 147 |
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 = 28341;
|
| 148 |
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 = 28342;
|
| 149 |
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.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 = 3269;
|
| 150 |
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 = 30298;
|
| 151 |
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 = 30299;
|
| 152 |
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 = 30300;
|
| 153 |
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 = 30301;
|
| 154 |
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 = 30302;
|
| 155 |
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 = 30303;
|
| 156 |
0.41 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 = 3270;
|
| 157 |
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 = 30304;
|
| 158 |
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 = 30305;
|
| 159 |
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 = 30306;
|
| 160 |
0.34 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 = 30307;
|
| 161 |
0.35 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 = 30308;
|
| 162 |
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 = 30309;
|
| 163 |
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 = 30310;
|
| 164 |
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 = 30311;
|
| 165 |
0.41 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 = 3563;
|
| 166 |
0.51 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 = 31977;
|
| 167 |
0.87 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 = 31978;
|
| 168 |
0.79 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 = 31979;
|
| 169 |
0.86 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 = 31980;
|
| 170 |
0.96 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 = 31981;
|
| 171 |
1.04 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 = 31982;
|
| 172 |
0.97 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 = 31983;
|
| 173 |
0.74 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 = 31984;
|
| 174 |
0.57 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 = 31985;
|
| 175 |
0.73 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 = 82;
|
| 176 |
0.89 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 = 83;
|