snippet.sql

SELECT 
    `publications_bibliographicrecord`.`id`,
    `publications_bibliographicrecord`.`publication_id`,
    `publications_bibliographicrecord`.`data_source`,
    `publications_bibliographicrecord`.`id_at_source`,
    `publications_bibliographicrecord`.`verification_status`,
    `publications_bibliographicrecord`.`times_cited`,
    `publications_bibliographicrecord`.`reference_count`,
    `publications_bibliographicrecord`.`abstract`,
    `publications_bibliographicrecord`.`associated_authors`,
    `publications_bibliographicrecord`.`authors`,
    `publications_bibliographicrecord`.`awarded_date`,
    `publications_bibliographicrecord`.`begin_page`,
    `publications_bibliographicrecord`.`book_author_type`,
    `publications_bibliographicrecord`.`commissioning_body`,
    `publications_bibliographicrecord`.`confidential`,
    `publications_bibliographicrecord`.`doi`,
    `publications_bibliographicrecord`.`edition`,
    `publications_bibliographicrecord`.`editors`,
    `publications_bibliographicrecord`.`end_page`,
    `publications_bibliographicrecord`.`filed_date`,
    `publications_bibliographicrecord`.`finish_date`,
    `publications_bibliographicrecord`.`isbn_10`,
    `publications_bibliographicrecord`.`isbn_13`,
    `publications_bibliographicrecord`.`issn`,
    `publications_bibliographicrecord`.`issue`,
    `publications_bibliographicrecord`.`journal`,
    `publications_bibliographicrecord`.`journal_article_type`,
    `publications_bibliographicrecord`.`keywords`,
    `publications_bibliographicrecord`.`language`,
    `publications_bibliographicrecord`.`location`,
    `publications_bibliographicrecord`.`medium`,
    `publications_bibliographicrecord`.`name_of_conference`,
    `publications_bibliographicrecord`.`notes`,
    `publications_bibliographicrecord`.`number`,
    `publications_bibliographicrecord`.`number_of_pages`,
    `publications_bibliographicrecord`.`number_of_pieces`,
    `publications_bibliographicrecord`.`parent_title`,
    `publications_bibliographicrecord`.`patent_number`,
    `publications_bibliographicrecord`.`patent_status`,
    `publications_bibliographicrecord`.`pii`,
    `publications_bibliographicrecord`.`place_of_publication`,
    `publications_bibliographicrecord`.`publication_date`,
    `publications_bibliographicrecord`.`publication_status`,
    `publications_bibliographicrecord`.`publisher`,
    `publications_bibliographicrecord`.`series`,
    `publications_bibliographicrecord`.`start_date`,
    `publications_bibliographicrecord`.`title`,
    `publications_bibliographicrecord`.`version`,
    `publications_bibliographicrecord`.`volume`,
    `publications_bibliographicrecord`.`number_of_authors`,
    `publications_bibliographicrecord`.`first_author`,
    `publications_bibliographicrecord`.`last_author`
FROM 
    `publications_bibliographicrecord` 
JOIN 
    `publications_authored` ON (`publications_bibliographicrecord`.`id` = `publications_authored`.`bibliographic_record_id`) 
WHERE
    `publications_authored`.`visible` = 1 AND `publications_authored`.`researcher_id` IN (
        2049, 4, 5, 9, 11, 13, 14, 2063, 16, 19, 2069, 2070, 25, 2074, 2075,
        2076, 29, 2078, 2053, 2080, 2081, 2082, 36, 37, 38, 39, 40, 46, 47, 51,
        52, 53, 55, 56, 57, 58, 62, 64, 66, 67, 70, 73, 74, 75, 80, 82, 86, 87,
        90, 92, 93, 98, 100, 101, 103, 105, 112, 113, 114, 2067, 117, 120, 123,
        125, 126, 127, 133, 138, 139, 140, 141, 142, 143, 145, 146, 148, 149,
        153, 154, 157, 158, 159, 160, 161, 166, 167, 169, 171, 172, 176, 179,
        180, 183, 187, 189, 194, 195, 200, 203, 205, 206, 208, 213, 216, 217,
        218, 219, 224, 225, 227, 228, 229, 234, 235, 237, 238, 244, 246, 247,
        252, 254, 256, 257, 259, 261, 264, 267, 268, 271, 272, 273, 274, 275,
        276, 283, 284, 287, 289, 292, 295, 296, 297, 298, 299, 303, 304, 309,
        311, 312, 313, 315, 316, 317, 320, 323, 326, 333, 335, 336, 340, 342,
        345, 346, 347, 351, 352, 354, 355, 357, 361, 365, 367, 371, 372, 377,
        378, 383, 391, 398, 401, 408, 420, 424, 428, 430, 431, 434, 435, 436,
        437, 441, 447, 448, 456, 457, 458, 468, 470, 471, 475, 476, 477, 483,
        485, 492, 493, 494, 495, 496, 497, 498, 499, 505, 513, 518, 535, 537,
        543, 548, 549, 550, 551, 552, 554, 558, 561, 569, 570, 571, 572, 577,
        588, 589, 592, 593, 595, 608, 609, 611, 614, 617, 621, 623, 625, 631,
        632, 633, 634, 637, 638, 640, 643, 648, 657, 658, 661, 662, 663, 666,
        668, 670, 675, 689, 694, 697, 705, 707, 710, 719, 720, 721, 731, 732,
        733, 734, 735, 736, 737, 742, 748, 749, 755, 756, 759, 766, 767, 776,
        777, 779, 782, 785, 789, 791, 801, 807, 808, 809, 810, 816, 818, 820,
        823, 824, 830, 836, 841, 843, 844, 845, 846, 849, 853, 854, 866, 869,
        871, 873, 874, 875, 876, 877, 878, 879, 880, 883, 901, 905, 919, 920,
        921, 928, 953, 954, 955, 956, 957, 959, 960, 961, 962, 964, 965, 966,
        967, 968, 970, 972, 973, 975, 976, 987, 991, 994, 995, 2079, 1018,
        1030, 1036, 1050, 1057, 1059, 1060, 1066, 1068, 1078, 1082, 1083, 1084,
        1088, 1098, 1101, 1109, 1111, 1121, 1131, 1132, 1136, 1147, 1149, 1151,
        1154, 1159, 1172, 1183, 1185, 1207, 1209, 1216, 1222, 1223, 1224, 1238,
        1250, 1264, 1269, 1330, 1331, 1333, 1334, 1336, 1337, 1339, 1340, 1341,
        1342, 1347, 1356, 1358, 1359, 1360, 1361, 1362, 1365, 1366, 1367, 1368,
        1370, 1372, 1376, 1380, 1381, 1396, 1413, 1415, 1416, 1417, 1419, 1420,
        1427, 1431, 1435, 1445, 1454, 1466, 1473, 1474, 1475, 1476, 1479, 1481,
        1485, 1486, 1487, 1499, 1501, 1505, 1512, 1513, 1516, 1523, 1536, 1537,
        1538, 1540, 1543, 1544, 1545, 1546, 1547, 1551, 1553, 1556, 1557, 1558,
        1563, 1564, 1565, 1568, 1575, 1576, 1577, 1578, 1580, 1581, 1586, 1590,
        1591, 1592, 1593, 1604, 1609, 1610, 1625, 1643, 1655, 1659, 1660, 1661,
        2084, 1665, 1670, 1671, 1672, 1679, 1680, 1685, 1688, 1694, 1709, 1724,
        1725, 1727, 1728, 1736, 1738, 1739, 1743, 1752, 1766, 1767, 1768, 1770,
        1771, 1776, 1778, 1779, 1781, 1782, 1788, 1793, 1795, 1798, 1799, 1800,
        1802, 1804, 1805, 1818, 1831, 1832, 1837, 1841, 1843, 1846, 1854, 1865,
        1878, 1891, 1892, 1894, 1895, 1906, 1907, 1922, 1934, 1935, 1936, 1937,
        1938, 1949, 1959, 1963, 1966, 1970, 1972, 1973, 1976, 1979, 1981, 1982,
        1983, 2000, 2001, 2004, 2006, 2008, 2016, 2018, 2019, 2020, 2021, 2023,
        2038, 2039, 2044, 2047
        )
    ) 
ORDER BY `publications_bibliographicrecord`.`publication_date` DESC 
LIMIT 5