Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Bad SQL Query taking almost 30 seconds to respond
SELECT "nodes_node"."id", "nodes_node"."alive", "nodes_node"."name", "nodes_node"."node_type", "nodes_node"."province", "nodes_node"."postal_code", "nodes_node"."attributes" FROM "nodes_node" WHERE ("nodes_node"."alive" = true AND "nodes_node"."id" IN (7, 3258, 3260, 8228, 8229, 8230, 8231, 8232, 8233, 8234, 8235, 8236, 8237, 8238, 8239, 8240, 8241, 8242, 8243, 8244, 8245, 8246, 8247, 8248, 8249, 8250, 11409, 8252, 8253, 8254, 8255, 8256, 8257, 8258, 8259, 8260, 11410, 8262, 8263, 8264, 8265, 8266, 8267, 8268, 8269, 11413, 8271, 11412, 8273, 8275, 8276, 8277, 11414, 8280, 8281, 8282, 8283, 8284, 8285, 8286, 8287, 3275, 8289, 8290, 8291, 8292, 8293, 8294, 8295, 8296, 8297, 8298, 8299, 11418, 8301, 8302, 8303, 8304, 8305, 8306, 8307, 8308, 8309, 8310, 8311, 8312, 8313, 8314, 11421, 8316, 8317, 8318, 8319, 8320, 8321, 8322, 8323, 8324, 8325, 8326, 8327, 8328, 8329, 8330, 8331, 8332, 8333, 8334, 8335, 8336, 8337, 8338, 8339, 11425, 8341, 9799, 8342, 8344, 8345, 8346, 8347, 8348, 8349, 8350, 8351, 8352, 8353, 8354, 11428, 8356, 8357, 8358, 8359, 8360, 8361, 8362, 8363, 8364, 8365, 8366, 8367, 8368, 8369, 11431, 8371, 8372, 8373, 8374, 8375, 8376, 8377, 8378, 8379, 8380, 8381, 11435, 8383, 8384, 8385, 11436, 8389, 8390, 8391, 8392, 11437, 11438, 8397, 8398, 8399, 8400, 8401, 8402, 11439, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 11444, 11445, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 11446, 253, 254, 11448, 256, 257, 11447, 259, 260, 261, 262, 263, 264, 265, 266, 267, 11450, 269, 9823, 271, 272, 273, 11452, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 9827, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 11458, 11457, 11460, 11461, 11139, 3321, 11462, 11517, 11463, 9835, 11736, 11464, 11465, 11466, 11467, 11411, 11530, 11468, 11469, 11470, 11471, 11472, 11473, 11474, 11475, 1706, 11476, 11477, 11478, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 1712, 422, 424, 425, 426, 427, 428, 429, 430, 423, 432, 433, 434, 431, 435, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 3278, 11505, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 3369, 3370, 3371, 11512, 11420, 11513, 11597, 11514, 587, 588, 589, 11515, 594, 11516, 598, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 9794, 637, 639, 640, 641, 642, 643, 644, 645, 638, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 11529, 664, 665, 666, 667, 668, 11749, 670, 671, 669, 673, 674, 675, 676, 672, 678, 677, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 11750, 3394, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 1768, 710, 8903, 11539, 713, 8906, 714, 8904, 11540, 8905, 8911, 8912, 8913, 8914, 8915, 8916, 8917, 8918, 8919, 8920, 8921, 8922, 8923, 8924, 8925, 8926, 8927, 8928, 8929, 8930, 8931, 8932, 8933, 8934, 8935, 8936, 8937, 8938, 11546, 8939, 8940, 8941, 8942, 8943, 8945, 8944, 8946, 8947, 8949, 8950, 11548, 8952, 8953, 8954, 8955, 8956, 8948, 8958, 11550, 8960, 8961, 8962, 8963, 8964, 8965, 8966, 8967, 8968, 8969, 8970, 8971, 8972, 8973, 8974, 8975, 8976, 783, 8978, 11552, 8977, 11754, 792, 793, 11555, 795, 796, 11556, 3415, 800, 802, 8996, 8997, 8998, 8999, 9000, 9001, 9002, 9003, 9004, 813, 814, 9007, 815, 9009, 817, 819, 9005, 9008, 822, 823, 9016, 825, 9017, 9018, 9020, 9019, 9021, 828, 832, 831, 834, 833, 835, 837, 11564, 838, 11756, 841, 842, 843, 11565, 844, 9038, 9039, 847, 849, 850, 11566, 852, 853, 854, 855, 856, 857, 858, 9051, 9052, 9053, 9054, 9055, 9056, 860, 9058, 9059, 9057, 9060, 870, 871, 868, 866, 874, 875, 876, 877, 878, 879, 11572, 881, 882, 883, 11573, 885, 886, 887, 888, 884, 890, 891, 892, 9085, 9086, 9087, 9088, 9089, 9084, 9091, 9092, 9093, 9094, 9095, 9096, 899, 900, 907, 908, 909, 910, 911, 11578, 9105, 913, 11579, 9108, 916, 9110, 919, 9111, 921, 922, 923, 924, 917, 9118, 9119, 928, 927, 926, 3441, 9116, 933, 934, 935, 936, 937, 9130, 939, 940, 938, 942, 11584, 3443, 945, 3444, 941, 948, 949, 950, 951, 952, 5073, 954, 9146, 955, 956, 958, 959, 960, 961, 9154, 9155, 9156, 965, 9158, 967, 968, 963, 969, 964, 9157, 973, 9166, 975, 976, 9169, 9170, 979, 9172, 9173, 9174, 9175, 981, 983, 978, 9179, 988, 989, 990, 987, 985, 993, 991, 995, 996, 997, 998, 999, 1000, 1001, 9193, 9195, 9194, 1005, 1006, 9198, 9199, 9201, 9200, 9203, 9204, 9205, 9206, 9207, 9208, 9209, 9210, 1019, 9211, 9212, 9213, 9214, 9215, 9216, 1026, 1020, 1027, 1023, 1030, 1028, 1032, 1024, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 9238, 1048, 1047, 1050, 1051, 1052, 1053, 1054, 9247, 9248, 9249, 9250, 9251, 9252, 9253, 1055, 9255, 9254, 9257, 1063, 1064, 1068, 1069, 1070, 1071, 1067, 1073, 1074, 9267, 1075, 1076, 9270, 1079, 9272, 1080, 1081, 1082, 1078, 9277, 1077, 9279, 9280, 9281, 9282, 9283, 1089, 9276, 1094, 1095, 9288, 1096, 1098, 1090, 1100, 1101, 1102, 1097, 1103, 1105, 1106, 9299, 1107, 1109, 1110, 1111, 1112, 1113, 1114, 9307, 9308, 9309, 9310, 9311, 9312, 9313, 1122, 9315, 9316, 9317, 9318, 9319, 9320, 9321, 1130, 9314, 1126, 1128, 1131, 1127, 1132, 9329, 9330, 9331, 1022, 11623, 9334, 9335, 9336, 9337, 9338, 9339, 9340, 9341, 9342, 9343, 9344, 9345, 9346, 9347, 9348, 11627, 9350, 9351, 11628, 9352, 9354, 9355, 9356, 9349, 3488, 9353, 9361, 9362, 679, 9365, 9366, 9367, 11631, 9371, 5119, 11632, 9377, 9378, 3492, 3493, 1865, 5122, 3494, 1866, 3495, 3496, 9409, 9410, 9411, 9412, 9413, 9414, 9415, 9416, 9417, 9418, 9420, 9421, 9422, 9423, 9424, 9425, 9426, 9427, 3502, 9428, 9429, 9430, 9431, 9432, 9433, 9434, 9436, 9437, 9438, 9439, 9440, 3504, 9435, 9441, 9442, 9443, 9446, 9447, 9448, 9449, 9450, 9451, 9452, 9453, 9454, 3506, 9456, 9457, 9458, 9459, 9460, 9461, 9462, 9463, 9464, 10145, 9474, 9481, 3513, 3514, 11449, 1888, 9503, 9504, 9505, 9506, 9507, 9508, 9509, 9510, 9511, 9512, 9513, 9514, 10147, 9515, 9516, 9517, 9518, 9519, 9520, 9521, 9524, 9525, 9526, 9527, 9528, 9529, 9530, 9531, 9532, 9533, 9534, 9535, 9536, 3522, 9538, 9539, 9540, 9541, 9542, 3523, 3524, 9545, 9546, 9547, 3525, 9549, 9550, 9551, 9552, 9553, 9554, 9555, 9556, 9557, 9558, 9559, 9560, 9561, 9562, 9563, 9564, 9565, 9566, 9567, 9568, 9569, 9570, 9571, 9572, 9573, 9574, 9575, 9576, 9577, 9578, 9579, 3531, 11674, 9584, 9585, 11675, 11676, 9599, 9600, 11453, 11678, 11680, 3392, 11681, 11682, 11454, 11684, 709, 11455, 11688, 291, 11690, 11692, 11456, 11693, 10805, 11694, 9177, 11751, 11131, 11695, 11696, 711, 11699, 3558, 9178, 11700, 712, 11702, 11703, 3562, 11598, 10807, 9733, 9734, 9735, 9736, 9737, 9738, 11705, 9740, 9741, 9742, 9743, 9744, 9745, 9739, 11532, 11706, 11711, 11713, 3573, 9789, 9790, 11715, 9792, 9793, 9791, 9795, 11716, 9797, 9798, 9796, 9800, 9801, 9802, 9803, 9804, 9805, 9806, 9807, 9808, 9809, 9810, 9811, 9812, 11718, 9814, 9815, 9816, 11719, 9818, 9819, 9820, 10159, 9822, 11136, 9824, 9825, 9817, 9826, 9821, 9829, 9830, 9831, 9832, 9833, 9834, 9828, 9836, 9837, 9838, 9839, 9840, 9841, 9842, 9843, 9844, 11137, 9846, 9847, 9845, 9848, 11727, 11728, 11729, 5216, 11138, 11732, 11734, 1698, 1699, 1700, 1701, 1702, 1703, 1704, 1705, 11735, 1707, 11737, 1708, 1710, 1711, 1709, 1713, 1714, 1715, 1716, 1717, 11739, 11738, 1718, 1721, 1722, 11740, 1719, 1725, 1726, 1720, 1723, 1724, 1727, 1728, 1729, 1730, 1731, 1735, 1736, 1732, 1733, 1739, 1740, 1734, 1742, 1743, 1737, 1738, 1746, 1744, 1745, 1747, 1750, 1748, 1749, 1753, 1751, 1752, 1754, 1756, 1757, 1758, 1759, 1760, 1761, 1763, 11748, 1764, 1765, 1766, 1767, 1769, 1770, 1771, 1772, 1773, 1774, 1775, 1776, 1777, 1778, 1779, 1780, 1781, 1782, 1783, 1784, 1785, 1786, 1787, 1788, 1789, 1790, 1791, 1792, 1793, 1794, 1795, 1796, 1797, 1798, 1799, 1800, 1801, 1802, 1803, 1804, 1805, 1806, 1807, 1808, 1809, 1810, 1811, 1812, 1813, 1814, 1815, 11757, 1817, 1818, 11759, 1819, 1821, 1822, 1823, 11760, 1825, 1824, 1826, 1828, 1829, 1830, 1831, 1832, 1833, 1834, 1835, 1836, 1837, 1838, 11763, 1840, 1841, 1842, 1843, 11764, 1845, 1846, 1847, 1848, 1849, 1850, 1851, 1852, 11765, 1854, 1855, 1856, 1857, 1858, 11767, 1859, 1860, 1861, 1862, 11768, 1863, 1864, 1867, 1868, 1869, 1870, 1871, 1872, 1873, 1874, 1875, 1876, 11770, 11769, 11771, 1877, 1878, 1879, 1880, 11772, 1881, 1882, 1883, 1884, 1889, 11773, 1885, 1886, 1887, 11774, 1895, 1896, 1897, 1890, 11775, 1891, 1892, 1893, 1894, 1898, 1905, 1906, 1899, 1900, 1901, 11777, 1902, 1903, 1904, 11776, 11778, 11779, 11426, 11780, 11781, 11782, 2682, 10130, 10131, 10132, 10133, 10134, 11783, 10136, 10135, 10138, 10139, 10140, 10141, 11785, 10142, 10144, 10137, 10146, 10143, 10148, 10149, 10150, 10151, 10152, 10153, 10154, 1839, 10156, 11788, 10158, 10157, 10160, 10155, 11789, 10824, 10164, 9196, 10162, 11790, 10165, 10161, 10163, 11543, 11791, 11792, 11793, 11794, 1056, 10825, 9197, 11795, 11796, 10197, 11797, 11798, 10826, 10216, 10217, 3300, 11801, 11802, 11803, 11804, 11805, 11806, 10251, 10252, 11807, 2687, 10253, 10256, 10255, 11808, 10258, 10260, 10261, 10262, 10263, 10264, 10265, 10266, 10828, 10268, 10269, 10267, 11811, 3403, 11480, 10281, 10282, 10283, 10284, 11813, 10286, 10287, 10288, 10289, 10290, 10291, 10292, 10293, 10294, 10295, 10296, 10297, 10298, 10299, 10300, 10301, 10302, 10303, 11816, 10305, 10306, 10307, 10308, 10309, 10310, 10304, 10830, 1061, 10314, 10315, 10316, 10317, 10318, 3679, 10312, 10321, 10322, 10323, 10324, 10325, 10326, 10327, 11482, 10831, 1062, 11826, 3342, 5314, 11483, 10358, 5315, 10832, 11830, 11831, 3343, 11832, 11484, 436, 3344, 11485, 5328, 3345, 11842, 11486, 5330, 11843, 11844, 11845, 5333, 11846, 11415, 11847, 11487, 11848, 11849, 11850, 11851, 5339, 11852, 5340, 11853, 11488, 11854, 11814, 11596, 11855, 11856, 11857, 11416, 5302, 11531, 11858, 11489, 11544, 11859, 11815, 11860, 11518, 11861, 11862, 11863, 11490, 11864, 11865, 11866, 11867, 11424, 10559, 11491, 11481, 11869, 11870, 10572, 11871, 10575, 10576, 10577, 10578, 10579, 10580, 10581, 10582, 10583, 10584, 10585, 10586, 10587, 10588, 10589, 11874, 11873, 11492, 11875, 11479, 10607, 10608, 10609, 10610, 10611, 11493, 10617, 10618, 10619, 10620, 10621, 10622, 10623, 10254, 11494, 10257, 11612, 10259, 11495, 11892, 11496, 3356, 11417, 11497, 2525, 2526, 2527, 2528, 2529, 2530, 2531, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2541, 2542, 2543, 2544, 2545, 2546, 2547, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2558, 2559, 2560, 2561, 2562, 2563, 2564, 2565, 2566, 2567, 2568, 2569, 2570, 2571, 11499, 2573, 2574, 2575, 2576, 2577, 2578, 2579, 2580, 2581, 2582, 2583, 2584, 2585, 2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 2595, 2596, 2597, 2598, 2599, 2600, 2601, 2602, 2603, 2604, 2605, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2614, 2615, 2616, 2617, 2618, 2619, 2620, 2621, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2630, 10819, 2632, 2633, 2634, 2635, 2636, 2637, 2638, 2639, 10827, 2641, 2642, 2643, 2644, 10833, 2646, 2647, 2648, 2649, 2650, 2651, 2652, 2653, 2654, 2655, 2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 2665, 2666, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 10869, 2678, 2679, 2680, 2681, 10874, 10875, 10876, 2685, 2686, 10877, 2688, 2689, 2690, 2691, 2692, 10880, 10883, 10879, 10881, 10884, 2698, 10882, 2700, 2699, 2702, 2694, 2697, 10896, 2706, 2707, 10895, 2709, 2710, 2711, 2712, 2713, 10906, 2715, 10908, 10909, 2718, 10911, 10910, 2721, 10907, 2717, 2722, 2725, 2726, 10918, 2728, 2729, 10921, 2731, 10924, 2733, 10920, 2734, 2736, 2730, 2738, 2739, 2740, 2737, 2742, 2743, 2744, 2745, 2746, 2747, 2748, 2749, 2750, 2751, 2752, 2753, 2754, 2755, 2756, 2757, 2758, 2759, 5432, 2761, 2762, 2763, 2764, 2765, 2766, 2767, 2768, 2769, 2770, 2771, 10964, 10965, 2773, 10966, 2776, 2777, 10968, 10970, 10971, 10972, 10967, 2783, 10969, 10977, 10978, 10979, 10980, 2782, 2790, 10982, 2792, 2793, 2794, 2795, 10985, 2797, 2798, 10984, 10986, 2801, 2802, 2803, 2804, 2805, 2806, 2807, 2808, 2809, 2810, 10994, 2812, 2811, 2814, 2815, 2816, 2817, 2818, 2819, 2820, 2821, 2822, 11011, 11012, 2825, 2826, 11014, 2828, 11015, 2830, 2831, 2832, 2833, 2834, 2835, 2836, 2837, 2838, 2839, 2840, 2841, 2842, 2843, 2844, 2845, 11036, 2847, 11037, 2846, 5451, 2849, 2852, 2853, 2854, 5452, 2855, 2857, 2858, 2859, 2860, 2856, 2862, 2863, 2861, 2864, 2865, 2867, 2866, 2869, 5455, 11063, 2871, 2873, 2874, 2875, 11068, 11069, 2878, 11070, 11071, 11073, 11074, 11075, 11076, 11072, 2886, 2887, 2888, 2889, 5459, 2883, 11084, 2893, 2894, 2895, 2896, 2897, 2898, 2899, 2900, 2901, 2902, 2903, 2904, 2905, 2906, 2907, 2908, 2909, 5463, 2911, 2912, 2913, 2914, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2922, 2923, 2924, 2925, 2926, 2927, 2928, 11121, 2930, 11123, 2932, 11122, 11126, 11127, 11128, 11125, 2935, 2931, 11132, 11133, 2942, 11134, 2944, 2945, 11135, 2938, 2939, 2949, 2950, 2951, 2952, 2953, 2954, 2955, 2956, 2957, 2958, 2959, 11146, 11145, 2960, 2962, 2964, 11157, 11158, 11159, 11160, 11161, 11162, 2971, 2972, 2973, 2974, 2967, 2968, 2977, 2969, 2979, 2980, 2981, 5477, 2978, 2983, 2984, 2985, 2987, 2988, 2989, 2990, 2991, 2992, 2993, 2994, 2995, 2996, 2997, 2998, 2999, 3000, 3001, 3002, 3003, 3004, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3017, 3018, 3019, 3020, 3021, 3022, 3023, 3024, 3025, 3026, 3027, 3028, 3029, 3030, 3031, 3032, 3033, 3034, 3035, 3036, 3037, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 3051, 11243, 11239, 11246, 11247, 11245, 3057, 3058, 3059, 11250, 11251, 11254, 3063, 3064, 3065, 3066, 11253, 11252, 3060, 3062, 3068, 3072, 3073, 3074, 3075, 3069, 3077, 3070, 3079, 3080, 3081, 3082, 11275, 11276, 3083, 11278, 3084, 11280, 11281, 3090, 3091, 3085, 11285, 3094, 3095, 11288, 11287, 11286, 3099, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111, 3112, 3113, 3114, 3115, 3116, 3117, 3118, 3119, 3120, 3121, 3122, 3123, 3124, 3125, 3126, 3127, 3128, 3129, 3130, 3131, 3132, 3133, 3134, 3135, 3136, 3137, 3138, 3139, 3140, 3141, 3142, 3143, 3144, 3145, 3147, 3148, 3149, 3150, 3151, 3152, 3153, 3154, 3155, 3156, 3157, 3158, 3159, 3160, 3161, 3162, 3163, 3164, 3165, 3166, 3167, 3168, 3169, 3170, 5514, 3171, 3172, 3174, 3175, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 5517, 3188, 3189, 3190, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 5520, 3199, 3200, 3201, 3198, 3203, 3202, 3205, 3206, 3207, 3208, 3209, 3204, 3210, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 5526, 3235, 3237, 3238, 3239, 3240, 3241, 3242, 3243, 3244, 3245, 3246, 3247, 3248, 11441, 3250, 11440, 646, 3251, 3252, 3253, 3254, 3257, 3255, 11451, 3259, 3261, 3262, 3263, 3264, 3265, 3266, 11459, 5533, 3269, 3270, 3267, 3268, 3271, 3272, 3273, 3276, 3277, 5536, 3274, 3280, 3281, 3282, 3283, 3284, 3285, 3286, 3279, 3288, 3289, 3290, 3291, 3287, 3293, 3294, 3292, 3295, 3296, 5540, 3297, 3298, 3301, 3299, 5541, 3304, 3305, 3306, 3303, 3307, 3308, 3309, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 5544, 3319, 3320, 3322, 3323, 3324, 3325, 3326, 3327, 5546, 3328, 3330, 3331, 3332, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 11533, 11534, 11535, 11537, 3346, 3347, 3348, 3349, 3350, 3351, 3352, 3353, 3354, 3355, 11545, 11541, 11542, 3359, 3360, 3361, 3362, 3363, 3364, 3365, 11557, 3367, 11554, 11553, 11562, 11563, 3372, 3373, 3374, 11559, 3376, 3377, 3378, 3379, 3380, 3381, 11574, 3383, 3384, 11577, 3386, 3387, 3388, 3389, 11582, 3390, 11583, 3393, 11585, 3395, 3396, 11589, 3398, 3399, 3400, 3401, 3402, 11595, 3404, 11594, 11592, 11593, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 11604, 3416, 3417, 3418, 3419, 3420, 3421, 11614, 3422, 3423, 11617, 3426, 3427, 3424, 3425, 3428, 3429, 3430, 3433, 3431, 3435, 3436, 3437, 3438, 3432, 3434, 11624, 11625, 3439, 3440, 3445, 3446, 3447, 3448, 3449, 3450, 3451, 3452, 3453, 3454, 3455, 3456, 3457, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3465, 3466, 3467, 3468, 3469, 3470, 3471, 3472, 3473, 3474, 3475, 3476, 3477, 3478, 3479, 3480, 3481, 3482, 3483, 3484, 3485, 3486, 3487, 11677, 3489, 3490, 3491, 11683, 11685, 11686, 11687, 11679, 3497, 3498, 3499, 3500, 3501, 11691, 3503, 11689, 11697, 3505, 3507, 3508, 3509, 3510, 3511, 3512, 11701, 11698, 3515, 3516, 11709, 11708, 3519, 3517, 3518, 3520, 11707, 11710, 11717, 11714, 11712, 3528, 3529, 3530, 11720, 3532, 3533, 3534, 3535, 3536, 3537, 3538, 3539, 3540, 3541, 3542, 3543, 3544, 3545, 3546, 3547, 3548, 11741, 11742, 3549, 3550, 3551, 3553, 3554, 3555, 3557, 3556, 3552, 3559, 3560, 3561, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 3572, 11758, 3574, 3575, 3576, 3577, 3578, 3579, 3580, 3581, 3582, 3583, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3598, 3599, 3600, 3601, 3602, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3612, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3631, 3632, 3633, 3634, 3635, 3636, 3637, 3638, 3639, 3640, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3648, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3661, 3662, 3663, 3664, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 11868, 3676, 3678, 3677, 3680, 3681, 3682, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 3690, 3691, 11876, 11877, 11878, 11879, 11880, 11882, 11881, 11884, 11883, 11752, 11885, 11886, 11887, 11888, 11889, 11890, 11891, 11893, 11903, 11904, 11905, 11906, 11907, 11908, 11909, 11910, 11911, 11912, 11931, 11932, 11933, 11934, 11935, 3405, 11936, 11937, 11938, 11939, 11941, 11942, 11940, 11944, 11945, 11946, 11943, 11947, 11872, 3406, 11547, 11427, 3407, 11429, 11549, 11753, 812, 11551, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 3911, 3912, 3913, 3915, 3916, 3917, 3918, 3919, 3921, 3922, 3923, 3924, 3925, 3926, 3927, 3928, 3929, 3930, 3931, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3952, 3953, 3954, 3955, 3956, 3957, 3958, 3959, 3960, 3961, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3980, 3981, 3982, 3983, 3984, 3985, 3986, 3987, 3988, 3989, 3990, 3991, 3992, 3993, 4002, 4003, 4004, 4005, 4006, 4007, 4008, 4052, 4010, 4011, 4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4022, 4023, 4024, 4025, 4026, 4027, 4028, 4029, 4030, 4031, 4032, 4033, 4034, 4035, 4036, 4037, 4038, 4039, 4040, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 11558, 4053, 4054, 4055, 4056, 4057, 4058, 4059, 4060, 4061, 4062, 4063, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4072, 4073, 4074, 4075, 4076, 8951, 11755, 4077, 4080, 4081, 4082, 4083, 4084, 4085, 4079, 4078, 4087, 4089, 4090, 4091, 4092, 4093, 4094, 4095, 4096, 4097, 4098, 4099, 4100, 4101, 4102, 4103, 4104, 8957, 4106, 4107, 4108, 4109, 4105, 4110, 4112, 4113, 4114, 4115, 4116, 5048, 4117, 4119, 4120, 4118, 4122, 4123, 4124, 4125, 4126, 4127, 11561, 4129, 4130, 4131, 4128, 4133, 4134, 4135, 4132, 4137, 4138, 4139, 4140, 4141, 4142, 4143, 4144, 4145, 824, 4147, 4148, 4149, 4150, 4151, 4152, 4153, 4154, 4155, 4156, 4157, 4158, 4159, 4160, 4161, 826, 11430, 829, 4086, 830, 11599, 4088, 818, 8959, 845, 11560, 846, 11508, 821, 11567, 4111, 1011, 11568, 859, 11569, 861, 863, 864, 9006, 865, 11570, 11443, 9010, 869, 9011, 11571, 9012, 9013, 9014, 9015, 11432, 4136, 11575, 3357, 893, 11576, 895, 896, 898, 11498, 11433, 902, 905, 912, 11528, 11580, 3358, 2788, 11581, 9061, 920, 11506, 11434, 3442, 931, 932, 5072, 11613, 943, 3391, 5828, 944, 5899, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4762, 4763, 4764, 4765, 4766, 4767, 4768, 4769, 4770, 4771, 5832, 4773, 4774, 4775, 4776, 4777, 4778, 4779, 4780, 4772, 4782, 4783, 4784, 4785, 4786, 4787, 4788, 4789, 4790, 4791, 5836, 4793, 4794, 4795, 4796, 4797, 4798, 4799, 4800, 4801, 4802, 4803, 4804, 11600, 4806, 4807, 4808, 11588, 4810, 4811, 4813, 4814, 4815, 4816, 4817, 4818, 4819, 4820, 4821, 4822, 4823, 3368, 11761, 4839, 4840, 4841, 4842, 4843, 4844, 4845, 4846, 4847, 4848, 4849, 4850, 4851, 4852, 4853, 4854, 4855, 4856, 5849, 11590, 5853, 5854, 4880, 11591, 5855, 11501, 5079, 11509, 5860, 9117, 5861, 980, 9123, 982, 9124, 984, 9125, 11762, 9126, 986, 9127, 9128, 9129, 4973, 4974, 4996, 4997, 4998, 4999, 5000, 5001, 5002, 5003, 5004, 5005, 5006, 5007, 5008, 5009, 5010, 5011, 5012, 5013, 5014, 5015, 5016, 5017, 5018, 5019, 5020, 5021, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5034, 5035, 5036, 5037, 5038, 5039, 5040, 5041, 1002, 5043, 5042, 5045, 2631, 5047, 1003, 5049, 5050, 5046, 1004, 5052, 5054, 5053, 5051, 5057, 5058, 5059, 5060, 5061, 5062, 5063, 5064, 5065, 5066, 1007, 5067, 5068, 5070, 5069, 1008, 5071, 5074, 5075, 5076, 1009, 5078, 5077, 5080, 5081, 1010, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5090, 5091, 5092, 5093, 5094, 5095, 5096, 5097, 1012, 1013, 5100, 5101, 5102, 1014, 5104, 5105, 5106, 5107, 1015, 5109, 5108, 5111, 1016, 5112, 5114, 5115, 5116, 2645, 1017, 5118, 5120, 5121, 5113, 5123, 5124, 5125, 5126, 5127, 5128, 5129, 5130, 5131, 5133, 5134, 5135, 5136, 5137, 5138, 5139, 5140, 5141, 5142, 5143, 5144, 5145, 5146, 5147, 5148, 5149, 5150, 5151, 5152, 5153, 5154, 5155, 5156, 5157, 1025, 10311, 9167, 9168, 9323, 1029, 9171, 1031, 1033, 10804, 9176, 5209, 5210, 5211, 5212, 5213, 5214, 5215, 10806, 5217, 5218, 5219, 5220, 5221, 5222, 5223, 5224, 5225, 5226, 5227, 5228, 10808, 5230, 5231, 5232, 5229, 10809, 11605, 10810, 10811, 10812, 10813, 10814, 10815, 10816, 11504, 10817, 2677, 10818, 10820, 10821, 5295, 5296, 5297, 5298, 5299, 10822, 5301, 10823, 5303, 5304, 5305, 5306, 5307, 5308, 5309, 5310, 5311, 5312, 5313, 2684, 2683, 5316, 5317, 5318, 5319, 5320, 5321, 5322, 5323, 5324, 5325, 1057, 1058, 5327, 1059, 5329, 5331, 10829, 5332, 5334, 5335, 5336, 5337, 5338, 9202, 1060, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5349, 5350, 5351, 5352, 5353, 5354, 5355, 5356, 5357, 5358, 5359, 5360, 5361, 1065, 1066, 2695, 2696, 5098, 1072, 2701, 5099, 5402, 5403, 5404, 5405, 5406, 5407, 5408, 5409, 5410, 5411, 5412, 5413, 2703, 5415, 5416, 5417, 5418, 5419, 5420, 2704, 5422, 2705, 5424, 5425, 5426, 5427, 5428, 5429, 5430, 5431, 5423, 2708, 5434, 10854, 5436, 5437, 5435, 5433, 5440, 5441, 5438, 5442, 5443, 5445, 5446, 5447, 5448, 1083, 5449, 11766, 5450, 10853, 5454, 1084, 5456, 5457, 5458, 1085, 5460, 5461, 5462, 10855, 5464, 1086, 5466, 5465, 5468, 5469, 5470, 5471, 5472, 5473, 2716, 5475, 5476, 1087, 5478, 5479, 1088, 5481, 5482, 5483, 5484, 5485, 10859, 5487, 5488, 5489, 5490, 1091, 2719, 10861, 2720, 1092, 10860, 10862, 5499, 5500, 5501, 1093, 5103, 10863, 10313, 5506, 5507, 5508, 5509, 2723, 5511, 10864, 5513, 2724, 5515, 5516, 10865, 5518, 5519, 10866, 5521, 2714, 5523, 10867, 5525, 9239, 5522, 5528, 5529, 5530, 2727, 5532, 10868, 9240, 9241, 5527, 5537, 5538, 5539, 10870, 9242, 5542, 5543, 10871, 9243, 5545, 5547, 5548, 5549, 10872, 1021, 9244, 10873, 9245, 1104, 9813, 9246, 11618, 1108, 10878, 11619, 1115, 9256, 11620, 11419, 1116, 10886, 1117, 9258, 10887, 1118, 9259, 10888, 1119, 9260, 9261, 1120, 11621, 10890, 9262, 1121, 10891, 9263, 11507, 10892, 9264, 1123, 10893, 9265, 1124, 10894, 9266, 1125, 11622, 11442, 9268, 10897, 5110, 9269, 10898, 1129, 10856, 9271, 10899, 10900, 10901, 9273, 10902, 9274, 10903, 9275, 10904, 10905, 9278, 5725, 5726, 5727, 5728, 5729, 5730, 5731, 11503, 5733, 5734, 5735, 5736, 5737, 5738, 5739, 5741, 5742, 5743, 5744, 5745, 5748, 10912, 9284, 5752, 5753, 5754, 5755, 2772, 9285, 5758, 5439, 5759, 9286, 11626, 5763, 5764, 5765, 2774, 9287, 5766, 5769, 2775, 5771, 5772, 5773, 5767, 10917, 5775, 9289, 5774, 5776, 5781, 9290, 5783, 5785, 10919, 2778, 5788, 9291, 2779, 9292, 5786, 5793, 5794, 2780, 9293, 2781, 5800, 9294, 5803, 5802, 10923, 9295, 5808, 10857, 5810, 9296, 9297, 2785, 5822, 5823, 5821, 5824, 2786, 5825, 9298, 5829, 5830, 2787, 9300, 5833, 5834, 5835, 9301, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 2789, 9302, 5851, 5852, 9303, 2791, 5850, 9304, 9305, 5858, 5859, 5857, 9306, 5862, 5863, 5864, 5856, 5866, 5865, 5868, 5869, 5870, 5871, 5867, 5873, 5875, 5877, 5879, 5880, 5881, 5882, 5883, 5884, 5885, 5886, 5887, 5888, 5889, 5890, 5891, 5892, 5893, 5894, 5444, 2800, 5897, 5895, 5898, 5900, 5901, 5902, 5903, 5904, 5905, 5906, 5907, 5908, 5909, 5910, 5911, 5912, 5916, 5917, 5918, 5919, 5920, 5922, 5923, 5924, 5925, 5927, 5928, 5929, 5931, 5932, 5933, 10858, 5935, 5936, 5937, 5939, 5940, 5941, 5942, 9322, 5944, 5945, 5947, 5948, 5949, 5950, 5951, 5952, 5953, 5954, 5955, 5956, 9324, 5958, 9325, 9326, 5966, 5967, 9327, 9328, 11615, 9332, 9333, 2823, 2824, 11510, 10973, 10974, 6062, 6063, 6064, 6065, 10975, 6066, 6068, 6070, 6071, 10976, 6072, 6074, 6073, 6076, 6075, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6077, 6087, 6088, 6089, 6090, 6091, 6092, 6093, 6094, 6095, 6096, 6097, 6098, 10981, 6100, 6101, 6099, 6103, 6104, 6105, 6106, 6107, 10983, 6102, 6112, 6113, 6114, 10987, 6128, 2848, 10990, 11511, 10991, 2850, 10992, 2851, 10993, 10995, 10996, 6177, 6178, 10997, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 10999, 10998, 11000, 11001, 11002, 11003, 11004, 11005, 11006, 11007, 6231, 6232, 11008, 6234, 6233, 6236, 6237, 6238, 2868, 11009, 11010, 2870, 11013, 2872, 11016, 2876, 11017, 2877, 11018, 11019, 2879, 11020, 11021, 2880, 11022, 2881, 11023, 2882, 11024, 11025, 2884, 11026, 2885, 11027, 11028, 11029, 11030, 11031, 2890, 11032, 2891, 11033, 2892, 11034, 11035, 11038, 11039, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6421, 6422, 6423, 6424, 6425, 6426, 6427, 6428, 6429, 6430, 6431, 6432, 6433, 6434, 6435, 6436, 6437, 6438, 6439, 6440, 6441, 6442, 6443, 6444, 6445, 6446, 6447, 6448, 6449, 6450, 6451, 6452, 6453, 6454, 6455, 6456, 6457, 6458, 6459, 6460, 6461, 6462, 6463, 6464, 6465, 6466, 6467, 6468, 11055, 5467, 6479, 6480, 6481, 6482, 6489, 6490, 6491, 6492, 11060, 6179, 2929, 9444, 9445, 2934, 2936, 2937, 2940, 2941, 9455, 2943, 2946, 2947, 2948, 5474, 3521, 3397, 2961, 11536, 2963, 2965, 5524, 2966, 11616, 2970, 11538, 2975, 3526, 2982, 3527, 11124, 2986, 11129, 11130, 6851, 6852, 6853, 6854, 6855, 6856, 6857, 6858, 6859, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6867, 6868, 6869, 6870, 6871, 6872, 6873, 6874, 6875, 6876, 6877, 6878, 6879, 6880, 6881, 6882, 6883, 6884, 6885, 6886, 6887, 6888, 6889, 6890, 6891, 6892, 6893, 6894, 6895, 6896, 6897, 6898, 6899, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6908, 6909, 6910, 6911, 6912, 6913, 6914, 6915, 6916, 11144, 6918, 6919, 6920, 6921, 6922, 6917, 6924, 6925, 6926, 6927, 6928, 6923, 6930, 6929, 6932, 6931, 6934, 6933, 6936, 6937, 6938, 6939, 6940, 6941, 6942, 6943, 6944, 6945, 6946, 6947, 6948, 6949, 6950, 6951, 6952, 6953, 6954, 6955, 6956, 6957, 6958, 6959, 6960, 6961, 6962, 6963, 6964, 6965, 6966, 6967, 6968, 6969, 6970, 6971, 6973, 6974, 6975, 6976, 6977, 6978, 6979, 6980, 6981, 6982, 6983, 6984, 6985, 6986, 6987, 6988, 6989, 6990, 6991, 6992, 6993, 6994, 6995, 6996, 6997, 6998, 6999, 7000, 7001, 7002, 7003, 7004, 7005, 7006, 7007, 7008, 7009, 7010, 7011, 7012, 7013, 7014, 7015, 7016, 7017, 7018, 7019, 7020, 7021, 7022, 7023, 7024, 7025, 7026, 7027, 9537, 9543, 9544, 11180, 11519, 3052, 3053, 3054, 3055, 3056, 3061, 3071, 3076, 11520, 3078, 3086, 3087, 3088, 3089, 3092, 3093, 3096, 3097, 3098, 11240, 11586, 11241, 11242, 11521, 11244, 5831, 11248, 11249, 11500, 11422, 9090, 11587, 7532, 7534, 7535, 7536, 7537, 7539, 7540, 7541, 7542, 11522, 7551, 7552, 7553, 7554, 7555, 7556, 7557, 7558, 7559, 7560, 11277, 10285, 11279, 11282, 11283, 11284, 11289, 11291, 11523, 11502, 11704, 7754, 7755, 7756, 7757, 7758, 7759, 7760, 7761, 7762, 7763, 7766, 7767, 7768, 7769, 7770, 7771, 7772, 7773, 7774, 7775, 7776, 7777, 7778, 7779, 7780, 7781, 7782, 7783, 7784, 7785, 7786, 7787, 7788, 7789, 7790, 7791, 7792, 7793, 11524, 962, 7874, 7875, 7876, 7877, 7878, 7879, 7880, 7881, 7882, 7883, 7884, 7885, 7886, 7887, 7888, 7889, 7890, 7891, 7892, 7893, 7894, 7895, 7896, 7897, 7898, 7899, 7900, 7901, 7902, 7903, 7904, 7905, 7906, 7907, 7908, 7909, 7910, 7911, 7912, 7913, 7914, 7915, 11525, 3211, 11526, 3236, 11423, 11527, 3256) AND "nodes_node"."id" IN (SELECT U0."child_node_id_id" FROM "node_relation_goods_movement_noderelationgoodsmovement" U0 WHERE U0."parent_node_id_id" = 11288) AND "nodes_node"."node_type" = 3 AND "nodes_node"."node_type" = 3) ORDER BY "nodes_node"."name" ASC LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment