Skip to content

Instantly share code, notes, and snippets.

@berkes

berkes/query_wtf.sql

Created August 21, 2020 14:18
Show Gist options
  • Save berkes/8686faa0ed10aa0b4807351c185d3653 to your computer and use it in GitHub Desktop.
Save berkes/8686faa0ed10aa0b4807351c185d3653 to your computer and use it in GitHub Desktop.
Download ZIP
lekkerdan
Raw
query_wtf.sql
SELECT DISTINCT SUBPATH(categories.path, 0, 1) FROM "gauges" INNER JOIN "entities" ON "entities"."id" = "gauges"."entity_id" INNER JOIN "categories_gauges" ON "categories_gauges"."gauge_id" = "gauges"."id" INNER JOIN "categories" ON "categories"."id" = "categories_gauges"."category_id" WHERE (entities.path <@ '1924544') AND (gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '5005')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '6599')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '2492')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '3137')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '4214')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '5713')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '6565')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '8166')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '9910')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '9897')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '10003')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))) AND gauges.id IN (SELECT "gauges"."id" FROM "gauges" LEFT OUTER JOIN categories_gauges
ON categories_gauges.gauge_id = gauges.id
AND categories_gauges.category_id IN (SELECT "categories"."id" FROM "categories" WHERE (categories.path <@ '10021')) WHERE (categories_gauges.category_id IN (5129,2496,2500,2504,2509,2513,2517,2521,2525,2529,8012,8015,4274,4318,4556,4322,3124,3203,3089,3081,3091,3123,3093,3059,3067,3055,3075,3125,3133,3108,3113,3114,3116,3119,3118,3129,3100,3670,3663,3700,4044,4020,4030,4011,4050,3094,3101,3194,3196,3197,3103,3038,6610,5007,5008,5006,7578,7581,7795,7802,7810,7817,7820,7824,7827,7830,7833,7836,7841,7814,7805,8933,8977,9706,9303,9323,9456,9063,9073,9076,9624,9636,9633,9642,9082,8992,8995,9610,9621,9639,9079,9627,10406,6704,11229,7160,4221,4222,4223,4238,7157,4239,346,179,181,5753,5759,182,124,11232,11328,6708,6783,7170,211,11244,132,4413,4638,212,6714,109,279,392,6449,6980,6983,7180,7422,393,6452,11091,11249,128,123,7668,122,337,338,339,340,191,7004,7508,7511,121,127,135,136,137,171,333,347,913,195,196,197,198,200,192,194,4167,188,193,281,282,283,308,309,310,311,312,201,7514,7517,6456,4231,313,286,287,288,290,314,306,315,327,5397,6104,6352,460,461,462,387,6656,7007,7234,205,204,11094,914,915,916,921,923,391,906,907,911,11269,7520,7673,4228,6726,7010,729,730,7528,7682,6463,11283,7540,7543,7534,756,6116,739,826,828,6367,932,908,3983,909,4398,4517,4635,359,1939,78,79,345,4224,4225,4232,4233,11294,4580,6372,2001,6645,7554,2008,3586,749,748,747,929,905,3572,3553,708,709,920,751,750,115,4450,4226,4234,4235,4236,4237,6662,2792,3535,3562,3573,3606,7557,6670,5126,129,130,6549,6676,6552,6680,6686,6557,6683,7344,7600,6689,7563,727,3610,3614,3633,3490,3487,4196,4197,4195,4193,4194,7348,330,354,278,4425,34,1353,36,385,280,329,334,335,336,341,342,4340,4641,353,406,407,368,343,344,348,360,361,362,364,366,367,369,370,371,375,377,378,379,381,382,386,388,389,390,404,410,415,416,417,418,419,420,421,422,423,424,425,426,363,438,439,440,441,2786,444,445,446,447,448,449,457,458,459,463,470,471,472,473,474,475,476,479,480,481,520,4409,4434,521,522,523,524,525,125,526,527,528,529,538,558,566,569,574,575,477,581,582,584,585,587,697,698,714,715,716,717,718,719,720,724,728,731,924,927,113,114,133,134,928,930,933,935,174,175,176,177,178,395,540,541,542,543,544,4419,934,559,138,583,586,694,695,202,217,289,291,292,293,316,331,332,427,322,434,435,216,428,429,430,431,432,433,436,437,3626,3643,4227,4229,4230,394,396,721,397,398,399,209,111,400,401,402,403,180,183,405,409,4462,412,413,442,539,545,571,572,376,323,325,328,562,561,241,277,172,173,2862,910,4215,4216,4217,4218,4219,4220,213,214,215,238,239,240,307,5323,408,5326,829,901,904,746,745,744,743,742,741,467,380,722,713,3484,725,931,5767,5776,411,6601,6701,6570,206,518,7858,7734,7772,7775,7778,7780,7783,7863,8072,7851,7848,7855,7866,7872,7537,7877,7952,7958,7962,7976,7980,8000,8035,8038,8055,8058,8078,8083,8094,8097,8100,8103,8106,8109,8112,8232,8261,8264,8667,8597,8594,8658,8661,8670,8673,8676,8664,8687,8692,8810,8813,8816,8819,8823,8904,8918,8922,8925,8928,11158,8939,8942,8086,11165,9096,9100,9107,9110,9113,9122,9126,9136,9139,9142,9145,9151,9155,9158,9211,9226,9229,9232,9235,9238,9243,9246,9268,9093,9276,9283,9355,9367,9371,9374,9398,9394,9404,9413,9417,9425,9432,8679,9466,9469,9472,9476,9508,9511,9521,9525,9550,9553,9570,9574,9584,723,11182,11185,11188,9816,9725,9728,9731,9734,9737,9740,9743,9746,9749,9752,9789,9796,9757,9766,9773,9783,9786,9792,9780,9769,9777,9760,9819,9822,9826,9829,9832,9888,9891,9894,9923,9926,9996,9999,10349,10445,10479,10476,10490,10493,10496,10499,10502,10505,10508,10511,10514,10517,10520,10523,10526,10529,10532,10538,10535,10542,10545,6568,6573,6576,6622,6625,6629,8169,8172,9900,9903,9915,9918,9970,10009,10892,11074,11085,11112,10895,11077,11082,11115,11131,11134,11140,11137,11143,11146,11149,10203,10233,10229,10025,10265,10261,10268,10274,10280,10305,10320,10326,10276,10271,10740,10173,10743,10148,10194,10196,10212,10259,10170,10189,10221,10214,10179,10182,10187,10199,10206,10208,10227,10132,10058,10055,10050,10069,10063,10075,10078,10072,10142,10145,10139,10135,10088,10094,10129,10123,10034,10031,10037,10151,10155,10578,10581,10584,10587,10158,10084,10596,10599,10602,10607,10611,10167,10176,10216,10223,10338,10247,10253,10241,10251,10257,10245,10293,10299,10314,10316,10322,10328,10283,10288,10296,10301,10311,10332,10352,10307,10358,10361,10239,10235,10354,10614,10617,10620,10623,10626,10631,10634,10637,10640,10643,10646,10649,10652,10655,10091,10118,10709,10028,10723,10728,10731,10734,10737,10344,10335,10341))))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment