SQL for the Proten-Verb-Protein Pattern

SELECT lql.p1, lql.verb, lql.p2, COUNT(*) AS cnt
FROM (
   SELECT p1.content AS p1, verb_biotext_annotation_word_1.word AS verb, p2.content AS p2
FROM BIOTEXT_ANNOTATION table_1
JOIN BIOTEXT_ANNOTATION table_2 ON
   table_1.pmid = table_2.pmid AND
   table_1.section = table_2.section AND
   table_1.sentence = table_2.sentence AND
   table_1.first_word_pos <= table_2.first_word_pos
JOIN BIOTEXT_ANNOTATION table_3 ON
   table_1.pmid = table_3.pmid AND
   table_1.section = table_3.section AND
   table_1.sentence = table_3.sentence AND
   table_2.first_word_pos <= table_3.first_word_pos AND
   table_2.last_word_pos = table_3.last_word_pos
JOIN BIOTEXT_ANNOTATION p1 ON
   table_1.pmid = p1.pmid AND
   table_1.section = p1.section AND
   table_1.sentence = p1.sentence AND
   table_3.first_word_pos = p1.first_word_pos AND
   table_3.last_word_pos = p1.last_word_pos
JOIN BIOTEXT_ANNOTATION verb ON
   table_1.pmid = verb.pmid AND
   table_1.section = verb.section AND
   table_1.sentence = verb.sentence AND
   table_2.last_word_pos <= verb.first_word_pos
JOIN BIOTEXT_ANNOTATION table_4 ON
   table_1.pmid = table_4.pmid AND
   table_1.section = table_4.section AND
   table_1.sentence = table_4.sentence AND
   verb.last_word_pos <= table_4.first_word_pos AND
   table_1.last_word_pos >= table_4.last_word_pos
JOIN BIOTEXT_ANNOTATION p2 ON
   table_1.pmid = p2.pmid AND
   table_1.section = p2.section AND
   table_1.sentence = p2.sentence AND
   table_4.first_word_pos <= p2.first_word_pos AND
   table_4.last_word_pos = p2.last_word_pos
JOIN BIOTEXT_ANNOTATION table_5 ON
   table_1.pmid = table_5.pmid AND
   table_1.section = table_5.section AND
   table_1.sentence = table_5.sentence AND
   p2.first_word_pos = table_5.first_word_pos AND
   p2.last_word_pos = table_5.last_word_pos
JOIN biotext_annotation_word verb_biotext_annotation_word_1 ON verb.word_id = verb_biotext_annotation_word_1.word_id
WHERE table_1.layer_id = 4
   AND (table_2.layer_id = 3 AND table_2.tag_type IN (31, 1031))
   AND table_3.layer_id = 5
   AND (p1.layer_id = 6 AND p1.tag_type IN (36, 185, 199, 205, 209, 213, 226, 252, 254, 324, 325, 331, 418, 509, 510, 511, 514, 515, 521, 682, 683, 684, 685, 727, 803, 804, 805, 808, 809, 815, 952, 979, 990, 991, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1059, 1091, 1092, 1093, 1094, 1127, 1141, 1189, 1212, 1360, 1400, 1425, 1426, 1429, 1436, 1457, 1536, 1579, 1609, 1613, 1615, 1620, 1779, 1798, 1839, 1920, 2096, 2097, 2116, 2134, 2135, 2147, 2148, 2155, 2263, 2272, 2336, 2352, 2364, 2373, 2556, 2570, 2766, 2786, 2790, 2843, 2864, 2868, 2914, 2966, 3026, 3087, 3089, 3094, 3115, 3165, 3166, 3169, 3172, 3173, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3207, 3208, 3285, 3346, 3450, 3459, 3573, 3574, 3575, 3576, 3577, 3580, 3598, 3701, 3746, 3852, 3893, 4044, 4268, 4398, 4399, 4527, 4549, 4600, 4676, 4723, 4743, 4744, 4745, 4902, 4921, 5136, 5164, 5165, 5167, 5169, 5170, 5172, 5174, 5176, 5288, 5293, 5319, 5326, 5337, 5338, 5339, 5340, 5344, 5345, 5349, 5353, 5408, 5418, 5420, 5656, 5719, 5749, 5752, 5755, 5780, 5903, 5904, 5914, 5916, 5934, 5967, 5983, 6021, 6023, 6063, 6064, 6180, 6242, 6360, 6420, 6422, 6433, 6441, 6442, 6443, 6444, 6446, 6447, 6448, 6449, 6451, 6454, 6455, 6466, 6485, 6570, 6609, 6657, 7070, 7071, 7072, 7073, 7074, 7075, 7127, 7128, 7133, 7135, 7136, 7137, 7138, 7139, 7140, 7141, 7142, 7143, 7144, 7145, 7146, 7147, 7148, 7149, 7162, 7265, 7334, 7335, 7370, 7371, 7372, 7377, 7381, 7437, 7467, 7473, 7506, 7527, 7610, 7611, 7633, 7704, 7768, 7781, 7782, 7797, 7874, 7987, 8073, 8074, 8075, 8076, 8077, 8078, 8079, 8084, 8164, 8236, 8259, 8562, 8565, 8667, 8668, 8705, 8706, 8786, 8840, 8868, 8869, 8894, 8983, 9004, 9037, 9074, 9075, 9076, 9077, 9088, 9124, 9185, 9194, 9211, 9218, 9353, 9363, 9414, 9418, 9419, 9478, 9479, 9481, 9496, 9632, 9687, 9698, 9707, 9856, 9895, 9961, 10047, 10059, 10086, 10108, 10121, 10191, 10266, 10320, 10444, 10445, 10448, 10451, 10454, 10457, 10461, 10750, 10774, 10798, 10799, 10803, 10834, 10835, 10905, 10906, 10928, 10940, 10958, 10959, 10970, 10972, 10977, 10978, 10980, 10982, 11043, 11228, 11257, 11265, 11266, 11267, 11268, 11288, 11328, 11333, 11347, 11376, 11384, 11389, 11390, 11414, 11415, 11416, 11479, 11486, 11492, 11498, 11506, 11508, 11509, 11510, 11516, 11518, 11750, 11938, 11941, 11942, 11943, 11944, 11945, 11946, 11947, 11948, 11949, 11950, 11951, 11952, 11953, 11954, 11955, 11956, 11957, 11958, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 11969, 11970, 11971, 11972, 11973, 11974, 11975, 11976, 11978, 11979, 11980, 11981, 11982, 11983, 11985, 11986, 11987, 11988, 11989, 11990, 11991, 11993, 11994, 12097, 12155, 12177, 12191, 12194, 12234, 12243, 12261, 12269, 12276, 12416, 12471, 12473, 12596, 12633, 12635, 12709, 12710, 12711, 12712, 12738, 12795, 12808, 12836, 13002, 13004, 13007, 13049, 13205, 13250, 13252, 13253, 13254, 13255, 13373, 13435, 13668, 13879, 13917, 13925, 13926, 13947, 13954, 13973, 13975, 14155, 14156, 14157, 14168, 14332, 14333, 14335, 14336, 14358, 14359, 14360, 14404, 14409, 14446, 14452, 14598, 14614, 14643, 14660, 14667, 14668, 14674, 14746, 14758, 14759, 14760, 14763, 14764, 14809, 14819, 14841, 14909, 15028, 15090, 15220, 15221, 15222, 15241, 15243, 15286, 15287, 15288, 15293, 15320, 15375, 15379, 15380, 15381, 15382, 15387, 15513, 15514, 15520, 15534, 15675, 15676, 15678, 15681, 15682, 15683, 15684, 15685, 15686, 15688, 15689, 15693, 15694, 15696, 15699, 15700, 15704, 15707, 15718, 15728, 15740, 15786, 15800, 15801, 15815, 15816, 15820, 15843, 15844, 15849, 15852, 15879, 15891, 15922, 15923, 15926, 15932, 15933, 15934, 15935, 15936, 15937, 15938, 15942, 15943, 15944, 15945, 15949, 15951, 15956, 15977, 15978, 16023, 16024, 16028, 16029, 16044, 16159, 16160, 16167, 16169, 16173, 16177, 16178, 16179, 16184, 16185, 16186, 16187, 16188, 16189, 16194, 16197, 16198, 16200, 16201, 16203, 16213, 16229, 16271, 16274, 16281, 16283, 16315, 16326, 16328, 16329, 16333, 16336, 16340, 16346, 16356, 16370, 16374, 16392, 16547, 16554, 16564, 16596, 16601, 16608, 16623, 16632, 16633, 16655, 16667, 16692, 16693, 16704, 16708, 16755, 16756, 16759, 16760, 16761, 16853, 16860, 16875, 16898, 16899, 16900, 17231, 17232, 17242, 17244, 17260, 17270, 17293, 17299, 17302, 17304, 17305, 17306, 17310, 17314, 17317, 17318, 17358, 17361, 17362, 17375, 17376, 17395, 17396, 17405, 17411, 17412, 17413, 17414, 17415, 17430, 17447, 17448, 17450, 17451, 17452, 17455, 17456, 17457, 17458, 17459, 17461, 17463, 17464, 17465, 17466, 17467, 17468, 17469, 17470, 17471, 17472, 17473, 17474, 17475, 17476, 17478, 17479, 17480, 17481, 17482, 17483, 17487, 17489, 17494, 17498, 17500, 17501, 17502, 17503, 17504, 17526, 17527, 17570, 17630, 17660, 17661, 17874, 17920, 17923, 17936, 17937, 17978, 17981, 17982, 17983, 18000, 18002, 18003, 18004, 18005, 18006, 18008, 18009, 18010, 18013, 18015, 18016, 18017, 18019, 18025, 18026, 18027, 18028, 18029, 18031, 18035, 18039, 18040, 18041, 18042, 18043, 18045, 18046, 18047, 18048, 18055, 18077, 18078, 18079, 18080, 18091, 18092, 18094, 18100, 18102, 18106, 18110, 18118, 18121, 18123, 18124, 18125, 18160, 18161, 18167, 18168, 18171, 18179, 18180, 18260, 18271, 18272, 18336, 18340, 18341, 18342, 18343, 18396, 18398, 18435, 18528, 18620, 18621, 18622, 18631, 18719, 18739, 18774, 18797, 18799, 18800, 18808, 18809, 18821, 18822, 18823, 18828, 18829, 18830, 18832, 18833, 18834, 18835, 18837, 18838, 18840, 18841, 18844, 18847, 18950, 18955, 18957, 18958, 18960, 18968, 18969, 18970, 18971, 18972, 18974, 18975, 18976, 18991, 18992, 18993, 18994, 18995, 18996, 18997, 18998, 19002, 19004, 19005, 19006, 19007, 19009, 19010, 19012, 19014, 19030, 19038, 19039, 19040, 19041, 19056, 19062, 19063, 19087, 19096, 19159, 19204, 19205, 19206, 19208, 19209, 19210, 19253, 19267, 19302, 19313, 19321, 19322, 19362, 19363, 19374, 19375, 19376, 19378, 19388, 19389, 19390, 19392, 19393, 19394, 19405, 19408, 19427, 19434, 19444, 19473, 19474, 19475, 19476, 19485, 19590, 19679, 19699, 19700, 19707, 19713, 19718, 19728, 19809, 19812, 19824, 19825, 19831, 19835, 19837, 19843, 19859, 19860, 19886, 19908, 19922, 19925, 19926, 19927, 19938, 19941, 19947, 19948, 20033, 20066, 20097, 20104, 20107, 20168, 20283, 20346, 20394, 20395, 20409, 20410, 20418, 20543, 20555, 20559, 20569, 20572, 20574, 20575, 20598, 20626, 20648, 20652, 20653, 20659, 20662, 20663, 20664, 20666, 20668, 20672, 20687, 20690, 20691, 20692, 20693, 20695, 20696, 20703, 20710, 20717, 20718, 20725, 20726, 20727, 20729, 20730, 20735, 20736, 20740, 20741, 20742, 20743, 20744, 20746, 20747, 20755, 20756, 20761, 20764, 20794, 20796, 20797, 20800, 20801, 20812, 20813, 20815, 20823, 20825, 20826, 20827, 20830, 20837, 20839, 20846, 20848, 20864, 20865, 20875, 20880, 20881, 20885, 20890, 20893, 20904, 20907, 20908, 20917, 20931, 20932, 20933, 20934, 20962, 20963, 21122, 21301, 21302, 21322, 21341, 21343, 21983, 22021, 22041, 22061, 22461, 22462, 22702, 22721, 22762, 22763, 22782, 22801, 23062, 23063, 23081, 23201, 24001, 24002, 24003, 24021, 24022, 24041, 24042, 24043, 24061, 24062, 24081, 24082, 24101, 24102, 24121, 24141, 24142, 24143, 24161, 24181, 24241, 24242, 24243, 24261, 24461, 24462, 24501, 24507, 24642, 24661, 24681, 24682, 24683, 24701, 24722, 24723, 24743, 24744, 24745, 25102, 25121, 25222, 25243, 25261, 25262, 25521, 25541, 25542, 25581, 25601, 25602, 25603, 25604, 25721, 25741, 25742, 25743, 25764, 25765, 25801, 25803, 25821, 25822, 25841, 25842, 26122, 26161, 26281, 26341, 26342, 26362, 26502, 26503, 26561, 26563, 26901, 26905, 26921, 26922, 26923, 26924, 26962, 27062, 27182, 27201, 27202, 27241, 27261, 27282, 27283, 27301, 27321, 27322, 27341, 27342, 27361, 27362, 27381, 27384, 27425, 27501, 27682, 27701, 27702, 27847, 27961, 27963, 27981, 27982, 28021, 28044, 28061, 28081, 28322, 28341, 28861, 28884, 28901, 28961, 29362, 29363, 29365, 29382, 29404, 29543, 29563, 29584, 29589, 29607, 29681, 29701, 29702, 29721, 29742, 29845, 29867, 29941, 29961, 29968, 30161, 30162, 30201, 30262, 30301, 30501, 33681, 33701, 33702, 33703, 33704, 33705, 33721, 33722, 33741, 33742, 33781, 33862, 33863, 33881, 33882, 33901, 33902, 33903, 33921, 33922, 33941, 33942, 33961, 33962, 33963, 33964, 33965, 33966, 33981, 33982, 33983, 34001, 34002, 34021, 34041, 34281, 34284, 34285, 34286, 34441, 34481, 34482, 34501, 34502, 34521, 34541, 34641, 34664, 34702, 34722, 34743, 34761, 34781, 34802, 34882, 34904, 34921, 34961, 34982, 35001, 35021, 35165, 35181, 35182, 35321, 35341, 35361, 35362, 35381, 35463, 35561, 35581, 35582, 35602, 35925, 35941, 35942, 36022, 36081, 36082, 36104, 36121, 36122, 36123, 36124, 36141, 36143, 36183, 36201, 36223, 36224, 36225, 36261, 36341, 36342, 36382, 36383, 36384, 36385, 36386, 36387, 36388, 36389, 36781, 36961, 37021, 37042, 37102, 37121, 37161, 37181, 37222, 37241, 37263, 37281, 37282, 37483, 37501, 37502, 37541, 37601, 37661, 37662, 37663, 37701, 37721, 38201, 38202, 38203, 38204, 38205, 38206, 38207, 38221, 38222, 38224, 38225, 38226, 38281, 38601, 38681, 38702, 38941, 38981, 38982, 39001, 39041, 39081, 39102, 39103, 39121, 39122, 39161, 39181, 39201, 39221, 39222, 39223, 39241, 39302, 39341, 39381, 39421, 39422, 39423, 39441, 39481, 39482, 39502, 39503, 39521, 39561, 39562, 39564, 39601, 39603, 39621, 39641, 39642, 39661, 39662, 39663, 39665, 39841, 39842, 39861, 39881, 39921, 39942, 39943, 39961, 40061, 40121, 40201, 40262, 40281, 40301, 40321, 40501, 40502, 40881))
   AND ((verb.layer_id = 1 AND verb.tag_type IN (53, 54, 55, 56, 57, 58, 1053, 1054, 1055, 1056, 1057, 1058)) AND ((verb.word_id IN (13438, 1401267, 1704480, 1837370, 1368480, 1395664, 13439, 18300, 1430513, 685368, 1741812, 1701778, 1340645, 1631134, 1132586, 291546, 1822280, 173301, 13440, 776601, 1560108, 1625212, 1740820, 1385307, 841475, 200102, 497953, 950554, 711830, 799005, 1516888, 641725, 1054225, 1159279, 1809935, 501904, 733023, 1159280, 13441, 1352215, 1680196, 1711807, 1791082, 778210, 1041124, 1567429, 315488, 632663, 868369, 903049, 1819793, 159279, 13442, 1137580, 1429059, 1490034) OR verb.word_id IN (55584, 1287422, 492858, 1333491, 642430, 486130, 1597803, 1733772, 1427784, 132755, 1497343, 821336, 55585, 578153, 310310, 375787, 790326, 671810, 215852, 55586, 1380966, 1411468, 1718409, 1536878, 1348101, 535532, 1493083, 203048, 912589, 471713, 990054, 664554, 1671707, 150639, 1291320, 55587, 58238, 1035152, 1163393, 1734845, 1023721, 55588, 55589, 58239, 1334490, 478798, 1520510, 568192, 595670, 1599821, 876702, 1633958, 1212944, 126964, 55590, 1506222, 750803, 214950, 1319808, 1628470, 1263661, 990126, 1505075, 282531, 473463, 1108028, 494442, 857399, 1157753, 1591570, 909932, 784684, 193272, 657898, 1179671, 1707728, 1050449, 1584710, 1436334, 1252251, 595207, 1601729, 854770, 977536, 931825, 547824, 1074573, 942961, 1793275, 1658831, 548689, 1259031, 954718, 510792, 1201275, 961955, 702888, 1783230, 811807, 1446418, 1174529, 207405, 448593, 157985, 1405148, 208875, 55591, 619167, 1760162, 662163, 55592, 306832, 581599, 452670, 986341, 1710550, 55593, 58240, 1401551, 816838, 1270702, 551741, 722957, 567135, 674865, 685052, 1604253, 841845, 518478, 395451, 630926, 657063, 1303137, 1373157, 507408, 200073, 160650, 996238, 337383, 863361, 1423886, 1514962, 897583, 615271, 437767, 1405224, 1345411, 270299, 55594, 692430, 1500019, 1477162, 747090, 1821325, 209870, 235038, 1150235, 1783236, 1664611, 1656543, 1159514, 936014, 55595, 495229, 1583521, 1033259, 667000, 55596, 1051530, 1280257, 521652, 1586983, 690598, 55597, 55598, 394126, 251005, 1072743, 415383, 364449, 171679, 1197022, 200471, 1681865, 260371, 1260331, 540730, 666998, 55599, 516739, 1703355, 1381580, 142653, 1043462, 1719824, 704262, 1324493, 533465, 283057, 1381387, 55600, 188506, 1376806, 339321, 511925, 714474, 1268297, 1012299, 244765, 1472247, 231865, 640443, 573710, 860760, 140183, 651563, 1353203, 1169091, 884413, 1351164, 55601, 1423641, 871656, 348016, 1811386, 533472, 713096, 1696806, 1791143, 1819254, 1576624, 1517413, 1639599, 1282394, 1272832, 439035, 1519194, 1362450, 822203, 339630, 684582, 947095, 335100, 1200904, 506617, 1320881, 921176, 595022, 1812300, 1262839, 913020, 645981, 1324646, 55602, 533130, 450410, 55603, 121630, 156752, 728684, 1650177, 55604, 614813, 329415, 1494435, 1238025, 1626748, 1344347, 277029, 1661287, 348007, 348012, 1350365, 1246856, 1354500, 869202, 1715546, 157804, 1603459, 799516, 932977, 1551689, 616847, 1831160, 412207, 1269542, 1777594, 1771073, 1587823, 466499, 1611217, 1137995, 339147, 1044812, 1749421, 1359472, 698317, 1536017, 1810369, 724155, 1817612, 1542069, 1649689, 566343, 1508531, 569093, 1229530, 1182181, 973576, 352179, 1459235, 1080236, 1372659, 1372643, 1227961, 1147943, 953032, 1500789, 1577613, 580981, 598095, 1595577, 1534579, 55605, 1400880, 705765, 698319, 447040, 634358, 647728, 133185, 1119629, 1119630, 329310, 965946, 1599421, 385745, 55606, 58241, 1230750, 1034268, 796983, 414606, 1480713, 1270685, 1187999, 299165, 1686658, 434864, 1188003, 574176, 1608622, 1508500, 1493004, 223167, 1047762, 390250, 1565258, 1289396, 1027141, 1047061, 1257872, 558774, 883617, 1276736, 1218178, 634199, 1101766, 1270665, 1402042, 717481, 1327303, 1043559, 1652923, 462273, 1082528, 1362746, 1257856, 1807734, 461443, 928557, 1239560, 1760737, 1188663, 1521031, 1699442, 1257854, 577581, 1024236, 1457002, 1598771, 1337792, 1298667, 1841244, 1416595, 1134661, 1823263, 149817, 819182, 1205140, 1108619, 399451, 1727186, 1272754, 1835327, 1835326, 1780734, 718271, 726222, 825546, 437910, 860488, 1782468, 523773, 132785, 1783226, 1218551, 1804881, 476254, 705763, 899443, 1171042, 1171043, 55607, 58242, 1762689, 1762690, 1442800, 1732557, 1214162, 1037602, 1527214, 258358, 1272523, 1546678, 605837, 1154285, 277231, 795836, 1278784, 227197, 1436298, 641265, 700945, 398101, 1497603, 1498217, 1840852, 798808, 1684339, 1453720, 55608, 1733409, 706589)) OR verb.word_id IN (21770, 1233710, 1483592, 1401661, 1535086, 1142508, 679829, 948586, 1582423, 1450050, 518585, 733807, 378597, 378602, 760782, 238839, 569910, 21771, 23815, 1540144, 989402, 235144, 834922, 21772, 1567213, 1127825, 1065840, 985146, 1671071, 436071, 995016, 1406960, 21773, 23816, 1016699, 1713082, 981970, 1770408, 1027133, 558711, 664423, 871795, 1032934, 1618581, 168161, 1760534, 955132, 1511109, 1134383, 466313, 738823, 597883, 1179279, 932540, 948627, 1121387, 520216, 1530858, 1774364, 1567361, 882914, 632401, 23817, 663194, 168158, 949540, 318661, 21774, 849928, 789007, 1021125, 1693902, 891149, 1776453, 345505, 1261646, 594291, 747115, 1798194, 1803828, 704909, 1196665, 963827, 1785072, 355065, 226259, 277045, 719216, 1079151, 602348, 1497429, 744606, 1093410, 844539, 668555, 1444975, 1290892, 1607269, 1432769, 1248887, 783593, 755975, 1546218, 1382512, 466323, 348319, 982706, 801473, 1382831, 1171036, 366356, 526625, 402707, 256037, 1371560, 578379, 1755995, 1768850, 1629153, 21775, 1127242, 610082, 547061, 1306546, 21776, 1273158, 481147, 802521, 941325, 1273641, 1806321, 1790377, 1417570, 379296, 373286, 1134896, 1359384, 1540121, 890488, 1551510, 155910, 800572, 933655, 580781, 556797, 1226575, 1353498, 1107314, 1117420, 331949, 808921, 1769503, 1563026, 396522, 396507, 1611911, 821360, 834858, 990094, 1163966, 556292, 850497, 672162, 1498082, 1606648, 745906, 1655600, 1612870, 374885, 21777, 1653013, 21778, 1268550, 504579, 1284880, 979636, 609234, 800573, 1274910, 214889, 672424, 21779, 805561, 827506, 1192914, 952055, 1220302, 782844, 782838, 1313241, 21780, 1010958, 604825, 861579, 1395381, 837303, 747530, 1077965, 354557, 235585, 21781, 595566, 21782, 1751683, 1436040, 1313272, 1041639, 1767576, 1767572, 370145, 370146)))
   AND (table_4.layer_id = 3 AND table_4.tag_type IN (31, 1031))
   AND (p2.layer_id = 6 AND p2.tag_type IN (36, 185, 199, 205, 209, 213, 226, 252, 254, 324, 325, 331, 418, 509, 510, 511, 514, 515, 521, 682, 683, 684, 685, 727, 803, 804, 805, 808, 809, 815, 952, 979, 990, 991, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1059, 1091, 1092, 1093, 1094, 1127, 1141, 1189, 1212, 1360, 1400, 1425, 1426, 1429, 1436, 1457, 1536, 1579, 1609, 1613, 1615, 1620, 1779, 1798, 1839, 1920, 2096, 2097, 2116, 2134, 2135, 2147, 2148, 2155, 2263, 2272, 2336, 2352, 2364, 2373, 2556, 2570, 2766, 2786, 2790, 2843, 2864, 2868, 2914, 2966, 3026, 3087, 3089, 3094, 3115, 3165, 3166, 3169, 3172, 3173, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3207, 3208, 3285, 3346, 3450, 3459, 3573, 3574, 3575, 3576, 3577, 3580, 3598, 3701, 3746, 3852, 3893, 4044, 4268, 4398, 4399, 4527, 4549, 4600, 4676, 4723, 4743, 4744, 4745, 4902, 4921, 5136, 5164, 5165, 5167, 5169, 5170, 5172, 5174, 5176, 5288, 5293, 5319, 5326, 5337, 5338, 5339, 5340, 5344, 5345, 5349, 5353, 5408, 5418, 5420, 5656, 5719, 5749, 5752, 5755, 5780, 5903, 5904, 5914, 5916, 5934, 5967, 5983, 6021, 6023, 6063, 6064, 6180, 6242, 6360, 6420, 6422, 6433, 6441, 6442, 6443, 6444, 6446, 6447, 6448, 6449, 6451, 6454, 6455, 6466, 6485, 6570, 6609, 6657, 7070, 7071, 7072, 7073, 7074, 7075, 7127, 7128, 7133, 7135, 7136, 7137, 7138, 7139, 7140, 7141, 7142, 7143, 7144, 7145, 7146, 7147, 7148, 7149, 7162, 7265, 7334, 7335, 7370, 7371, 7372, 7377, 7381, 7437, 7467, 7473, 7506, 7527, 7610, 7611, 7633, 7704, 7768, 7781, 7782, 7797, 7874, 7987, 8073, 8074, 8075, 8076, 8077, 8078, 8079, 8084, 8164, 8236, 8259, 8562, 8565, 8667, 8668, 8705, 8706, 8786, 8840, 8868, 8869, 8894, 8983, 9004, 9037, 9074, 9075, 9076, 9077, 9088, 9124, 9185, 9194, 9211, 9218, 9353, 9363, 9414, 9418, 9419, 9478, 9479, 9481, 9496, 9632, 9687, 9698, 9707, 9856, 9895, 9961, 10047, 10059, 10086, 10108, 10121, 10191, 10266, 10320, 10444, 10445, 10448, 10451, 10454, 10457, 10461, 10750, 10774, 10798, 10799, 10803, 10834, 10835, 10905, 10906, 10928, 10940, 10958, 10959, 10970, 10972, 10977, 10978, 10980, 10982, 11043, 11228, 11257, 11265, 11266, 11267, 11268, 11288, 11328, 11333, 11347, 11376, 11384, 11389, 11390, 11414, 11415, 11416, 11479, 11486, 11492, 11498, 11506, 11508, 11509, 11510, 11516, 11518, 11750, 11938, 11941, 11942, 11943, 11944, 11945, 11946, 11947, 11948, 11949, 11950, 11951, 11952, 11953, 11954, 11955, 11956, 11957, 11958, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 11969, 11970, 11971, 11972, 11973, 11974, 11975, 11976, 11978, 11979, 11980, 11981, 11982, 11983, 11985, 11986, 11987, 11988, 11989, 11990, 11991, 11993, 11994, 12097, 12155, 12177, 12191, 12194, 12234, 12243, 12261, 12269, 12276, 12416, 12471, 12473, 12596, 12633, 12635, 12709, 12710, 12711, 12712, 12738, 12795, 12808, 12836, 13002, 13004, 13007, 13049, 13205, 13250, 13252, 13253, 13254, 13255, 13373, 13435, 13668, 13879, 13917, 13925, 13926, 13947, 13954, 13973, 13975, 14155, 14156, 14157, 14168, 14332, 14333, 14335, 14336, 14358, 14359, 14360, 14404, 14409, 14446, 14452, 14598, 14614, 14643, 14660, 14667, 14668, 14674, 14746, 14758, 14759, 14760, 14763, 14764, 14809, 14819, 14841, 14909, 15028, 15090, 15220, 15221, 15222, 15241, 15243, 15286, 15287, 15288, 15293, 15320, 15375, 15379, 15380, 15381, 15382, 15387, 15513, 15514, 15520, 15534, 15675, 15676, 15678, 15681, 15682, 15683, 15684, 15685, 15686, 15688, 15689, 15693, 15694, 15696, 15699, 15700, 15704, 15707, 15718, 15728, 15740, 15786, 15800, 15801, 15815, 15816, 15820, 15843, 15844, 15849, 15852, 15879, 15891, 15922, 15923, 15926, 15932, 15933, 15934, 15935, 15936, 15937, 15938, 15942, 15943, 15944, 15945, 15949, 15951, 15956, 15977, 15978, 16023, 16024, 16028, 16029, 16044, 16159, 16160, 16167, 16169, 16173, 16177, 16178, 16179, 16184, 16185, 16186, 16187, 16188, 16189, 16194, 16197, 16198, 16200, 16201, 16203, 16213, 16229, 16271, 16274, 16281, 16283, 16315, 16326, 16328, 16329, 16333, 16336, 16340, 16346, 16356, 16370, 16374, 16392, 16547, 16554, 16564, 16596, 16601, 16608, 16623, 16632, 16633, 16655, 16667, 16692, 16693, 16704, 16708, 16755, 16756, 16759, 16760, 16761, 16853, 16860, 16875, 16898, 16899, 16900, 17231, 17232, 17242, 17244, 17260, 17270, 17293, 17299, 17302, 17304, 17305, 17306, 17310, 17314, 17317, 17318, 17358, 17361, 17362, 17375, 17376, 17395, 17396, 17405, 17411, 17412, 17413, 17414, 17415, 17430, 17447, 17448, 17450, 17451, 17452, 17455, 17456, 17457, 17458, 17459, 17461, 17463, 17464, 17465, 17466, 17467, 17468, 17469, 17470, 17471, 17472, 17473, 17474, 17475, 17476, 17478, 17479, 17480, 17481, 17482, 17483, 17487, 17489, 17494, 17498, 17500, 17501, 17502, 17503, 17504, 17526, 17527, 17570, 17630, 17660, 17661, 17874, 17920, 17923, 17936, 17937, 17978, 17981, 17982, 17983, 18000, 18002, 18003, 18004, 18005, 18006, 18008, 18009, 18010, 18013, 18015, 18016, 18017, 18019, 18025, 18026, 18027, 18028, 18029, 18031, 18035, 18039, 18040, 18041, 18042, 18043, 18045, 18046, 18047, 18048, 18055, 18077, 18078, 18079, 18080, 18091, 18092, 18094, 18100, 18102, 18106, 18110, 18118, 18121, 18123, 18124, 18125, 18160, 18161, 18167, 18168, 18171, 18179, 18180, 18260, 18271, 18272, 18336, 18340, 18341, 18342, 18343, 18396, 18398, 18435, 18528, 18620, 18621, 18622, 18631, 18719, 18739, 18774, 18797, 18799, 18800, 18808, 18809, 18821, 18822, 18823, 18828, 18829, 18830, 18832, 18833, 18834, 18835, 18837, 18838, 18840, 18841, 18844, 18847, 18950, 18955, 18957, 18958, 18960, 18968, 18969, 18970, 18971, 18972, 18974, 18975, 18976, 18991, 18992, 18993, 18994, 18995, 18996, 18997, 18998, 19002, 19004, 19005, 19006, 19007, 19009, 19010, 19012, 19014, 19030, 19038, 19039, 19040, 19041, 19056, 19062, 19063, 19087, 19096, 19159, 19204, 19205, 19206, 19208, 19209, 19210, 19253, 19267, 19302, 19313, 19321, 19322, 19362, 19363, 19374, 19375, 19376, 19378, 19388, 19389, 19390, 19392, 19393, 19394, 19405, 19408, 19427, 19434, 19444, 19473, 19474, 19475, 19476, 19485, 19590, 19679, 19699, 19700, 19707, 19713, 19718, 19728, 19809, 19812, 19824, 19825, 19831, 19835, 19837, 19843, 19859, 19860, 19886, 19908, 19922, 19925, 19926, 19927, 19938, 19941, 19947, 19948, 20033, 20066, 20097, 20104, 20107, 20168, 20283, 20346, 20394, 20395, 20409, 20410, 20418, 20543, 20555, 20559, 20569, 20572, 20574, 20575, 20598, 20626, 20648, 20652, 20653, 20659, 20662, 20663, 20664, 20666, 20668, 20672, 20687, 20690, 20691, 20692, 20693, 20695, 20696, 20703, 20710, 20717, 20718, 20725, 20726, 20727, 20729, 20730, 20735, 20736, 20740, 20741, 20742, 20743, 20744, 20746, 20747, 20755, 20756, 20761, 20764, 20794, 20796, 20797, 20800, 20801, 20812, 20813, 20815, 20823, 20825, 20826, 20827, 20830, 20837, 20839, 20846, 20848, 20864, 20865, 20875, 20880, 20881, 20885, 20890, 20893, 20904, 20907, 20908, 20917, 20931, 20932, 20933, 20934, 20962, 20963, 21122, 21301, 21302, 21322, 21341, 21343, 21983, 22021, 22041, 22061, 22461, 22462, 22702, 22721, 22762, 22763, 22782, 22801, 23062, 23063, 23081, 23201, 24001, 24002, 24003, 24021, 24022, 24041, 24042, 24043, 24061, 24062, 24081, 24082, 24101, 24102, 24121, 24141, 24142, 24143, 24161, 24181, 24241, 24242, 24243, 24261, 24461, 24462, 24501, 24507, 24642, 24661, 24681, 24682, 24683, 24701, 24722, 24723, 24743, 24744, 24745, 25102, 25121, 25222, 25243, 25261, 25262, 25521, 25541, 25542, 25581, 25601, 25602, 25603, 25604, 25721, 25741, 25742, 25743, 25764, 25765, 25801, 25803, 25821, 25822, 25841, 25842, 26122, 26161, 26281, 26341, 26342, 26362, 26502, 26503, 26561, 26563, 26901, 26905, 26921, 26922, 26923, 26924, 26962, 27062, 27182, 27201, 27202, 27241, 27261, 27282, 27283, 27301, 27321, 27322, 27341, 27342, 27361, 27362, 27381, 27384, 27425, 27501, 27682, 27701, 27702, 27847, 27961, 27963, 27981, 27982, 28021, 28044, 28061, 28081, 28322, 28341, 28861, 28884, 28901, 28961, 29362, 29363, 29365, 29382, 29404, 29543, 29563, 29584, 29589, 29607, 29681, 29701, 29702, 29721, 29742, 29845, 29867, 29941, 29961, 29968, 30161, 30162, 30201, 30262, 30301, 30501, 33681, 33701, 33702, 33703, 33704, 33705, 33721, 33722, 33741, 33742, 33781, 33862, 33863, 33881, 33882, 33901, 33902, 33903, 33921, 33922, 33941, 33942, 33961, 33962, 33963, 33964, 33965, 33966, 33981, 33982, 33983, 34001, 34002, 34021, 34041, 34281, 34284, 34285, 34286, 34441, 34481, 34482, 34501, 34502, 34521, 34541, 34641, 34664, 34702, 34722, 34743, 34761, 34781, 34802, 34882, 34904, 34921, 34961, 34982, 35001, 35021, 35165, 35181, 35182, 35321, 35341, 35361, 35362, 35381, 35463, 35561, 35581, 35582, 35602, 35925, 35941, 35942, 36022, 36081, 36082, 36104, 36121, 36122, 36123, 36124, 36141, 36143, 36183, 36201, 36223, 36224, 36225, 36261, 36341, 36342, 36382, 36383, 36384, 36385, 36386, 36387, 36388, 36389, 36781, 36961, 37021, 37042, 37102, 37121, 37161, 37181, 37222, 37241, 37263, 37281, 37282, 37483, 37501, 37502, 37541, 37601, 37661, 37662, 37663, 37701, 37721, 38201, 38202, 38203, 38204, 38205, 38206, 38207, 38221, 38222, 38224, 38225, 38226, 38281, 38601, 38681, 38702, 38941, 38981, 38982, 39001, 39041, 39081, 39102, 39103, 39121, 39122, 39161, 39181, 39201, 39221, 39222, 39223, 39241, 39302, 39341, 39381, 39421, 39422, 39423, 39441, 39481, 39482, 39502, 39503, 39521, 39561, 39562, 39564, 39601, 39603, 39621, 39641, 39642, 39661, 39662, 39663, 39665, 39841, 39842, 39861, 39881, 39921, 39942, 39943, 39961, 40061, 40121, 40201, 40262, 40281, 40301, 40321, 40501, 40502, 40881))
   AND table_5.layer_id = 5
) AS lql
GROUP BY lql.p1, lql.verb, lql.p2
ORDER BY cnt DESC