explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0fE1

Settings
# exclusive inclusive rows x rows loops node
1. 254.643 31,444.488 ↓ 3,511.0 3,511 1

GroupAggregate (cost=184.52..185.86 rows=1 width=1,402) (actual time=31,192.559..31,444.488 rows=3,511 loops=1)

  • Group Key: ah.cid, ah.id, ap.company_name, gat.cid, gat.id, ad.cid, ad.id, gd.name, cd.name, cd.details, art.name, ap.ap_payee_status_type_id, pb.building_name, pb.details, pu.unit_number, pu.details, apt.name, apl.vendor_code
  • Filter: (CASE WHEN (ad.transaction_amount >= '0'::numeric) THEN (ad.transaction_amount + sum(COALESCE(aa.allocation_amount, '0'::numeric))) ELSE (ad.transaction_amount - sum(COALESCE(aa.allocation_amount, '0'::numeric))) END <> '0'::numeric)
  • Rows Removed by Filter: 5,696
2. 46.760 31,189.845 ↓ 13,666.0 13,666 1

Sort (cost=184.52..184.52 rows=1 width=1,654) (actual time=31,186.900..31,189.845 rows=13,666 loops=1)

  • Sort Key: ah.id, ap.company_name, gat.id, ad.id, gd.name, cd.name, cd.details, art.name, ap.ap_payee_status_type_id, pb.building_name, pb.details, pu.unit_number, pu.details, apt.name, apl.vendor_code
  • Sort Method: quicksort Memory: 4,142kB
3. 48.070 31,143.085 ↓ 13,666.0 13,666 1

Nested Loop Left Join (cost=4.13..184.51 rows=1 width=1,654) (actual time=113.549..31,143.085 rows=13,666 loops=1)

  • Join Filter: ((ah.cid = art.cid) AND (ah.ap_routing_tag_id = art.id))
  • Rows Removed by Join Filter: 147,601
4. 20.796 31,026.685 ↓ 13,666.0 13,666 1

Nested Loop Left Join (cost=4.13..183.16 rows=1 width=1,650) (actual time=113.529..31,026.685 rows=13,666 loops=1)

5. 27.685 31,005.889 ↓ 13,666.0 13,666 1

Nested Loop Left Join (cost=3.99..182.98 rows=1 width=996) (actual time=113.523..31,005.889 rows=13,666 loops=1)

6. 35.277 30,978.204 ↓ 13,666.0 13,666 1

Nested Loop Left Join (cost=3.85..182.81 rows=1 width=993) (actual time=113.517..30,978.204 rows=13,666 loops=1)

  • Join Filter: ((apl.cid = ah.cid) AND (apl.id = ah.ap_payee_location_id))
  • Rows Removed by Join Filter: 29,738
7. 69.680 30,860.931 ↓ 13,666.0 13,666 1

Nested Loop Left Join (cost=3.56..182.39 rows=1 width=992) (actual time=113.479..30,860.931 rows=13,666 loops=1)

8. 5,427.643 30,681.923 ↓ 13,666.0 13,666 1

Nested Loop Left Join (cost=3.27..181.99 rows=1 width=970) (actual time=113.444..30,681.923 rows=13,666 loops=1)

  • Join Filter: ((unnest(('{67998,"" 310734"","" 436980"","" 201194"","" 202061"","" 367793"","" 373378"","" 26443"","" 377902"","" 377903"","" 199207"","" 663842"","" 318251"","" 296401"","" 353736"","" 353735"","" 353733"","" 350885"","" 310733"","" 293112"","" 315132"","" 346491"","" 315100"","" 293351"","" 389104"","" 293384"","" 293386"","" 293338"","" 307310"","" 68050"","" 334148"","" 318650"","" 293389"","" 293362"","" 369063"","" 369064"","" 294033"","" 323091"","" 370335"","" 370334"","" 370448"","" 370449"","" 332861"","" 334520"","" 293395"","" 293340"","" 337021"","" 337022"","" 293346"","" 307439"","" 298247"","" 315263"","" 332144"","" 25184"","" 67841"","" 358855"","" 157"","" 301661"","" 202231"","" 310728"","" 67999"","" 293392"","" 379880"","" 379892"","" 200705"","" 67565"","" 25172"","" 67812"","" 25127"","" 67719"","" 67810"","" 25179"","" 25208"","" 337040"","" 25209"","" 67821"","" 25134"","" 68079"","" 318169"","" 204092"","" 337108"","" 374392"","" 293377"","" 309985"","" 663786"","" 663787"","" 25055"","" 67870"","" 372140"","" 372139"","" 331153"","" 335780"","" 335808"","" 322963"","" 25082"","" 67875"","" 368735"","" 25155"","" 25211"","" 293372"","" 360074"","" 360073"","" 67802"","" 25136"","" 67555"","" 369066"","" 369065"","" 25149"","" 367785"","" 367784"","" 67645"","" 202236"","" 336494"","" 327584"","" 332127"","" 442365"","" 25056"","" 67799"","" 323090"","" 373684"","" 373683"","" 351008"","" 359361"","" 359363"","" 338891"","" 403380"","" 403379"","" 238678"","" 379017"","" 323110"","" 360428"","" 25057"","" 67587"","" 321112"","" 333828"","" 67805"","" 25059"","" 203820"","" 25081"","" 67761"","" 67754"","" 25083"","" 25058"","" 67798"","" 330000"","" 323430"","" 61173"","" 67551"","" 316217"","" 293113"","" 389033"","" 62012"","" 61235"","" 61780"","" 360811"","" 60950"","" 61507"","" 293348"","" 67789"","" 25099"","" 368886"","" 239219"","" 372138"","" 62007"","" 61736"","" 332158"","" 371043"","" 371044"","" 1538"","" 60467"","" 60466"","" 61784"","" 59063"","" 25144"","" 25145"","" 67763"","" 368149"","" 368147"","" 25116"","" 67794"","" 67769"","" 368648"","" 368649"","" 25119"","" 67767"","" 25130"","" 67808"","" 199416"","" 25140"","" 68004"","" 67673"","" 1711"","" 321113"","" 203863"","" 334429"","" 61105"","" 67643"","" 321114"","" 67777"","" 25029"","" 61577"","" 367760"","" 62062"","" 332076"","" 25014"","" 67778"","" 61944"","" 61411"","" 61670"","" 61880"","" 61928"","" 62050"","" 60887"","" 663616"","" 663617"","" 441996"","" 441997"","" 67766"","" 25008"","" 67582"","" 67878"","" 2872"","" 299292"","" 441736"","" 441735"","" 441984"","" 441892"","" 441985"","" 441893"","" 441987"","" 441986"","" 2347"","" 61770"","" 61769"","" 61186"","" 62015"","" 330867"","" 325411"","" 325412"","" 377962"","" 377961"","" 383983"","" 323296"","" 323295"","" 323294"","" 323293"","" 297835"","" 392126"","" 392127"","" 61296"","" 338459"","" 61917"","" 376954"","" 376955"","" 398172"","" 398173"","" 401847"","" 401848"","" 385906"","" 385907"","" 396208"","" 396209"","" 389860"","" 389861"","" 61983"","" 60889"","" 67604"","" 336825"","" 300485"","" 351482"","" 299289"","" 67758"","" 25076"","" 25074"","" 67656"","" 67782"","" 25072"","" 60633"","" 67553"","" 332911"","" 25238"","" 25075"","" 67559"","" 299285"","" 62184"","" 61288"","" 61980"","" 61673"","" 373243"","" 373242"","" 359600"","" 359599"","" 323649"","" 334496"","" 301669"","" 319852"","" 413768"","" 360962"","" 438869"","" 663858"","" 358936"","" 358929"","" 373577"","" 373578"","" 373579"","" 327663"","" 61807"","" 61526"","" 61260"","" 61594"","" 61708"","" 61887"","" 61620"","" 61076"","" 67868"","" 25023"","" 61712"","" 61711"","" 376952"","" 376953"","" 62199"","" 356361"","" 356362"","" 61686"","" 61227"","" 61010"","" 61450"","" 318253"","" 61339"","" 297421"","" 61187"","" 61869"","" 61305"","" 61270"","" 61315"","" 60921"","" 315110"","" 61176"","" 62085"","" 61964"","" 293067"","" 299283"","" 61765"","" 61791"","" 62196"","" 61248"","" 61786"","" 62159"","" 61399"","" 25234"","" 67622"","" 25237"","" 329940"","" 62097"","" 61199"","" 61393"","" 61394"","" 61539"","" 61099"","" 61918"","" 61453"","" 61962"","" 61502"","" 430314"","" 430315"","" 373237"","" 373236"","" 374581"","" 374582"","" 61909"","" 25118"","" 67774"","" 373571"","" 62194"","" 61100"","" 61942"","" 327736"","" 61203"","" 61140"","" 61902"","" 298258"","" 316440"","" 61912"","" 61741"","" 61884"","" 61408"","" 61246"","" 62163"","" 61179"","" 61342"","" 443557"","" 443556"","" 386937"","" 61387"","" 61355"","" 300194"","" 25204"","" 67593"","" 62146"","" 62145"","" 61073"","" 62213"","" 61749"","" 68078"","" 61247"","" 62157"","" 61301"","" 62211"","" 4950"","" 67626"","" 25019"","" 61851"","" 373454"","" 663874"","" 663875"","" 374465"","" 374466"","" 60722"","" 67558"","" 25040"","" 61732"","" 350911"","" 60970"","" 350910"","" 62059"","" 336370"","" 25239"","" 327749"","" 327748"","" 327747"","" 327746"","" 67872"","" 67877"","" 433821"","" 433820"","" 373277"","" 373281"","" 373276"","" 434147"","" 434134"","" 434133"","" 373506"","" 373505"","" 435337"","" 435316"","" 435317"","" 433831"","" 67584"","" 61000"","" 62187"","" 61639"","" 368011"","" 373877"","" 373876"","" 368010"","" 367993"","" 367997"","" 368000"","" 368001"","" 368008"","" 368009"","" 61031"","" 25077"","" 293053"","" 293054"","" 61520"","" 61766"","" 323087"","" 318176"","" 323086"","" 61775"","" 60987"","" 433527"","" 433628"","" 433529"","" 433626"","" 53420"","" 298138"","" 298137"","" 300484"","" 315285"","" 315286"","" 299291"","" 67883"","" 25161"","" 61825"","" 61810"","" 61823"","" 61706"","" 296790"","" 61685"","" 67669"","" 25020"","" 62067"","" 61849"","" 62131"","" 442650"","" 368748"","" 368747"","" 368739"","" 368740"","" 62195"","" 61306"","" 62155"","" 61121"","" 61366"","" 61852"","" 60833"","" 67595"","" 25192"","" 67699"","" 25120"","" 61314"","" 60899"","" 60846"","" 61717"","" 334131"","" 383642"","" 382649"","" 382636"","" 443467"","" 385923"","" 663647"","" 385908"","" 385909"","" 386868"","" 386867"","" 386866"","" 386865"","" 442577"","" 382652"","" 382631"","" 382632"","" 383649"","" 442574"","" 442575"","" 663638"","" 663639"","" 442618"","" 443465"","" 443464"","" 61400"","" 61331"","" 62209"","" 383644"","" 61646"","" 61017"","" 67739"","" 24999"","" 25198"","" 67860"","" 299290"","" 299284"","" 61135"","" 61341"","" 199269"","" 61840"","" 62000"","" 61412"","" 62092"","" 61038"","" 62018"","" 442573"","" 442572"","" 316526"","" 61345"","" 61697"","" 61216"","" 61961"","" 67667"","" 25065"","" 61473"","" 62150"","" 61263"","" 62158"","" 62086"","" 61910"","" 60877"","" 61991"","" 67612"","" 25159"","" 3214"","" 68064"","" 25147"","" 61050"","" 60989"","" 70578"","" 61985"","" 293066"","" 368403"","" 368402"","" 314971"","" 61564"","" 61604"","" 403219"","" 334001"","" 62073"","" 62106"","" 61634"","" 61129"","" 61106"","" 293378"","" 67871"","" 4907"","" 200842"","" 61309"","" 300325"","" 300326"","" 62005"","" 60845"","" 67590"","" 61958"","" 315262"","" 62098"","" 61061"","" 60890"","" 203847"","" 199504"","" 203848"","" 199505"","" 199546"","" 199547"","" 203801"","" 199497"","" 199496"","" 203570"","" 203571"","" 203574"","" 203575"","" 203776"","" 203777"","" 203800"","" 25215"","" 67592"","" 315870"","" 315871"","" 315873"","" 315872"","" 315874"","" 315875"","" 61828"","" 25054"","" 61316"","" 319855"","" 334095"","" 61547"","" 62189"","" 61210"","" 351448"","" 351447"","" 351465"","" 351466"","" 351450"","" 351449"","" 351451"","" 351452"","" 351453"","" 351454"","" 351455"","" 351456"","" 351458"","" 351457"","" 351459"","" 351460"","" 351461"","" 351462"","" 351463"","" 351464"","" 61651"","" 309986"","" 61181"","" 61266"","" 2100"","" 61600"","" 61137"","" 62107"","" 61974"","" 61948"","" 62179"","" 67552"","" 25043"","" 62074"","" 334527"","" 61490"","" 61762"","" 61704"","" 67717"","" 61409"","" 60872"","" 442463"","" 442464"","" 442465"","" 442466"","" 60874"","" 61931"","" 356770"","" 24996"","" 61895"","" 62064"","" 203431"","" 201208"","" 61013"","" 62027"","" 61101"","" 7344"","" 438727"","" 442623"","" 199048"","" 198243"","" 200317"","" 155"","" 158"","" 442624"","" 370268"","" 200134"","" 199847"","" 199270"","" 442625"","" 200140"","" 61508"","" 67572"","" 67571"","" 67588"","" 60848"","" 62063"","" 298303"","" 201207"","" 410628"","" 410627"","" 25045"","" 67997"","" 62010"","" 25018"","" 67646"","" 61457"","" 61458"","" 297253"","" 297254"","" 61981"","" 25174"","" 67709"","" 67814"","" 25177"","" 25176"","" 25175"","" 67813"","" 62023"","" 61444"","" 61482"","" 24992"","" 25102"","" 67873"","" 67696"","" 25060"","" 61088"","" 61198"","" 61727"","" 61253"","" 61269"","" 61268"","" 61259"","" 61700"","" 60847"","" 61055"","" 60885"","" 60884"","" 61354"","" 61729"","" 61369"","" 60842"","" 61122"","" 61734"","" 60927"","" 61167"","" 61413"","" 61589"","" 62039"","" 67609"","" 25007"","" 61349"","" 61196"","" 292887"","" 292888"","" 292898"","" 62182"","" 61858"","" 60900"","" 70598"","" 293385"","" 61678"","" 61089"","" 61189"","" 25024"","" 67545"","" 67610"","" 25181"","" 61056"","" 60883"","" 61950"","" 62192"","" 61920"","" 356831"","" 199127"","" 61615"","" 61421"","" 25086"","" 67627"","" 329269"","" 61681"","" 62231"","" 61984"","" 61402"","" 60882"","" 60873"","" 61522"","" 62178"","" 62144"","" 61292"","" 61037"","" 62051"","" 61333"","" 67734"","" 25101"","" 67757"","" 25062"","" 336371"","" 67615"","" 67614"","" 62161"","" 61350"","" 61677"","" 61809"","" 61793"","" 61570"","" 67708"","" 25199"","" 25201"","" 67929"","" 377890"","" 377889"","" 3942"","" 307484"","" 295312"","" 25139"","" 61982"","" 62125"","" 61336"","" 61756"","" 62052"","" 62024"","" 61804"","" 301401"","" 319860"","" 61363"","" 62056"","" 61698"","" 61087"","" 61699"","" 61543"","" 61523"","" 62200"","" 61562"","" 61245"","" 62117"","" 62101"","" 61907"","" 61138"","" 319882"","" 60867"","" 60896"","" 61544"","" 61597"","" 61466"","" 61632"","" 61431"","" 61541"","" 361156"","" 25041"","" 67822"","" 61575"","" 25080"","" 67781"","" 307248"","" 339223"","" 367835"","" 369122"","" 61460"","" 62041"","" 67840"","" 67851"","" 61362"","" 61898"","" 61797"","" 60849"","" 60940"","" 61509"","" 61748"","" 61160"","" 61913"","" 61416"","" 61418"","" 61726"","" 61012"","" 61289"","" 61249"","" 356432"","" 356454"","" 356436"","" 356438"","" 356440"","" 356444"","" 356446"","" 356448"","" 356450"","" 356452"","" 356433"","" 356455"","" 356434"","" 356435"","" 356437"","" 356439"","" 356441"","" 356445"","" 356447"","" 356449"","" 356451"","" 356453"","" 61079"","" 61787"","" 60901"","" 61205"","" 442035"","" 438868"","" 61674"","" 60850"","" 61475"","" 61638"","" 383672"","" 383673"","" 383674"","" 199598"","" 199599"","" 296055"","" 296056"","" 325416"","" 325417"","" 60904"","" 62068"","" 300958"","" 300957"","" 61440"","" 383562"","" 383561"","" 323350"","" 318714"","" 318713"","" 60981"","" 293394"","" 67620"","" 24979"","" 61452"","" 61018"","" 25012"","" 68062"","" 359359"","" 360133"","" 360132"","" 60951"","" 61763"","" 301670"","" 301671"","" 301672"","" 325421"","" 325420"","" 61873"","" 61422"","" 61423"","" 313394"","" 376902"","" 313393"","" 61538"","" 62205"","" 67575"","" 25047"","" 61949"","" 61325"","" 441615"","" 441614"","" 25121"","" 67775"","" 61090"","" 60954"","" 61866"","" 25046"","" 67562"","" 61774"","" 387829"","" 387828"","" 61938"","" 61956"","" 330053"","" 330052"","" 61184"","" 299973"","" 61684"","" 67629"","" 25141"","" 370199"","" 370200"","" 307577"","" 62175"","" 318130"","" 61696"","" 386793"","" 386792"","" 323292"","" 323291"","" 60851"","" 61258"","" 62221"","" 61382"","" 61445"","" 60852"","" 62105"","" 61872"","" 61832"","" 60976"","" 67788"","" 25050"","" 62077"","" 25068"","" 67755"","" 61740"","" 61323"","" 61174"","" 61308"","" 61214"","" 61346"","" 61567"","" 25751"","" 61023"","" 60834"","" 67548"","" 24980"","" 12530"","" 61494"","" 61645"","" 61298"","" 406940"","" 406936"","" 406935"","" 361173"","" 361172"","" 412212"","" 367767"","" 367766"","" 412203"","" 412204"","" 318513"","" 317213"","" 317214"","" 317215"","" 317212"","" 61307"","" 61796"","" 61610"","" 314623"","" 314624"","" 61965"","" 24978"","" 67714"","" 61702"","" 61190"","" 118"","" 130"","" 136"","" 154"","" 12099"","" 25170"","" 156"","" 120"","" 60786"","" 153"","" 152"","" 128"","" 295813"","" 295814"","" 67862"","" 200048"","" 332075"","" 67586"","" 359327"","" 359328"","" 359364"","" 359365"","" 59046"","" 6043"","" 307363"","" 60743"","" 57350"","" 61476"","" 61989"","" 330487"","" 358238"","" 358239"","" 61438"","" 199428"","" 53763"","" 59462"","" 67569"","" 60911"","" 61469"","" 61092"","" 67733"","" 25073"","" 60869"","" 307325"","" 61525"","" 239033"","" 61692"","" 62217"","" 60996"","" 25009"","" 67801"","" 316668"","" 60917"","" 61151"","" 61498"","" 61955"","" 61583"","" 61295"","" 62113"","" 61532"","" 67811"","" 25166"","" 62042"","" 61070"","" 60960"","" 61021"","" 62110"","" 61904"","" 61555"","" 61666"","" 24993"","" 382608"","" 358816"","" 358817"","" 62165"","" 61372"","" 2345"","" 61582"","" 25085"","" 67670"","" 358081"","" 358080"","" 2363"","" 61656"","" 67850"","" 24981"","" 61348"","" 61455"","" 67697"","" 25033"","" 61228"","" 61722"","" 61856"","" 67828"","" 67826"","" 61213"","" 61716"","" 61745"","" 61264"","" 61033"","" 382478"","" 382477"","" 382523"","" 382522"","" 61170"","" 61335"","" 61622"","" 61403"","" 60919"","" 61488"","" 61642"","" 60876"","" 61471"","" 301593"","" 60895"","" 61191"","" 25037"","" 67711"","" 60826"","" 350292"","" 310820"","" 310821"","" 293965"","" 60780"","" 202533"","" 199086"","" 61598"","" 60974"","" 61565"","" 293359"","" 293365"","" 61725"","" 61820"","" 62208"","" 61718"","" 61391"","" 61571"","" 61990"","" 53628"","" 61376"","" 356718"","" 61553"","" 67804"","" 61080"","" 62099"","" 2470"","" 370262"","" 61994"","" 60853"","" 61044"","" 61052"","" 61669"","" 61068"","" 61979"","" 57277"","" 61655"","" 61328"","" 61943"","" 61218"","" 430696"","" 430686"","" 430685"","" 370507"","" 370506"","" 430898"","" 430897"","" 430904"","" 371004"","" 371005"","" 431143"","" 431135"","" 431136"","" 430406"","" 430396"","" 430395"","" 370254"","" 370252"","" 60939"","" 62132"","" 61533"","" 62118"","" 61108"","" 61273"","" 7455"","" 52835"","" 315284"","" 315283"","" 61927"","" 61703"","" 25190"","" 67681"","" 61561"","" 60990"","" 61001"","" 61616"","" 61329"","" 61332"","" 61816"","" 61929"","" 61930"","" 367788"","" 62065"","" 61665"","" 60961"","" 351197"","" 351479"","" 60964"","" 61447"","" 61483"","" 293376"","" 61951"","" 62011"","" 61728"","" 61675"","" 61606"","" 61881"","" 334149"","" 296511"","" 60929"","" 61347"","" 62114"","" 61987"","" 61123"","" 25090"","" 67655"","" 61660"","" 329946"","" 329945"","" 329947"","" 329948"","" 329949"","" 67561"","" 67666"","" 25227"","" 293885"","" 318492"","" 61752"","" 61614"","" 61966"","" 61826"","" 324963"","" 60965"","" 61968"","" 319872"","" 61280"","" 368765"","" 61275"","" 61093"","" 60891"","" 61304"","" 61244"","" 61002"","" 61527"","" 61377"","" 335604"","" 61410"","" 61556"","" 62207"","" 62037"","" 61914"","" 61212"","" 61211"","" 61430"","" 61612"","" 61161"","" 62069"","" 60941"","" 367990"","" 367991"","" 367992"","" 315290"","" 315289"","" 315288"","" 315287"","" 315280"","" 315279"","" 25186"","" 61689"","" 199144"","" 371925"","" 336496"","" 62215"","" 61062"","" 61300"","" 61195"","" 61495"","" 60956"","" 61596"","" 67829"","" 316634"","" 61862"","" 61863"","" 373701"","" 373702"","" 373703"","" 373704"","" 373705"","" 373706"","" 373708"","" 373707"","" 382629"","" 382628"","" 430423"","" 377930"","" 377931"","" 430424"","" 413764"","" 413763"","" 61219"","" 380174"","" 380173"","" 381238"","" 381239"","" 199397"","" 62032"","" 338785"","" 60897"","" 60838"","" 67594"","" 62038"","" 61095"","" 60936"","" 67824"","" 25182"","" 370962"","" 370961"","" 370470"","" 370471"","" 370468"","" 370469"","" 61584"","" 62026"","" 61551"","" 61798"","" 61576"","" 201293"","" 336835"","" 299977"","" 61060"","" 61433"","" 61102"","" 67589"","" 61019"","" 60995"","" 61368"","" 62216"","" 61472"","" 61250"","" 61503"","" 62224"","" 310132"","" 25117"","" 67768"","" 25228"","" 62045"","" 335742"","" 25191"","" 67682"","" 67684"","" 25025"","" 60943"","" 358037"","" 61045"","" 60902"","" 61750"","" 436948"","" 436947"","" 327732"","" 62103"","" 433747"","" 433746"","" 442008"","" 442009"","" 433976"","" 433977"","" 329950"","" 359679"","" 359678"","" 359685"","" 359686"","" 359693"","" 359694"","" 61110"","" 61009"","" 61059"","" 60910"","" 327654"","" 327655"","" 332413"","" 67630"","" 25160"","" 379904"","" 379905"","" 379909"","" 379908"","" 379907"","" 379906"","" 60922"","" 61936"","" 62138"","" 61587"","" 61425"","" 293391"","" 70552"","" 62002"","" 361162"","" 61084"","" 67842"","" 61924"","" 60865"","" 60871"","" 61388"","" 61747"","" 67641"","" 25028"","" 315282"","" 315281"","" 25039"","" 67638"","" 61351"","" 60912"","" 61237"","" 199153"","" 314773"","" 25071"","" 67752"","" 67762"","" 25096"","" 199151"","" 61859"","" 60942"","" 61456"","" 60855"","" 334132"","" 60856"","" 61232"","" 433752"","" 433751"","" 441382"","" 441381"","" 61091"","" 293884"","" 61172"","" 62030"","" 61658"","" 61794"","" 61256"","" 61111"","" 61085"","" 61086"","" 62008"","" 61014"","" 25010"","" 67797"","" 56332"","" 61449"","" 61221"","" 61194"","" 61434"","" 61876"","" 67679"","" 25001"","" 67843"","" 62198"","" 293363"","" 62176"","" 61157"","" 433830"","" 60905"","" 4150"","" 200424"","" 200425"","" 200426"","" 200422"","" 61465"","" 67745"","" 25216"","" 60854"","" 62102"","" 61231"","" 55971"","" 373239"","" 373238"","" 318262"","" 373245"","" 373244"","" 4155"","" 6618"","" 62181"","" 963"","" 52386"","" 388300"","" 388301"","" 61491"","" 61771"","" 60986"","" 60931"","" 61254"","" 61428"","" 61844"","" 61935"","" 61719"","" 62190"","" 413875"","" 414050"","" 414041"","" 414042"","" 414101"","" 422377"","" 422356"","" 422357"","" 61407"","" 62160"","" 311145"","" 61075"","" 61802"","" 61803"","" 61941"","" 61781"","" 322971"","" 322973"","" 322975"","" 322972"","" 322974"","" 552"","" 553"","" 61925"","" 62094"","" 61552"","" 61649"","" 61768"","" 25167"","" 67849"","" 200316"","" 202416"","" 331140"","" 318507"","" 59660"","" 318243"","" 199018"","" 198157"","" 53629"","" 56140"","" 293961"","" 318241"","" 318242"","" 57948"","" 324964"","" 319842"","" 322958"","" 203285"","" 319853"","" 202564"","" 53752"","" 59661"","" 57278"","" 61343"","" 61624"","" 61611"","" 60932"","" 200232"","" 25044"","" 67691"","" 293349"","" 293393"","" 70533"","" 70519"","" 61629"","" 62029"","" 61078"","" 62104"","" 315133"","" 61330"","" 62210"","" 62180"","" 61893"","" 61255"","" 61739"","" 61429"","" 61461"","" 61822"","" 67547"","" 61940"","" 61819"","" 62149"","" 351258"","" 61867"","" 61114"","" 67704"","" 25189"","" 61654"","" 62156"","" 67671"","" 62014"","" 61831"","" 62128"","" 61340"","" 61838"","" 25226"","" 62218"","" 61183"","" 61805"","" 61374"","" 61293"","" 61713"","" 61885"","" 293367"","" 336497"","" 61313"","" 61113"","" 61864"","" 61657"","" 60859"","" 60978"","" 535"","" 24994"","" 67611"","" 61672"","" 67749"","" 24984"","" 67750"","" 24983"","" 24989"","" 67796"","" 24988"","" 67791"","" 62058"","" 61182"","" 323285"","" 2721"","" 61171"","" 61081"","" 61998"","" 61290"","" 61229"","" 61324"","" 61286"","" 60930"","" 62172"","" 62171"","" 379009"","" 379008"","" 379015"","" 441793"","" 441774"","" 441775"","" 442011"","" 442003"","" 442004"","" 381216"","" 442226"","" 381190"","" 442223"","" 442222"","" 381189"","" 381188"","" 441801"","" 375947"","" 376028"","" 441391"","" 441392"","" 376962"","" 376961"","" 377967"","" 377963"","" 377964"","" 377965"","" 375933"","" 375932"","" 376034"","" 376035"","" 61811"","" 62174"","" 61850"","" 201235"","" 315261"","" 201236"","" 61837"","" 358837"","" 358836"","" 67648"","" 25233"","" 61908"","" 25003"","" 61683"","" 62053"","" 62147"","" 61829"","" 4958"","" 4959"","" 61661"","" 62152"","" 61162"","" 60985"","" 60982"","" 60857"","" 61276"","" 61772"","" 62071"","" 60988"","" 61549"","" 62203"","" 361265"","" 361264"","" 61957"","" 61071"","" 61789"","" 61738"","" 62035"","" 61835"","" 60997"","" 67637"","" 25163"","" 61572"","" 61833"","" 61635"","" 333946"","" 61484"","" 61385"","" 61384"","" 62001"","" 61827"","" 12288"","" 25207"","" 2727"","" 25051"","" 67658"","" 62130"","" 62129"","" 67736"","" 2479"","" 61603"","" 61115"","" 61004"","" 335522"","" 335521"","" 61274"","" 61504"","" 62089"","" 61285"","" 62164"","" 351121"","" 350979"","" 336351"","" 358108"","" 358109"","" 198181"","" 293388"","" 199138"","" 26571"","" 67581"","" 61861"","" 61754"","" 61967"","" 62090"","" 61892"","" 67685"","" 25084"","" 61243"","" 25169"","" 68076"","" 358084"","" 358083"","" 358088"","" 358087"","" 62191"","" 61116"","" 60881"","" 2729"","" 359344"","" 61317"","" 60841"","" 61871"","" 327969"","" 67674"","" 323095"","" 329951"","" 403562"","" 403563"","" 330033"","" 310825"","" 310826"","" 338957"","" 372610"","" 372611"","" 67713"","" 25067"","" 60830"","" 68088"","" 67647"","" 159195"","" 293374"","" 296791"","" 199601"","" 203712"","" 199600"","" 203711"","" 199603"","" 199602"","" 203713"","" 203714"","" 61233"","" 25218"","" 25219"","" 25223"","" 25222"","" 25220"","" 25221"","" 60920"","" 61139"","" 61020"","" 61926"","" 62133"","" 62081"","" 62080"","" 62222"","" 61294"","" 61318"","" 60880"","" 62188"","" 62126"","" 61451"","" 61265"","" 358874"","" 358875"","" 324960"","" 53762"","" 5140"","" 56329"","" 60458"","" 60461"","" 60462"","" 60463"","" 53813"","" 57279"","" 52936"","" 61945"","" 294039"","" 239141"","" 293745"","" 310827"","" 310828"","" 378930"","" 378931"","" 390284"","" 390283"","" 351413"","" 62142"","" 67700"","" 25000"","" 61647"","" 61427"","" 60949"","" 61628"","" 61644"","" 60858"","" 61529"","" 61479"","" 61890"","" 61144"","" 61933"","" 61900"","" 67773"","" 25114"","" 25151"","" 67809"","" 25152"","" 67765"","" 61842"","" 382516"","" 382517"","" 61817"","" 61870"","" 61939"","" 67857"","" 62115"","" 61605"","" 61356"","" 61401"","" 61464"","" 61436"","" 61297"","" 62185"","" 430800"","" 430801"","" 329927"","" 60969"","" 61312"","" 323655"","" 336422"","" 388011"","" 388008"","" 388010"","" 388009"","" 388007"","" 388006"","" 388005"","" 368144"","" 368145"","" 368151"","" 368150"","" 374609"","" 374891"","" 368304"","" 368146"","" 368148"","" 67705"","" 67701"","" 67680"","" 67715"","" 67707"","" 67706"","" 200209"","" 62095"","" 296676"","" 296675"","" 62004"","" 61206"","" 360136"","" 301512"","" 293358"","" 25187"","" 67744"","" 200191"","" 200192"","" 24995"","" 67619"","" 431489"","" 431490"","" 431499"","" 371972"","" 371971"","" 432763"","" 432828"","" 432827"","" 432825"","" 432826"","" 372187"","" 372186"","" 372188"","" 372614"","" 433374"","" 372711"","" 372708"","" 372707"","" 372713"","" 433364"","" 433363"","" 62135"","" 26783"","" 61360"","" 61477"","" 61302"","" 61492"","" 61824"","" 61524"","" 61650"","" 61548"","" 61287"","" 61687"","" 61952"","" 61474"","" 61574"","" 2688"","" 61224"","" 62197"","" 61303"","" 335605"","" 61215"","" 61878"","" 293380"","" 359460"","" 359461"","" 359848"","" 359849"","" 373982"","" 373983"","" 374159"","" 437010"","" 437009"","" 437008"","" 374450"","" 374449"","" 438972"","" 438661"","" 438659"","" 438658"","" 374601"","" 374600"","" 438927"","" 438906"","" 438905"","" 438654"","" 438655"","" 374877"","" 374876"","" 373926"","" 436719"","" 436718"","" 436715"","" 436716"","" 373984"","" 347180"","" 347181"","" 55937"","" 61272"","" 360881"","" 360882"","" 360040"","" 360041"","" 370987"","" 370988"","" 375930"","" 375931"","" 405900"","" 405901"","" 374176"","" 374177"","" 374885"","" 374884"","" 359759"","" 359758"","" 370251"","" 370253"","" 67838"","" 372184"","" 372185"","" 373509"","" 373510"","" 372710"","" 372709"","" 371966"","" 371965"","" 371522"","" 371521"","" 360134"","" 360135"","" 368121"","" 368120"","" 372089"","" 372088"","" 373988"","" 373989"","" 374598"","" 374597"","" 67820"","" 61143"","" 353732"","" 62120"","" 61358"","" 61359"","" 61152"","" 62049"","" 61153"","" 376926"","" 376927"","" 316441"","" 336410"","" 61024"","" 62036"","" 61906"","" 61707"","" 62148"","" 61891"","" 61202"","" 198425"","" 70488"","" 382463"","" 371490"","" 382464"","" 60888"","" 62078"","" 62088"","" 61993"","" 61222"","" 61573"","" 62206"","" 61792"","" 61074"","" 61467"","" 61454"","" 61485"","" 61709"","" 61156"","" 61662"","" 67605"","" 62123"","" 61751"","" 62019"","" 60972"","" 62082"","" 373869"","" 26499"","" 24991"","" 61439"","" 61414"","" 350881"","" 330788"","" 335614"","" 335615"","" 338870"","" 61783"","" 61534"","" 61715"","" 374137"","" 374136"","" 61946"","" 296246"","" 3659"","" 239133"","" 239135"","" 25225"","" 61117"","" 67688"","" 24997"","" 61003"","" 356674"","" 356673"","" 337039"","" 62143"","" 67710"","" 25042"","" 25164"","" 67634"","" 2348"","" 60924"","" 25006"","" 67621"","" 61671"","" 61560"","" 61497"","" 61834"","" 61679"","" 61535"","" 358922"","" 358923"","" 61468"","" 25038"","" 67686"","" 61609"","" 61005"","" 62186"","" 67693"","" 25034"","" 61546"","" 61051"","" 60903"","" 297258"","" 239134"","" 67568"","" 294208"","" 294223"","" 239136"","" 61542"","" 61386"","" 61777"","" 61760"","" 61922"","" 200427"","" 663662"","" 663661"","" 60870"","" 62112"","" 60925"","" 60944"","" 61883"","" 61521"","" 61586"","" 25142"","" 67732"","" 25143"","" 67657"","" 350970"","" 60879"","" 301513"","" 62212"","" 202230"","" 356277"","" 310236"","" 338991"","" 60998"","" 199108"","" 199109"","" 200041"","" 200912"","" 61659"","" 62083"","" 61284"","" 61426"","" 62141"","" 61999"","" 25705"","" 67608"","" 62028"","" 62066"","" 61743"","" 61550"","" 25203"","" 67852"","" 203806"","" 61107"","" 61757"","" 335096"","" 377866"","" 334559"","" 335095"","" 337122"","" 335094"","" 334030"","" 62121"","" 61857"","" 60913"","" 67651"","" 25206"","" 25129"","" 67776"","" 351300"","" 338872"","" 62096"","" 307526"","" 307531"","" 373967"","" 373968"","" 61593"","" 359418"","" 359774"","" 298158"","" 298159"","" 298160"","" 67874"","" 25088"","" 368663"","" 368664"","" 432772"","" 432773"","" 432707"","" 432706"","" 335582"","" 12719"","" 307525"","" 333379"","" 433422"","" 433421"","" 333380"","" 441968"","" 441969"","" 433806"","" 433805"","" 336449"","" 663901"","" 663900"","" 293074"","" 335577"","" 61437"","" 356485"","" 358219"","" 370229"","" 370230"","" 367750"","" 67836"","" 25217"","" 346493"","" 346492"","" 337060"","" 58413"","" 368004"","" 368007"","" 60727"","" 58417"","" 60734"","" 61695"","" 368980"","" 61847"","" 331031"","" 238804"","" 61282"","" 25004"","" 67542"","" 61721"","" 663867"","" 663866"","" 367964"","" 367965"","" 383957"","" 25066"","" 67783"","" 332135"","" 297182"","" 298144"","" 298339"","" 411851"","" 411850"","" 316532"","" 316533"","" 62100"","" 61977"","" 315058"","" 402999"","" 402985"","" 402984"","" 403407"","" 403378"","" 403377"","" 60991"","" 5310"","" 323671"","" 67602"","" 67817"","" 62034"","" 67848"","" 61032"","" 61478"","" 392149"","" 392148"","" 396234"","" 396216"","" 396215"","" 398204"","" 398200"","" 398201"","" 401854"","" 401846"","" 401838"","" 401837"","" 392156"","" 327840"","" 61779"","" 61054"","" 26880"","" 387845"","" 387846"","" 387848"","" 387847"","" 293479"","" 67687"","" 25005"","" 62124"","" 61267"","" 67858"","" 61083"","" 61954"","" 67560"","" 315108"","" 433573"","" 433572"","" 25061"","" 67636"","" 61155"","" 61773"","" 332074"","" 315057"","" 332071"","" 372699"","" 372700"","" 307483"","" 61103"","" 62040"","" 298259"","" 67856"","" 335581"","" 67863"","" 25049"","" 61321"","" 62228"","" 300971"","" 377859"","" 377860"","" 199139"","" 295311"","" 61625"","" 315321"","" 62219"","" 67819"","" 25030"","" 61462"","" 61879"","" 61432"","" 61579"","" 25236"","" 60980"","" 61915"","" 61668"","" 61592"","" 67683"","" 25094"","" 386932"","" 386933"","" 67613"","" 60822"","" 60821"","" 67628"","" 60823"","" 61230"","" 61566"","" 61128"","" 61006"","" 61463"","" 61815"","" 61519"","" 385877"","" 61761"","" 371321"","" 371322"","" 297850"","" 60957"","" 371422"","" 371421"","" 62111"","" 67742"","" 67740"","" 61279"","" 61278"","" 60945"","" 67698"","" 25021"","" 61226"","" 25183"","" 67543"","" 296677"","" 61435"","" 199110"","" 346447"","" 24977"","" 67573"","" 61007"","" 62020"","" 379002"","" 379001"","" 403265"","" 60999"","" 316510"","" 25202"","" 67653"","" 61536"","" 62193"","" 368715"","" 358085"","" 358086"","" 358038"","" 61932"","" 61818"","" 56653"","" 317211"","" 403121"","" 403122"","" 313395"","" 199167"","" 199762"","" 199143"","" 199761"","" 199168"","" 322993"","" 322992"","" 52056"","" 200231"","" 61613"","" 62054"","" 61558"","" 25180"","" 67596"","" 61897"","" 61916"","" 60926"","" 25108"","" 67760"","" 293402"","" 61395"","" 61848"","" 61419"","" 382689"","" 61025"","" 60937"","" 61578"","" 61486"","" 61580"","" 61631"","" 203461"","" 199423"","" 203460"","" 199422"","" 238691"","" 203573"","" 203572"","" 238719"","" 238692"","" 238720"","" 203465"","" 203464"","" 200774"","" 371935"","" 371934"","" 442237"","" 442236"","" 370932"","" 370933"","" 52499"","" 67787"","" 25106"","" 199509"","" 199624"","" 199625"","" 199502"","" 199499"","" 199498"","" 204038"","" 204037"","" 199524"","" 199525"","" 203803"","" 203802"","" 199528"","" 203467"","" 203466"","" 199425"","" 199529"","" 199424"","" 199534"","" 199535"","" 199540"","" 199541"","" 199542"","" 199543"","" 199548"","" 199549"","" 199562"","" 199563"","" 238735"","" 199503"","" 199582"","" 199583"","" 199584"","" 199585"","" 199506"","" 238734"","" 199507"","" 199508"","" 199604"","" 199605"","" 204111"","" 204110"","" 199596"","" 199538"","" 199564"","" 199539"","" 199577"","" 199597"","" 199576"","" 199573"","" 199572"","" 199565"","" 199512"","" 199513"","" 339119"","" 199715"","" 199714"","" 199637"","" 199636"","" 199631"","" 199630"","" 334010"","" 334011"","" 334012"","" 334013"","" 199609"","" 199608"","" 199607"","" 199606"","" 199595"","" 199594"","" 339121"","" 199581"","" 199580"","" 339120"","" 339118"","" 309970"","" 309971"","" 309975"","" 309976"","" 309977"","" 309978"","" 309980"","" 309981"","" 309982"","" 309983"","" 309995"","" 309996"","" 336049"","" 336048"","" 296128"","" 199610"","" 199611"","" 296129"","" 25093"","" 67668"","" 24985"","" 12100"","" 67751"","" 62220"","" 25153"","" 67703"","" 299305"","" 327652"","" 332072"","" 315883"","" 359262"","" 359261"","" 372695"","" 372696"","" 335596"","" 335595"","" 200307"","" 62177"","" 61601"","" 61030"","" 25026"","" 67792"","" 61271"","" 12691"","" 203358"","" 203357"","" 239052"","" 67649"","" 67650"","" 61200"","" 61220"","" 62223"","" 296510"","" 52159"","" 67544"","" 62109"","" 57273"","" 53764"","" 7341"","" 53827"","" 56139"","" 58414"","" 52832"","" 61026"","" 61242"","" 61970"","" 61381"","" 201294"","" 201295"","" 62013"","" 297837"","" 60860"","" 61643"","" 25124"","" 67784"","" 61398"","" 60958"","" 329926"","" 62225"","" 293381"","" 67591"","" 25122"","" 61853"","" 59374"","" 62153"","" 68053"","" 60797"","" 70489"","" 293383"","" 62202"","" 61623"","" 61417"","" 373643"","" 373644"","" 61581"","" 359239"","" 359240"","" 329952"","" 663591"","" 61759"","" 373246"","" 373247"","" 373250"","" 373251"","" 373255"","" 373254"","" 373259"","" 373258"","" 60835"","" 402972"","" 402971"","" 61540"","" 61886"","" 202139"","" 336421"","" 61361"","" 61795"","" 438876"","" 61097"","" 62021"","" 25031"","" 67625"","" 61506"","" 61338"","" 61470"","" 297248"","" 297247"","" 433372"","" 433373"","" 293593"","" 61976"","" 373531"","" 373532"","" 61383"","" 61352"","" 359592"","" 359593"","" 60868"","" 373969"","" 373970"","" 378842"","" 378841"","" 378844"","" 378843"","" 347188"","" 347187"","" 67631"","" 67652"","" 25168"","" 8640"","" 329919"","" 329918"","" 4718"","" 61039"","" 61710"","" 199527"","" 199627"","" 199626"","" 199566"","" 199567"","" 296077"","" 199530"","" 199531"","" 203805"","" 199612"","" 199578"","" 199521"","" 199579"","" 199501"","" 199520"","" 199511"","" 199510"","" 199500"","" 203804"","" 199526"","" 199613"","" 296078"","" 67818"","" 293966"","" 61630"","" 367805"","" 367806"","" 315291"","" 315292"","" 298135"","" 359093"","" 359092"","" 61373"","" 61843"","" 62046"","" 61441"","" 61813"","" 61896"","" 61291"","" 321132"","" 60938"","" 61389"","" 413655"","" 61158"","" 61367"","" 61648"","" 62055"","" 300192"","" 60893"","" 61015"","" 61975"","" 61963"","" 61937"","" 67716"","" 25165"","" 315134"","" 67689"","" 25036"","" 61043"","" 61868"","" 61821"","" 60875"","" 62204"","" 61500"","" 61370"","" 60983"","" 61217"","" 61487"","" 374038"","" 374037"","" 61953"","" 380145"","" 380146"","" 67607"","" 332860"","" 61812"","" 353720"","" 315111"","" 389032"","" 353695"","" 385879"","" 199126"","" 61653"","" 3944"","" 60933"","" 61554"","" 25091"","" 67780"","" 61530"","" 61723"","" 61730"","" 367822"","" 62230"","" 62047"","" 12309"","" 12311"","" 12310"","" 12308"","" 61801"","" 430706"","" 430707"","" 62003"","" 60906"","" 61714"","" 61972"","" 67861"","" 25213"","" 67833"","" 60966"","" 25111"","" 67632"","" 373081"","" 373080"","" 373082"","" 373083"","" 67771"","" 25150"","" 61029"","" 61799"","" 311170"","" 62075"","" 311173"","" 62173"","" 25070"","" 24987"","" 67865"","" 293373"","" 382539"","" 382538"","" 356456"","" 356457"","" 61790"","" 61808"","" 61839"","" 61637"","" 61008"","" 60861"","" 61334"","" 296851"","" 296858"","" 296859"","" 61365"","" 431151"","" 431150"","" 61785"","" 61047"","" 60979"","" 60840"","" 61875"","" 25027"","" 67793"","" 61109"","" 61865"","" 61027"","" 67718"","" 25115"","" 56572"","" 239218"","" 61234"","" 61921"","" 61380"","" 62091"","" 60894"","" 61262"","" 61617"","" 62031"","" 387946"","" 387945"","" 59153"","" 370864"","" 370863"","" 337321"","" 373572"","" 337320"","" 373610"","" 373611"","" 370865"","" 3010"","" 61150"","" 61424"","" 386936"","" 388303"","" 663806"","" 663803"","" 663804"","" 388273"","" 388274"","" 388275"","" 663883"","" 389891"","" 663877"","" 663876"","" 389888"","" 389887"","" 389892"","" 386931"","" 386930"","" 386934"","" 386961"","" 25185"","" 67574"","" 67642"","" 61133"","" 60952"","" 438870"","" 316044"","" 61118"","" 441464"","" 663820"","" 316306"","" 346511"","" 346510"","" 61682"","" 61901"","" 62122"","" 61735"","" 61404"","" 61197"","" 62167"","" 62166"","" 61159"","" 433526"","" 433528"","" 433625"","" 433627"","" 433517"","" 433518"","" 61764"","" 61480"","" 61459"","" 62214"","" 61557"","" 62072"","" 61563"","" 61599"","" 67597"","" 25002"","" 61141"","" 61208"","" 62017"","" 61125"","" 61124"","" 61166"","" 61040"","" 61889"","" 61126"","" 62061"","" 61057"","" 60862"","" 62151"","" 61841"","" 62087"","" 61165"","" 368064"","" 316309"","" 200420"","" 358123"","" 358124"","" 359909"","" 359910"","" 360857"","" 360856"","" 359464"","" 359463"","" 360441"","" 360442"","" 359391"","" 359390"","" 359675"","" 359676"","" 389893"","" 403561"","" 368658"","" 368129"","" 368874"","" 373694"","" 373692"","" 360883"","" 61746"","" 318712"","" 442765"","" 663607"","" 442764"","" 663608"","" 663824"","" 663823"","" 442423"","" 389106"","" 442422"","" 61836"","" 61664"","" 61663"","" 61633"","" 60878"","" 62136"","" 61986"","" 433574"","" 433575"","" 56227"","" 52156"","" 61618"","" 25178"","" 67654"","" 300330"","" 368966"","" 368965"","" 61251"","" 61392"","" 61854"","" 61996"","" 12618"","" 61048"","" 61397"","" 61120"","" 61241"","" 61104"","" 319084"","" 334454"","" 199166"","" 67694"","" 24982"","" 67640"","" 25053"","" 62169"","" 62084"","" 61767"","" 61077"","" 61568"","" 60836"","" 61636"","" 61846"","" 62057"","" 61098"","" 61591"","" 61960"","" 61132"","" 62162"","" 61705"","" 61537"","" 61753"","" 61493"","" 61737"","" 61442"","" 61641"","" 367984"","" 339101"","" 339100"","" 202226"","" 61320"","" 61378"","" 67570"","" 203902"","" 61225"","" 61185"","" 202229"","" 200101"","" 301400"","" 62060"","" 62134"","" 334536"","" 319887"","" 315322"","" 663649"","" 663650"","" 333953"","" 338821"","" 346674"","" 357921"","" 315107"","" 60934"","" 61742"","" 373709"","" 373710"","" 373711"","" 373712"","" 373714"","" 373713"","" 373716"","" 373715"","" 60907"","" 60863"","" 333945"","" 61134"","" 61559"","" 61067"","" 336412"","" 61676"","" 62079"","" 293714"","" 61238"","" 60928"","" 25035"","" 67695"","" 62108"","" 61959"","" 61193"","" 62022"","" 60963"","" 25105"","" 67546"","" 359150"","" 359151"","" 318715"","" 383560"","" 383559"","" 387843"","" 387842"","" 359725"","" 359724"","" 318716"","" 318717"","" 335749"","" 402912"","" 402913"","" 300895"","" 61607"","" 61971"","" 60864"","" 61860"","" 67692"","" 25048"","" 61627"","" 60973"","" 62076"","" 67639"","" 61855"","" 61168"","" 62170"","" 61731"","" 396244"","" 315806"","" 315807"","" 67876"","" 25100"","" 61755"","" 61357"","" 58415"","" 369030"","" 369031"","" 369033"","" 369032"","" 367908"","" 367909"","" 368986"","" 61257"","" 61499"","" 61337"","" 61299"","" 61406"","" 61588"","" 61058"","" 414692"","" 414697"","" 414698"","" 414699"","" 335528"","" 335529"","" 62229"","" 61923"","" 61053"","" 339005"","" 61782"","" 25013"","" 67756"","" 67864"","" 61405"","" 61130"","" 368169"","" 359339"","" 361180"","" 370231"","" 359343"","" 359336"","" 370266"","" 359278"","" 360917"","" 359329"","" 61396"","" 61800"","" 61041"","" 60955"","" 61177"","" 61724"","" 61688"","" 61420"","" 62140"","" 67827"","" 315179"","" 318500"","" 68060"","" 67879"","" 67730"","" 67724"","" 67672"","" 67618"","" 67577"","" 67576"","" 67556"","" 62227"","" 351266"","" 351366"","" 61148"","" 25232"","" 25231"","" 25214"","" 25212"","" 25205"","" 25126"","" 442425"","" 442426"","" 24986"","" 12702"","" 25104"","" 67727"","" 351268"","" 351267"","" 331839"","" 293387"","" 294025"","" 300350"","" 67578"","" 200129"","" 368136"","" 67616"","" 199415"","" 316546"","" 67869"","" 67567"","" 430340"","" 373037"","" 373038"","" 323488"","" 323489"","" 323490"","" 67554"","" 159034"","" 67624"","" 67563"","" 67880"","" 67881"","" 199633"","" 199614"","" 296058"","" 199632"","" 199615"","" 296057"","" 3524"","" 199619"","" 199618"","" 199617"","" 199616"","" 238724"","" 238723"","" 199046"","" 25089"","" 67728"","" 3824"","" 312220"","" 312223"","" 334441"","" 389059"","" 389058"","" 67803"","" 25112"","" 336457"","" 59490"","" 67847"","" 67845"","" 67729"","" 25123"","" 441154"","" 2279"","" 335580"","" 335579"","" 335587"","" 335586"","" 335589"","" 335588"","" 338964"","" 398211"","" 200125"","" 67566"","" 199115"","" 438875"","" 59318"","" 350971"","" 67839"","" 67844"","" 159033"","" 334750"","" 199146"","" 2726"","" 25210"","" 67831"","" 403188"","" 403187"","" 238355"","" 203642"","" 294171"","" 392497"","" 313396"","" 368633"","" 368634"","" 350874"","" 350875"","" 298302"","" 67564"","" 52837"","" 53421"","" 323257"","" 198377"","" 332137"","" 358838"","" 358839"","" 25087"","" 67702"","" 239211"","" 351324"","" 351325"","" 5074"","" 67746"","" 67580"","" 67541"","" 70626"","" 67832"","" 67834"","" 67835"","" 4716"","" 59659"","" 53564"","" 58338"","" 159031"","" 67837"","" 293366"","" 333372"","" 335600"","" 431323"","" 431324"","" 433948"","" 433947"","" 53815"","" 310045"","" 337863"","" 68198"","" 199191"","" 2159"","" 200047"","" 56432"","" 239040"","" 201711"","" 307478"","" 67846"","" 358761"","" 358760"","" 25109"","" 67720"","" 318688"","" 67723"","" 25064"","" 293370"","" 296432"","" 67540"","" 293375"","" 370267"","" 372617"","" 372618"","" 25154"","" 67617"","" 67676"","" 25063"","" 25156"","" 297940"","" 300193"","" 389105"","" 293356"","" 67738"","" 67731"","" 356761"","" 310961"","" 369061"","" 368014"","" 368015"","" 369062"","" 67579"","" 371947"","" 371946"","" 372751"","" 372752"","" 67675"","" 387856"","" 67759"","" 387855"","" 25157"","" 25158"","" 663693"","" 663694"","" 67737"","" 25107"","" 200399"","" 359188"","" 359187"","" 296222"","" 67549"","" 25171"","" 67721"","" 25011"","" 25173"","" 67550"","" 7419"","" 67659"","" 293352"","" 25125"","" 67800"","" 25128"","" 67825"","" 399799"","" 360161"","" 360162"","" 67606"","" 438619"","" 373608"","" 373607"","" 335599"","" 67747"","" 67748"","" 57947"","" 60744"","" 310100"","" 310484"","" 199122"","" 67598"","" 6406"","" 25193"","" 67599"","" 25194"","" 67600"","" 67601"","" 25195"","" 373866"","" 25098"","" 67726"","" 25092"","" 67735"","" 67867"","" 25095"","" 67866"","" 25097"","" 316166"","" 297418"","" 59315"","" 297183"","" 663603"","" 59082"","" 159032"","" 5058"","" 312374"","" 300962"","" 318244"","" 239215"","" 53766"","" 59317"","" 59314"","" 314962"","" 371128"","" 52836"","" 323533"","" 323534"","" 323535"","" 323536"","" 298163"","" 298164"","" 298165"","" 59316"","" 59050"","" 59051"","" 59467"","" 58398"","" 203380"","" 293339"","" 307603"","" 25110"","" 67722"","" 60962"","" 67678"","" 25016"","" 61178"","" 61283"","" 61072"","" 61188"","" 61446"","" 25196"","" 67725"","" 61501"","" 61326"","" 61379"","" 60977"","" 351414"","" 61112"","" 61448"","" 61016"","" 61036"","" 61096"","" 61947"","" 373415"","" 373414"","" 25015"","" 67753"","" 61443"","" 25148"","" 67690"","" 61223"","" 67633"","" 24990"","" 25197"","" 67815"","" 61690"","" 62033"","" 25162"","" 67603"","" 61065"","" 61064"","" 61063"","" 61154"","" 61066"","" 60967"","" 60968"","" 61845"","" 61899"","" 60914"","" 62044"","" 67830"","" 25103"","" 61240"","" 62009"","" 307249"","" 431379"","" 431380"","" 60908"","" 62093"","" 60953"","" 25022"","" 67882"","" 61888"","" 62183"","" 62006"","" 61680"","" 25224"","" 67854"","" 61022"","" 61701"","" 61310"","" 61311"","" 60992"","" 60984"","" 61652"","" 61145"","" 61169"","" 62168"","" 67712"","" 25079"","" 61830"","" 61164"","" 62139"","" 61528"","" 61978"","" 61415"","" 61142"","" 61585"","" 61371"","" 61531"","" 61545"","" 61512"","" 61513"","" 61518"","" 61517"","" 61516"","" 61515"","" 61514"","" 61510"","" 61511"","" 335461"","" 335462"","" 335490"","" 335489"","" 335491"","" 335492"","" 335494"","" 335493"","" 335496"","" 335495"","" 335498"","" 335497"","" 335500"","" 335499"","" 335464"","" 335463"","" 335465"","" 335466"","" 335468"","" 335467"","" 335470"","" 335469"","" 335485"","" 335486"","" 335471"","" 335472"","" 335474"","" 335473"","" 335484"","" 335483"","" 335488"","" 335487"","" 373586"","" 373587"","" 60915"","" 61069"","" 61489"","" 61758"","" 61127"","" 62025"","" 61353"","" 301399"","" 25229"","" 300712"","" 61322"","" 61602"","" 60909"","" 61778"","" 61733"","" 61094"","" 61146"","" 67790"","" 25146"","" 61319"","" 61042"","" 61175"","" 359367"","" 359366"","" 67823"","" 61626"","" 3265"","" 61903"","" 438673"","" 438678"","" 25240"","" 61995"","" 70631"","" 61344"","" 61236"","" 61595"","" 60918"","" 61163"","" 61375"","" 60886"","" 61882"","" 61180"","" 61281"","" 377833"","" 377832"","" 67816"","" 25078"","" 25069"","" 67741"","" 61997"","" 361258"","" 376901"","" 60946"","" 61619"","" 60844"","" 61569"","" 60947"","" 60843"","" 61877"","" 60839"","" 61201"","" 60923"","" 61192"","" 337245"","" 67623"","" 25017"","" 25188"","" 67677"","" 67855"","" 67635"","" 61390"","" 388036"","" 388035"","" 390356"","" 390357"","" 67936"","" 25230"","" 359492"","" 359493"","" 334508"","" 293888"","" 60948"","" 200423"","" 62119"","" 293382"","" 70554"","" 663798"","" 62226"","" 3913"","" 53814"","" 3780"","" 372772"","" 318260"","" 59045"","" 59048"","" 52833"","" 58416"","" 60600"","" 52834"","" 60601"","" 323647"","" 323648"","" 323646"","" 58412"","" 59465"","" 327619"","" 327653"","" 56573"","" 327731"","" 52831"","" 376971"","" 376976"","" 375951"","" 374769"","" 7340"","" 55964"","" 68185"","" 68192"","" 53751"","" 55938"","" 56331"","" 56330"","" 200195"","" 200194"","" 59047"","" 53765"","" 59049"","" 200197"","" 68151"","" 331106"","" 53912"","" 300956"","" 62048"","" 2361"","" 2365"","" 2364"","" 61239"","" 61496"","" 61505"","" 60837"","" 61252"","" 61621"","" 61894"","" 25052"","" 67764"","" 61693"","" 61046"","" 339004"","" 61481"","" 60715"","" 67557"","" 296243"","" 296225"","" 67853"","" 61934"","" 333848"","" 333849"","" 61011"","" 61028"","" 61973"","" 62043"","" 61874"","" 60959"","" 62201"","" 61364"","" 61277"","" 61034"","" 61911"","" 62070"","" 61992"","" 60935"","" 297255"","" 297256"","" 60832"","" 68085"","" 61147"","" 61207"","" 60975"","" 61788"","" 2745"","" 67743"","" 25200"","" 60866"","" 61136"","" 61131"","" 60993"","" 67859"","" 24998"","" 61667"","" 373293"","" 373294"","" 61327"","" 62016"","" 67795"","" 25032"","" 433558"","" 433559"","" 433556"","" 433557"","" 327976"","" 67779"","" 25113"","" 61814"","" 61694"","" 61720"","" 325413"","" 325414"","" 325415"","" 60994"","" 61049"","" 70553"","" 293371"","" 60892"","" 61744"","" 61204"","" 61608"","" 61119"","" 61988"","" 61590"","" 61691"","" 61149"","" 61806"","" 61209"","" 61919"","" 60916"","" 62154"","" 200210"","" 61261"","" 61082"","" 374041"","" 67786"","" 25131"","" 67785"","" 25138"","" 25137"","" 67807"","" 67772"","" 25132"","" 67770"","" 25135"","" 67806"","" 25133"","" 61035"","" 61969"","" 199051"","" 359090"","" 359091"","" 60602"","" 199063"","" 368193"","" 368704"","" 57351"","" 62116"","" 323119"","" 335667"","" 60465"","" 60464"","" 371927"","" 371928"","" 60898"","" 61905"","" 62127"","" 61776"","" 61640"","" 317199"","" 317200"","" 25235"","" 67585"","" 199629"","" 199628"","" 199620"","" 199621"","" 199591"","" 199590"","" 199589"","" 199588"","" 199516"","" 199517"","" 199544"","" 199552"","" 199561"","" 199553"","" 199569"","" 199558"","" 199532"","" 199622"","" 199537"","" 199554"","" 199555"","" 199559"","" 199574"","" 199545"","" 199568"","" 199550"","" 199560"","" 199575"","" 199623"","" 199533"","" 199551"","" 199536"","" 199523"","" 199592"","" 199427"","" 199593"","" 199426"","" 199634"","" 199635"","" 199570"","" 199571"","" 203463"","" 199586"","" 199522"","" 199587"","" 203462"","" 199557"","" 238722"","" 238721"","" 296126"","" 296127"","" 199556"","" 199515"","" 199514"","" 199519"","" 199518"","" 67583"","" 319854"","" 67644"","" 67660"","" 67661"","" 67662"","" 67663"","" 67664"","" 59064"","" 67665"","" 202211"","" 202167"","" 202498"","" 293693"","" 62137"","" 335855"","" 368134"","" 368133"","" 359229"","" 359256"","" 293350"","" 60971"","" 334530"","" 334531"","" 334528"","" 371054"","" 371052"","" 315099"","" 332088"","" 296182""}'::text[])::integer[])) = ah.ap_payee_id)
  • Rows Removed by Join Filter: 55,615,186
  • Filter: (((unnest(('{67998,"" 310734"","" 436980"","" 201194"","" 202061"","" 367793"","" 373378"","" 26443"","" 377902"","" 377903"","" 199207"","" 663842"","" 318251"","" 296401"","" 353736"","" 353735"","" 353733"","" 350885"","" 310733"","" 293112"","" 315132"","" 346491"","" 315100"","" 293351"","" 389104"","" 293384"","" 293386"","" 293338"","" 307310"","" 68050"","" 334148"","" 318650"","" 293389"","" 293362"","" 369063"","" 369064"","" 294033"","" 323091"","" 370335"","" 370334"","" 370448"","" 370449"","" 332861"","" 334520"","" 293395"","" 293340"","" 337021"","" 337022"","" 293346"","" 307439"","" 298247"","" 315263"","" 332144"","" 25184"","" 67841"","" 358855"","" 157"","" 301661"","" 202231"","" 310728"","" 67999"","" 293392"","" 379880"","" 379892"","" 200705"","" 67565"","" 25172"","" 67812"","" 25127"","" 67719"","" 67810"","" 25179"","" 25208"","" 337040"","" 25209"","" 67821"","" 25134"","" 68079"","" 318169"","" 204092"","" 337108"","" 374392"","" 293377"","" 309985"","" 663786"","" 663787"","" 25055"","" 67870"","" 372140"","" 372139"","" 331153"","" 335780"","" 335808"","" 322963"","" 25082"","" 67875"","" 368735"","" 25155"","" 25211"","" 293372"","" 360074"","" 360073"","" 67802"","" 25136"","" 67555"","" 369066"","" 369065"","" 25149"","" 367785"","" 367784"","" 67645"","" 202236"","" 336494"","" 327584"","" 332127"","" 442365"","" 25056"","" 67799"","" 323090"","" 373684"","" 373683"","" 351008"","" 359361"","" 359363"","" 338891"","" 403380"","" 403379"","" 238678"","" 379017"","" 323110"","" 360428"","" 25057"","" 67587"","" 321112"","" 333828"","" 67805"","" 25059"","" 203820"","" 25081"","" 67761"","" 67754"","" 25083"","" 25058"","" 67798"","" 330000"","" 323430"","" 61173"","" 67551"","" 316217"","" 293113"","" 389033"","" 62012"","" 61235"","" 61780"","" 360811"","" 60950"","" 61507"","" 293348"","" 67789"","" 25099"","" 368886"","" 239219"","" 372138"","" 62007"","" 61736"","" 332158"","" 371043"","" 371044"","" 1538"","" 60467"","" 60466"","" 61784"","" 59063"","" 25144"","" 25145"","" 67763"","" 368149"","" 368147"","" 25116"","" 67794"","" 67769"","" 368648"","" 368649"","" 25119"","" 67767"","" 25130"","" 67808"","" 199416"","" 25140"","" 68004"","" 67673"","" 1711"","" 321113"","" 203863"","" 334429"","" 61105"","" 67643"","" 321114"","" 67777"","" 25029"","" 61577"","" 367760"","" 62062"","" 332076"","" 25014"","" 67778"","" 61944"","" 61411"","" 61670"","" 61880"","" 61928"","" 62050"","" 60887"","" 663616"","" 663617"","" 441996"","" 441997"","" 67766"","" 25008"","" 67582"","" 67878"","" 2872"","" 299292"","" 441736"","" 441735"","" 441984"","" 441892"","" 441985"","" 441893"","" 441987"","" 441986"","" 2347"","" 61770"","" 61769"","" 61186"","" 62015"","" 330867"","" 325411"","" 325412"","" 377962"","" 377961"","" 383983"","" 323296"","" 323295"","" 323294"","" 323293"","" 297835"","" 392126"","" 392127"","" 61296"","" 338459"","" 61917"","" 376954"","" 376955"","" 398172"","" 398173"","" 401847"","" 401848"","" 385906"","" 385907"","" 396208"","" 396209"","" 389860"","" 389861"","" 61983"","" 60889"","" 67604"","" 336825"","" 300485"","" 351482"","" 299289"","" 67758"","" 25076"","" 25074"","" 67656"","" 67782"","" 25072"","" 60633"","" 67553"","" 332911"","" 25238"","" 25075"","" 67559"","" 299285"","" 62184"","" 61288"","" 61980"","" 61673"","" 373243"","" 373242"","" 359600"","" 359599"","" 323649"","" 334496"","" 301669"","" 319852"","" 413768"","" 360962"","" 438869"","" 663858"","" 358936"","" 358929"","" 373577"","" 373578"","" 373579"","" 327663"","" 61807"","" 61526"","" 61260"","" 61594"","" 61708"","" 61887"","" 61620"","" 61076"","" 67868"","" 25023"","" 61712"","" 61711"","" 376952"","" 376953"","" 62199"","" 356361"","" 356362"","" 61686"","" 61227"","" 61010"","" 61450"","" 318253"","" 61339"","" 297421"","" 61187"","" 61869"","" 61305"","" 61270"","" 61315"","" 60921"","" 315110"","" 61176"","" 62085"","" 61964"","" 293067"","" 299283"","" 61765"","" 61791"","" 62196"","" 61248"","" 61786"","" 62159"","" 61399"","" 25234"","" 67622"","" 25237"","" 329940"","" 62097"","" 61199"","" 61393"","" 61394"","" 61539"","" 61099"","" 61918"","" 61453"","" 61962"","" 61502"","" 430314"","" 430315"","" 373237"","" 373236"","" 374581"","" 374582"","" 61909"","" 25118"","" 67774"","" 373571"","" 62194"","" 61100"","" 61942"","" 327736"","" 61203"","" 61140"","" 61902"","" 298258"","" 316440"","" 61912"","" 61741"","" 61884"","" 61408"","" 61246"","" 62163"","" 61179"","" 61342"","" 443557"","" 443556"","" 386937"","" 61387"","" 61355"","" 300194"","" 25204"","" 67593"","" 62146"","" 62145"","" 61073"","" 62213"","" 61749"","" 68078"","" 61247"","" 62157"","" 61301"","" 62211"","" 4950"","" 67626"","" 25019"","" 61851"","" 373454"","" 663874"","" 663875"","" 374465"","" 374466"","" 60722"","" 67558"","" 25040"","" 61732"","" 350911"","" 60970"","" 350910"","" 62059"","" 336370"","" 25239"","" 327749"","" 327748"","" 327747"","" 327746"","" 67872"","" 67877"","" 433821"","" 433820"","" 373277"","" 373281"","" 373276"","" 434147"","" 434134"","" 434133"","" 373506"","" 373505"","" 435337"","" 435316"","" 435317"","" 433831"","" 67584"","" 61000"","" 62187"","" 61639"","" 368011"","" 373877"","" 373876"","" 368010"","" 367993"","" 367997"","" 368000"","" 368001"","" 368008"","" 368009"","" 61031"","" 25077"","" 293053"","" 293054"","" 61520"","" 61766"","" 323087"","" 318176"","" 323086"","" 61775"","" 60987"","" 433527"","" 433628"","" 433529"","" 433626"","" 53420"","" 298138"","" 298137"","" 300484"","" 315285"","" 315286"","" 299291"","" 67883"","" 25161"","" 61825"","" 61810"","" 61823"","" 61706"","" 296790"","" 61685"","" 67669"","" 25020"","" 62067"","" 61849"","" 62131"","" 442650"","" 368748"","" 368747"","" 368739"","" 368740"","" 62195"","" 61306"","" 62155"","" 61121"","" 61366"","" 61852"","" 60833"","" 67595"","" 25192"","" 67699"","" 25120"","" 61314"","" 60899"","" 60846"","" 61717"","" 334131"","" 383642"","" 382649"","" 382636"","" 443467"","" 385923"","" 663647"","" 385908"","" 385909"","" 386868"","" 386867"","" 386866"","" 386865"","" 442577"","" 382652"","" 382631"","" 382632"","" 383649"","" 442574"","" 442575"","" 663638"","" 663639"","" 442618"","" 443465"","" 443464"","" 61400"","" 61331"","" 62209"","" 383644"","" 61646"","" 61017"","" 67739"","" 24999"","" 25198"","" 67860"","" 299290"","" 299284"","" 61135"","" 61341"","" 199269"","" 61840"","" 62000"","" 61412"","" 62092"","" 61038"","" 62018"","" 442573"","" 442572"","" 316526"","" 61345"","" 61697"","" 61216"","" 61961"","" 67667"","" 25065"","" 61473"","" 62150"","" 61263"","" 62158"","" 62086"","" 61910"","" 60877"","" 61991"","" 67612"","" 25159"","" 3214"","" 68064"","" 25147"","" 61050"","" 60989"","" 70578"","" 61985"","" 293066"","" 368403"","" 368402"","" 314971"","" 61564"","" 61604"","" 403219"","" 334001"","" 62073"","" 62106"","" 61634"","" 61129"","" 61106"","" 293378"","" 67871"","" 4907"","" 200842"","" 61309"","" 300325"","" 300326"","" 62005"","" 60845"","" 67590"","" 61958"","" 315262"","" 62098"","" 61061"","" 60890"","" 203847"","" 199504"","" 203848"","" 199505"","" 199546"","" 199547"","" 203801"","" 199497"","" 199496"","" 203570"","" 203571"","" 203574"","" 203575"","" 203776"","" 203777"","" 203800"","" 25215"","" 67592"","" 315870"","" 315871"","" 315873"","" 315872"","" 315874"","" 315875"","" 61828"","" 25054"","" 61316"","" 319855"","" 334095"","" 61547"","" 62189"","" 61210"","" 351448"","" 351447"","" 351465"","" 351466"","" 351450"","" 351449"","" 351451"","" 351452"","" 351453"","" 351454"","" 351455"","" 351456"","" 351458"","" 351457"","" 351459"","" 351460"","" 351461"","" 351462"","" 351463"","" 351464"","" 61651"","" 309986"","" 61181"","" 61266"","" 2100"","" 61600"","" 61137"","" 62107"","" 61974"","" 61948"","" 62179"","" 67552"","" 25043"","" 62074"","" 334527"","" 61490"","" 61762"","" 61704"","" 67717"","" 61409"","" 60872"","" 442463"","" 442464"","" 442465"","" 442466"","" 60874"","" 61931"","" 356770"","" 24996"","" 61895"","" 62064"","" 203431"","" 201208"","" 61013"","" 62027"","" 61101"","" 7344"","" 438727"","" 442623"","" 199048"","" 198243"","" 200317"","" 155"","" 158"","" 442624"","" 370268"","" 200134"","" 199847"","" 199270"","" 442625"","" 200140"","" 61508"","" 67572"","" 67571"","" 67588"","" 60848"","" 62063"","" 298303"","" 201207"","" 410628"","" 410627"","" 25045"","" 67997"","" 62010"","" 25018"","" 67646"","" 61457"","" 61458"","" 297253"","" 297254"","" 61981"","" 25174"","" 67709"","" 67814"","" 25177"","" 25176"","" 25175"","" 67813"","" 62023"","" 61444"","" 61482"","" 24992"","" 25102"","" 67873"","" 67696"","" 25060"","" 61088"","" 61198"","" 61727"","" 61253"","" 61269"","" 61268"","" 61259"","" 61700"","" 60847"","" 61055"","" 60885"","" 60884"","" 61354"","" 61729"","" 61369"","" 60842"","" 61122"","" 61734"","" 60927"","" 61167"","" 61413"","" 61589"","" 62039"","" 67609"","" 25007"","" 61349"","" 61196"","" 292887"","" 292888"","" 292898"","" 62182"","" 61858"","" 60900"","" 70598"","" 293385"","" 61678"","" 61089"","" 61189"","" 25024"","" 67545"","" 67610"","" 25181"","" 61056"","" 60883"","" 61950"","" 62192"","" 61920"","" 356831"","" 199127"","" 61615"","" 61421"","" 25086"","" 67627"","" 329269"","" 61681"","" 62231"","" 61984"","" 61402"","" 60882"","" 60873"","" 61522"","" 62178"","" 62144"","" 61292"","" 61037"","" 62051"","" 61333"","" 67734"","" 25101"","" 67757"","" 25062"","" 336371"","" 67615"","" 67614"","" 62161"","" 61350"","" 61677"","" 61809"","" 61793"","" 61570"","" 67708"","" 25199"","" 25201"","" 67929"","" 377890"","" 377889"","" 3942"","" 307484"","" 295312"","" 25139"","" 61982"","" 62125"","" 61336"","" 61756"","" 62052"","" 62024"","" 61804"","" 301401"","" 319860"","" 61363"","" 62056"","" 61698"","" 61087"","" 61699"","" 61543"","" 61523"","" 62200"","" 61562"","" 61245"","" 62117"","" 62101"","" 61907"","" 61138"","" 319882"","" 60867"","" 60896"","" 61544"","" 61597"","" 61466"","" 61632"","" 61431"","" 61541"","" 361156"","" 25041"","" 67822"","" 61575"","" 25080"","" 67781"","" 307248"","" 339223"","" 367835"","" 369122"","" 61460"","" 62041"","" 67840"","" 67851"","" 61362"","" 61898"","" 61797"","" 60849"","" 60940"","" 61509"","" 61748"","" 61160"","" 61913"","" 61416"","" 61418"","" 61726"","" 61012"","" 61289"","" 61249"","" 356432"","" 356454"","" 356436"","" 356438"","" 356440"","" 356444"","" 356446"","" 356448"","" 356450"","" 356452"","" 356433"","" 356455"","" 356434"","" 356435"","" 356437"","" 356439"","" 356441"","" 356445"","" 356447"","" 356449"","" 356451"","" 356453"","" 61079"","" 61787"","" 60901"","" 61205"","" 442035"","" 438868"","" 61674"","" 60850"","" 61475"","" 61638"","" 383672"","" 383673"","" 383674"","" 199598"","" 199599"","" 296055"","" 296056"","" 325416"","" 325417"","" 60904"","" 62068"","" 300958"","" 300957"","" 61440"","" 383562"","" 383561"","" 323350"","" 318714"","" 318713"","" 60981"","" 293394"","" 67620"","" 24979"","" 61452"","" 61018"","" 25012"","" 68062"","" 359359"","" 360133"","" 360132"","" 60951"","" 61763"","" 301670"","" 301671"","" 301672"","" 325421"","" 325420"","" 61873"","" 61422"","" 61423"","" 313394"","" 376902"","" 313393"","" 61538"","" 62205"","" 67575"","" 25047"","" 61949"","" 61325"","" 441615"","" 441614"","" 25121"","" 67775"","" 61090"","" 60954"","" 61866"","" 25046"","" 67562"","" 61774"","" 387829"","" 387828"","" 61938"","" 61956"","" 330053"","" 330052"","" 61184"","" 299973"","" 61684"","" 67629"","" 25141"","" 370199"","" 370200"","" 307577"","" 62175"","" 318130"","" 61696"","" 386793"","" 386792"","" 323292"","" 323291"","" 60851"","" 61258"","" 62221"","" 61382"","" 61445"","" 60852"","" 62105"","" 61872"","" 61832"","" 60976"","" 67788"","" 25050"","" 62077"","" 25068"","" 67755"","" 61740"","" 61323"","" 61174"","" 61308"","" 61214"","" 61346"","" 61567"","" 25751"","" 61023"","" 60834"","" 67548"","" 24980"","" 12530"","" 61494"","" 61645"","" 61298"","" 406940"","" 406936"","" 406935"","" 361173"","" 361172"","" 412212"","" 367767"","" 367766"","" 412203"","" 412204"","" 318513"","" 317213"","" 317214"","" 317215"","" 317212"","" 61307"","" 61796"","" 61610"","" 314623"","" 314624"","" 61965"","" 24978"","" 67714"","" 61702"","" 61190"","" 118"","" 130"","" 136"","" 154"","" 12099"","" 25170"","" 156"","" 120"","" 60786"","" 153"","" 152"","" 128"","" 295813"","" 295814"","" 67862"","" 200048"","" 332075"","" 67586"","" 359327"","" 359328"","" 359364"","" 359365"","" 59046"","" 6043"","" 307363"","" 60743"","" 57350"","" 61476"","" 61989"","" 330487"","" 358238"","" 358239"","" 61438"","" 199428"","" 53763"","" 59462"","" 67569"","" 60911"","" 61469"","" 61092"","" 67733"","" 25073"","" 60869"","" 307325"","" 61525"","" 239033"","" 61692"","" 62217"","" 60996"","" 25009"","" 67801"","" 316668"","" 60917"","" 61151"","" 61498"","" 61955"","" 61583"","" 61295"","" 62113"","" 61532"","" 67811"","" 25166"","" 62042"","" 61070"","" 60960"","" 61021"","" 62110"","" 61904"","" 61555"","" 61666"","" 24993"","" 382608"","" 358816"","" 358817"","" 62165"","" 61372"","" 2345"","" 61582"","" 25085"","" 67670"","" 358081"","" 358080"","" 2363"","" 61656"","" 67850"","" 24981"","" 61348"","" 61455"","" 67697"","" 25033"","" 61228"","" 61722"","" 61856"","" 67828"","" 67826"","" 61213"","" 61716"","" 61745"","" 61264"","" 61033"","" 382478"","" 382477"","" 382523"","" 382522"","" 61170"","" 61335"","" 61622"","" 61403"","" 60919"","" 61488"","" 61642"","" 60876"","" 61471"","" 301593"","" 60895"","" 61191"","" 25037"","" 67711"","" 60826"","" 350292"","" 310820"","" 310821"","" 293965"","" 60780"","" 202533"","" 199086"","" 61598"","" 60974"","" 61565"","" 293359"","" 293365"","" 61725"","" 61820"","" 62208"","" 61718"","" 61391"","" 61571"","" 61990"","" 53628"","" 61376"","" 356718"","" 61553"","" 67804"","" 61080"","" 62099"","" 2470"","" 370262"","" 61994"","" 60853"","" 61044"","" 61052"","" 61669"","" 61068"","" 61979"","" 57277"","" 61655"","" 61328"","" 61943"","" 61218"","" 430696"","" 430686"","" 430685"","" 370507"","" 370506"","" 430898"","" 430897"","" 430904"","" 371004"","" 371005"","" 431143"","" 431135"","" 431136"","" 430406"","" 430396"","" 430395"","" 370254"","" 370252"","" 60939"","" 62132"","" 61533"","" 62118"","" 61108"","" 61273"","" 7455"","" 52835"","" 315284"","" 315283"","" 61927"","" 61703"","" 25190"","" 67681"","" 61561"","" 60990"","" 61001"","" 61616"","" 61329"","" 61332"","" 61816"","" 61929"","" 61930"","" 367788"","" 62065"","" 61665"","" 60961"","" 351197"","" 351479"","" 60964"","" 61447"","" 61483"","" 293376"","" 61951"","" 62011"","" 61728"","" 61675"","" 61606"","" 61881"","" 334149"","" 296511"","" 60929"","" 61347"","" 62114"","" 61987"","" 61123"","" 25090"","" 67655"","" 61660"","" 329946"","" 329945"","" 329947"","" 329948"","" 329949"","" 67561"","" 67666"","" 25227"","" 293885"","" 318492"","" 61752"","" 61614"","" 61966"","" 61826"","" 324963"","" 60965"","" 61968"","" 319872"","" 61280"","" 368765"","" 61275"","" 61093"","" 60891"","" 61304"","" 61244"","" 61002"","" 61527"","" 61377"","" 335604"","" 61410"","" 61556"","" 62207"","" 62037"","" 61914"","" 61212"","" 61211"","" 61430"","" 61612"","" 61161"","" 62069"","" 60941"","" 367990"","" 367991"","" 367992"","" 315290"","" 315289"","" 315288"","" 315287"","" 315280"","" 315279"","" 25186"","" 61689"","" 199144"","" 371925"","" 336496"","" 62215"","" 61062"","" 61300"","" 61195"","" 61495"","" 60956"","" 61596"","" 67829"","" 316634"","" 61862"","" 61863"","" 373701"","" 373702"","" 373703"","" 373704"","" 373705"","" 373706"","" 373708"","" 373707"","" 382629"","" 382628"","" 430423"","" 377930"","" 377931"","" 430424"","" 413764"","" 413763"","" 61219"","" 380174"","" 380173"","" 381238"","" 381239"","" 199397"","" 62032"","" 338785"","" 60897"","" 60838"","" 67594"","" 62038"","" 61095"","" 60936"","" 67824"","" 25182"","" 370962"","" 370961"","" 370470"","" 370471"","" 370468"","" 370469"","" 61584"","" 62026"","" 61551"","" 61798"","" 61576"","" 201293"","" 336835"","" 299977"","" 61060"","" 61433"","" 61102"","" 67589"","" 61019"","" 60995"","" 61368"","" 62216"","" 61472"","" 61250"","" 61503"","" 62224"","" 310132"","" 25117"","" 67768"","" 25228"","" 62045"","" 335742"","" 25191"","" 67682"","" 67684"","" 25025"","" 60943"","" 358037"","" 61045"","" 60902"","" 61750"","" 436948"","" 436947"","" 327732"","" 62103"","" 433747"","" 433746"","" 442008"","" 442009"","" 433976"","" 433977"","" 329950"","" 359679"","" 359678"","" 359685"","" 359686"","" 359693"","" 359694"","" 61110"","" 61009"","" 61059"","" 60910"","" 327654"","" 327655"","" 332413"","" 67630"","" 25160"","" 379904"","" 379905"","" 379909"","" 379908"","" 379907"","" 379906"","" 60922"","" 61936"","" 62138"","" 61587"","" 61425"","" 293391"","" 70552"","" 62002"","" 361162"","" 61084"","" 67842"","" 61924"","" 60865"","" 60871"","" 61388"","" 61747"","" 67641"","" 25028"","" 315282"","" 315281"","" 25039"","" 67638"","" 61351"","" 60912"","" 61237"","" 199153"","" 314773"","" 25071"","" 67752"","" 67762"","" 25096"","" 199151"","" 61859"","" 60942"","" 61456"","" 60855"","" 334132"","" 60856"","" 61232"","" 433752"","" 433751"","" 441382"","" 441381"","" 61091"","" 293884"","" 61172"","" 62030"","" 61658"","" 61794"","" 61256"","" 61111"","" 61085"","" 61086"","" 62008"","" 61014"","" 25010"","" 67797"","" 56332"","" 61449"","" 61221"","" 61194"","" 61434"","" 61876"","" 67679"","" 25001"","" 67843"","" 62198"","" 293363"","" 62176"","" 61157"","" 433830"","" 60905"","" 4150"","" 200424"","" 200425"","" 200426"","" 200422"","" 61465"","" 67745"","" 25216"","" 60854"","" 62102"","" 61231"","" 55971"","" 373239"","" 373238"","" 318262"","" 373245"","" 373244"","" 4155"","" 6618"","" 62181"","" 963"","" 52386"","" 388300"","" 388301"","" 61491"","" 61771"","" 60986"","" 60931"","" 61254"","" 61428"","" 61844"","" 61935"","" 61719"","" 62190"","" 413875"","" 414050"","" 414041"","" 414042"","" 414101"","" 422377"","" 422356"","" 422357"","" 61407"","" 62160"","" 311145"","" 61075"","" 61802"","" 61803"","" 61941"","" 61781"","" 322971"","" 322973"","" 322975"","" 322972"","" 322974"","" 552"","" 553"","" 61925"","" 62094"","" 61552"","" 61649"","" 61768"","" 25167"","" 67849"","" 200316"","" 202416"","" 331140"","" 318507"","" 59660"","" 318243"","" 199018"","" 198157"","" 53629"","" 56140"","" 293961"","" 318241"","" 318242"","" 57948"","" 324964"","" 319842"","" 322958"","" 203285"","" 319853"","" 202564"","" 53752"","" 59661"","" 57278"","" 61343"","" 61624"","" 61611"","" 60932"","" 200232"","" 25044"","" 67691"","" 293349"","" 293393"","" 70533"","" 70519"","" 61629"","" 62029"","" 61078"","" 62104"","" 315133"","" 61330"","" 62210"","" 62180"","" 61893"","" 61255"","" 61739"","" 61429"","" 61461"","" 61822"","" 67547"","" 61940"","" 61819"","" 62149"","" 351258"","" 61867"","" 61114"","" 67704"","" 25189"","" 61654"","" 62156"","" 67671"","" 62014"","" 61831"","" 62128"","" 61340"","" 61838"","" 25226"","" 62218"","" 61183"","" 61805"","" 61374"","" 61293"","" 61713"","" 61885"","" 293367"","" 336497"","" 61313"","" 61113"","" 61864"","" 61657"","" 60859"","" 60978"","" 535"","" 24994"","" 67611"","" 61672"","" 67749"","" 24984"","" 67750"","" 24983"","" 24989"","" 67796"","" 24988"","" 67791"","" 62058"","" 61182"","" 323285"","" 2721"","" 61171"","" 61081"","" 61998"","" 61290"","" 61229"","" 61324"","" 61286"","" 60930"","" 62172"","" 62171"","" 379009"","" 379008"","" 379015"","" 441793"","" 441774"","" 441775"","" 442011"","" 442003"","" 442004"","" 381216"","" 442226"","" 381190"","" 442223"","" 442222"","" 381189"","" 381188"","" 441801"","" 375947"","" 376028"","" 441391"","" 441392"","" 376962"","" 376961"","" 377967"","" 377963"","" 377964"","" 377965"","" 375933"","" 375932"","" 376034"","" 376035"","" 61811"","" 62174"","" 61850"","" 201235"","" 315261"","" 201236"","" 61837"","" 358837"","" 358836"","" 67648"","" 25233"","" 61908"","" 25003"","" 61683"","" 62053"","" 62147"","" 61829"","" 4958"","" 4959"","" 61661"","" 62152"","" 61162"","" 60985"","" 60982"","" 60857"","" 61276"","" 61772"","" 62071"","" 60988"","" 61549"","" 62203"","" 361265"","" 361264"","" 61957"","" 61071"","" 61789"","" 61738"","" 62035"","" 61835"","" 60997"","" 67637"","" 25163"","" 61572"","" 61833"","" 61635"","" 333946"","" 61484"","" 61385"","" 61384"","" 62001"","" 61827"","" 12288"","" 25207"","" 2727"","" 25051"","" 67658"","" 62130"","" 62129"","" 67736"","" 2479"","" 61603"","" 61115"","" 61004"","" 335522"","" 335521"","" 61274"","" 61504"","" 62089"","" 61285"","" 62164"","" 351121"","" 350979"","" 336351"","" 358108"","" 358109"","" 198181"","" 293388"","" 199138"","" 26571"","" 67581"","" 61861"","" 61754"","" 61967"","" 62090"","" 61892"","" 67685"","" 25084"","" 61243"","" 25169"","" 68076"","" 358084"","" 358083"","" 358088"","" 358087"","" 62191"","" 61116"","" 60881"","" 2729"","" 359344"","" 61317"","" 60841"","" 61871"","" 327969"","" 67674"","" 323095"","" 329951"","" 403562"","" 403563"","" 330033"","" 310825"","" 310826"","" 338957"","" 372610"","" 372611"","" 67713"","" 25067"","" 60830"","" 68088"","" 67647"","" 159195"","" 293374"","" 296791"","" 199601"","" 203712"","" 199600"","" 203711"","" 199603"","" 199602"","" 203713"","" 203714"","" 61233"","" 25218"","" 25219"","" 25223"","" 25222"","" 25220"","" 25221"","" 60920"","" 61139"","" 61020"","" 61926"","" 62133"","" 62081"","" 62080"","" 62222"","" 61294"","" 61318"","" 60880"","" 62188"","" 62126"","" 61451"","" 61265"","" 358874"","" 358875"","" 324960"","" 53762"","" 5140"","" 56329"","" 60458"","" 60461"","" 60462"","" 60463"","" 53813"","" 57279"","" 52936"","" 61945"","" 294039"","" 239141"","" 293745"","" 310827"","" 310828"","" 378930"","" 378931"","" 390284"","" 390283"","" 351413"","" 62142"","" 67700"","" 25000"","" 61647"","" 61427"","" 60949"","" 61628"","" 61644"","" 60858"","" 61529"","" 61479"","" 61890"","" 61144"","" 61933"","" 61900"","" 67773"","" 25114"","" 25151"","" 67809"","" 25152"","" 67765"","" 61842"","" 382516"","" 382517"","" 61817"","" 61870"","" 61939"","" 67857"","" 62115"","" 61605"","" 61356"","" 61401"","" 61464"","" 61436"","" 61297"","" 62185"","" 430800"","" 430801"","" 329927"","" 60969"","" 61312"","" 323655"","" 336422"","" 388011"","" 388008"","" 388010"","" 388009"","" 388007"","" 388006"","" 388005"","" 368144"","" 368145"","" 368151"","" 368150"","" 374609"","" 374891"","" 368304"","" 368146"","" 368148"","" 67705"","" 67701"","" 67680"","" 67715"","" 67707"","" 67706"","" 200209"","" 62095"","" 296676"","" 296675"","" 62004"","" 61206"","" 360136"","" 301512"","" 293358"","" 25187"","" 67744"","" 200191"","" 200192"","" 24995"","" 67619"","" 431489"","" 431490"","" 431499"","" 371972"","" 371971"","" 432763"","" 432828"","" 432827"","" 432825"","" 432826"","" 372187"","" 372186"","" 372188"","" 372614"","" 433374"","" 372711"","" 372708"","" 372707"","" 372713"","" 433364"","" 433363"","" 62135"","" 26783"","" 61360"","" 61477"","" 61302"","" 61492"","" 61824"","" 61524"","" 61650"","" 61548"","" 61287"","" 61687"","" 61952"","" 61474"","" 61574"","" 2688"","" 61224"","" 62197"","" 61303"","" 335605"","" 61215"","" 61878"","" 293380"","" 359460"","" 359461"","" 359848"","" 359849"","" 373982"","" 373983"","" 374159"","" 437010"","" 437009"","" 437008"","" 374450"","" 374449"","" 438972"","" 438661"","" 438659"","" 438658"","" 374601"","" 374600"","" 438927"","" 438906"","" 438905"","" 438654"","" 438655"","" 374877"","" 374876"","" 373926"","" 436719"","" 436718"","" 436715"","" 436716"","" 373984"","" 347180"","" 347181"","" 55937"","" 61272"","" 360881"","" 360882"","" 360040"","" 360041"","" 370987"","" 370988"","" 375930"","" 375931"","" 405900"","" 405901"","" 374176"","" 374177"","" 374885"","" 374884"","" 359759"","" 359758"","" 370251"","" 370253"","" 67838"","" 372184"","" 372185"","" 373509"","" 373510"","" 372710"","" 372709"","" 371966"","" 371965"","" 371522"","" 371521"","" 360134"","" 360135"","" 368121"","" 368120"","" 372089"","" 372088"","" 373988"","" 373989"","" 374598"","" 374597"","" 67820"","" 61143"","" 353732"","" 62120"","" 61358"","" 61359"","" 61152"","" 62049"","" 61153"","" 376926"","" 376927"","" 316441"","" 336410"","" 61024"","" 62036"","" 61906"","" 61707"","" 62148"","" 61891"","" 61202"","" 198425"","" 70488"","" 382463"","" 371490"","" 382464"","" 60888"","" 62078"","" 62088"","" 61993"","" 61222"","" 61573"","" 62206"","" 61792"","" 61074"","" 61467"","" 61454"","" 61485"","" 61709"","" 61156"","" 61662"","" 67605"","" 62123"","" 61751"","" 62019"","" 60972"","" 62082"","" 373869"","" 26499"","" 24991"","" 61439"","" 61414"","" 350881"","" 330788"","" 335614"","" 335615"","" 338870"","" 61783"","" 61534"","" 61715"","" 374137"","" 374136"","" 61946"","" 296246"","" 3659"","" 239133"","" 239135"","" 25225"","" 61117"","" 67688"","" 24997"","" 61003"","" 356674"","" 356673"","" 337039"","" 62143"","" 67710"","" 25042"","" 25164"","" 67634"","" 2348"","" 60924"","" 25006"","" 67621"","" 61671"","" 61560"","" 61497"","" 61834"","" 61679"","" 61535"","" 358922"","" 358923"","" 61468"","" 25038"","" 67686"","" 61609"","" 61005"","" 62186"","" 67693"","" 25034"","" 61546"","" 61051"","" 60903"","" 297258"","" 239134"","" 67568"","" 294208"","" 294223"","" 239136"","" 61542"","" 61386"","" 61777"","" 61760"","" 61922"","" 200427"","" 663662"","" 663661"","" 60870"","" 62112"","" 60925"","" 60944"","" 61883"","" 61521"","" 61586"","" 25142"","" 67732"","" 25143"","" 67657"","" 350970"","" 60879"","" 301513"","" 62212"","" 202230"","" 356277"","" 310236"","" 338991"","" 60998"","" 199108"","" 199109"","" 200041"","" 200912"","" 61659"","" 62083"","" 61284"","" 61426"","" 62141"","" 61999"","" 25705"","" 67608"","" 62028"","" 62066"","" 61743"","" 61550"","" 25203"","" 67852"","" 203806"","" 61107"","" 61757"","" 335096"","" 377866"","" 334559"","" 335095"","" 337122"","" 335094"","" 334030"","" 62121"","" 61857"","" 60913"","" 67651"","" 25206"","" 25129"","" 67776"","" 351300"","" 338872"","" 62096"","" 307526"","" 307531"","" 373967"","" 373968"","" 61593"","" 359418"","" 359774"","" 298158"","" 298159"","" 298160"","" 67874"","" 25088"","" 368663"","" 368664"","" 432772"","" 432773"","" 432707"","" 432706"","" 335582"","" 12719"","" 307525"","" 333379"","" 433422"","" 433421"","" 333380"","" 441968"","" 441969"","" 433806"","" 433805"","" 336449"","" 663901"","" 663900"","" 293074"","" 335577"","" 61437"","" 356485"","" 358219"","" 370229"","" 370230"","" 367750"","" 67836"","" 25217"","" 346493"","" 346492"","" 337060"","" 58413"","" 368004"","" 368007"","" 60727"","" 58417"","" 60734"","" 61695"","" 368980"","" 61847"","" 331031"","" 238804"","" 61282"","" 25004"","" 67542"","" 61721"","" 663867"","" 663866"","" 367964"","" 367965"","" 383957"","" 25066"","" 67783"","" 332135"","" 297182"","" 298144"","" 298339"","" 411851"","" 411850"","" 316532"","" 316533"","" 62100"","" 61977"","" 315058"","" 402999"","" 402985"","" 402984"","" 403407"","" 403378"","" 403377"","" 60991"","" 5310"","" 323671"","" 67602"","" 67817"","" 62034"","" 67848"","" 61032"","" 61478"","" 392149"","" 392148"","" 396234"","" 396216"","" 396215"","" 398204"","" 398200"","" 398201"","" 401854"","" 401846"","" 401838"","" 401837"","" 392156"","" 327840"","" 61779"","" 61054"","" 26880"","" 387845"","" 387846"","" 387848"","" 387847"","" 293479"","" 67687"","" 25005"","" 62124"","" 61267"","" 67858"","" 61083"","" 61954"","" 67560"","" 315108"","" 433573"","" 433572"","" 25061"","" 67636"","" 61155"","" 61773"","" 332074"","" 315057"","" 332071"","" 372699"","" 372700"","" 307483"","" 61103"","" 62040"","" 298259"","" 67856"","" 335581"","" 67863"","" 25049"","" 61321"","" 62228"","" 300971"","" 377859"","" 377860"","" 199139"","" 295311"","" 61625"","" 315321"","" 62219"","" 67819"","" 25030"","" 61462"","" 61879"","" 61432"","" 61579"","" 25236"","" 60980"","" 61915"","" 61668"","" 61592"","" 67683"","" 25094"","" 386932"","" 386933"","" 67613"","" 60822"","" 60821"","" 67628"","" 60823"","" 61230"","" 61566"","" 61128"","" 61006"","" 61463"","" 61815"","" 61519"","" 385877"","" 61761"","" 371321"","" 371322"","" 297850"","" 60957"","" 371422"","" 371421"","" 62111"","" 67742"","" 67740"","" 61279"","" 61278"","" 60945"","" 67698"","" 25021"","" 61226"","" 25183"","" 67543"","" 296677"","" 61435"","" 199110"","" 346447"","" 24977"","" 67573"","" 61007"","" 62020"","" 379002"","" 379001"","" 403265"","" 60999"","" 316510"","" 25202"","" 67653"","" 61536"","" 62193"","" 368715"","" 358085"","" 358086"","" 358038"","" 61932"","" 61818"","" 56653"","" 317211"","" 403121"","" 403122"","" 313395"","" 199167"","" 199762"","" 199143"","" 199761"","" 199168"","" 322993"","" 322992"","" 52056"","" 200231"","" 61613"","" 62054"","" 61558"","" 25180"","" 67596"","" 61897"","" 61916"","" 60926"","" 25108"","" 67760"","" 293402"","" 61395"","" 61848"","" 61419"","" 382689"","" 61025"","" 60937"","" 61578"","" 61486"","" 61580"","" 61631"","" 203461"","" 199423"","" 203460"","" 199422"","" 238691"","" 203573"","" 203572"","" 238719"","" 238692"","" 238720"","" 203465"","" 203464"","" 200774"","" 371935"","" 371934"","" 442237"","" 442236"","" 370932"","" 370933"","" 52499"","" 67787"","" 25106"","" 199509"","" 199624"","" 199625"","" 199502"","" 199499"","" 199498"","" 204038"","" 204037"","" 199524"","" 199525"","" 203803"","" 203802"","" 199528"","" 203467"","" 203466"","" 199425"","" 199529"","" 199424"","" 199534"","" 199535"","" 199540"","" 199541"","" 199542"","" 199543"","" 199548"","" 199549"","" 199562"","" 199563"","" 238735"","" 199503"","" 199582"","" 199583"","" 199584"","" 199585"","" 199506"","" 238734"","" 199507"","" 199508"","" 199604"","" 199605"","" 204111"","" 204110"","" 199596"","" 199538"","" 199564"","" 199539"","" 199577"","" 199597"","" 199576"","" 199573"","" 199572"","" 199565"","" 199512"","" 199513"","" 339119"","" 199715"","" 199714"","" 199637"","" 199636"","" 199631"","" 199630"","" 334010"","" 334011"","" 334012"","" 334013"","" 199609"","" 199608"","" 199607"","" 199606"","" 199595"","" 199594"","" 339121"","" 199581"","" 199580"","" 339120"","" 339118"","" 309970"","" 309971"","" 309975"","" 309976"","" 309977"","" 309978"","" 309980"","" 309981"","" 309982"","" 309983"","" 309995"","" 309996"","" 336049"","" 336048"","" 296128"","" 199610"","" 199611"","" 296129"","" 25093"","" 67668"","" 24985"","" 12100"","" 67751"","" 62220"","" 25153"","" 67703"","" 299305"","" 327652"","" 332072"","" 315883"","" 359262"","" 359261"","" 372695"","" 372696"","" 335596"","" 335595"","" 200307"","" 62177"","" 61601"","" 61030"","" 25026"","" 67792"","" 61271"","" 12691"","" 203358"","" 203357"","" 239052"","" 67649"","" 67650"","" 61200"","" 61220"","" 62223"","" 296510"","" 52159"","" 67544"","" 62109"","" 57273"","" 53764"","" 7341"","" 53827"","" 56139"","" 58414"","" 52832"","" 61026"","" 61242"","" 61970"","" 61381"","" 201294"","" 201295"","" 62013"","" 297837"","" 60860"","" 61643"","" 25124"","" 67784"","" 61398"","" 60958"","" 329926"","" 62225"","" 293381"","" 67591"","" 25122"","" 61853"","" 59374"","" 62153"","" 68053"","" 60797"","" 70489"","" 293383"","" 62202"","" 61623"","" 61417"","" 373643"","" 373644"","" 61581"","" 359239"","" 359240"","" 329952"","" 663591"","" 61759"","" 373246"","" 373247"","" 373250"","" 373251"","" 373255"","" 373254"","" 373259"","" 373258"","" 60835"","" 402972"","" 402971"","" 61540"","" 61886"","" 202139"","" 336421"","" 61361"","" 61795"","" 438876"","" 61097"","" 62021"","" 25031"","" 67625"","" 61506"","" 61338"","" 61470"","" 297248"","" 297247"","" 433372"","" 433373"","" 293593"","" 61976"","" 373531"","" 373532"","" 61383"","" 61352"","" 359592"","" 359593"","" 60868"","" 373969"","" 373970"","" 378842"","" 378841"","" 378844"","" 378843"","" 347188"","" 347187"","" 67631"","" 67652"","" 25168"","" 8640"","" 329919"","" 329918"","" 4718"","" 61039"","" 61710"","" 199527"","" 199627"","" 199626"","" 199566"","" 199567"","" 296077"","" 199530"","" 199531"","" 203805"","" 199612"","" 199578"","" 199521"","" 199579"","" 199501"","" 199520"","" 199511"","" 199510"","" 199500"","" 203804"","" 199526"","" 199613"","" 296078"","" 67818"","" 293966"","" 61630"","" 367805"","" 367806"","" 315291"","" 315292"","" 298135"","" 359093"","" 359092"","" 61373"","" 61843"","" 62046"","" 61441"","" 61813"","" 61896"","" 61291"","" 321132"","" 60938"","" 61389"","" 413655"","" 61158"","" 61367"","" 61648"","" 62055"","" 300192"","" 60893"","" 61015"","" 61975"","" 61963"","" 61937"","" 67716"","" 25165"","" 315134"","" 67689"","" 25036"","" 61043"","" 61868"","" 61821"","" 60875"","" 62204"","" 61500"","" 61370"","" 60983"","" 61217"","" 61487"","" 374038"","" 374037"","" 61953"","" 380145"","" 380146"","" 67607"","" 332860"","" 61812"","" 353720"","" 315111"","" 389032"","" 353695"","" 385879"","" 199126"","" 61653"","" 3944"","" 60933"","" 61554"","" 25091"","" 67780"","" 61530"","" 61723"","" 61730"","" 367822"","" 62230"","" 62047"","" 12309"","" 12311"","" 12310"","" 12308"","" 61801"","" 430706"","" 430707"","" 62003"","" 60906"","" 61714"","" 61972"","" 67861"","" 25213"","" 67833"","" 60966"","" 25111"","" 67632"","" 373081"","" 373080"","" 373082"","" 373083"","" 67771"","" 25150"","" 61029"","" 61799"","" 311170"","" 62075"","" 311173"","" 62173"","" 25070"","" 24987"","" 67865"","" 293373"","" 382539"","" 382538"","" 356456"","" 356457"","" 61790"","" 61808"","" 61839"","" 61637"","" 61008"","" 60861"","" 61334"","" 296851"","" 296858"","" 296859"","" 61365"","" 431151"","" 431150"","" 61785"","" 61047"","" 60979"","" 60840"","" 61875"","" 25027"","" 67793"","" 61109"","" 61865"","" 61027"","" 67718"","" 25115"","" 56572"","" 239218"","" 61234"","" 61921"","" 61380"","" 62091"","" 60894"","" 61262"","" 61617"","" 62031"","" 387946"","" 387945"","" 59153"","" 370864"","" 370863"","" 337321"","" 373572"","" 337320"","" 373610"","" 373611"","" 370865"","" 3010"","" 61150"","" 61424"","" 386936"","" 388303"","" 663806"","" 663803"","" 663804"","" 388273"","" 388274"","" 388275"","" 663883"","" 389891"","" 663877"","" 663876"","" 389888"","" 389887"","" 389892"","" 386931"","" 386930"","" 386934"","" 386961"","" 25185"","" 67574"","" 67642"","" 61133"","" 60952"","" 438870"","" 316044"","" 61118"","" 441464"","" 663820"","" 316306"","" 346511"","" 346510"","" 61682"","" 61901"","" 62122"","" 61735"","" 61404"","" 61197"","" 62167"","" 62166"","" 61159"","" 433526"","" 433528"","" 433625"","" 433627"","" 433517"","" 433518"","" 61764"","" 61480"","" 61459"","" 62214"","" 61557"","" 62072"","" 61563"","" 61599"","" 67597"","" 25002"","" 61141"","" 61208"","" 62017"","" 61125"","" 61124"","" 61166"","" 61040"","" 61889"","" 61126"","" 62061"","" 61057"","" 60862"","" 62151"","" 61841"","" 62087"","" 61165"","" 368064"","" 316309"","" 200420"","" 358123"","" 358124"","" 359909"","" 359910"","" 360857"","" 360856"","" 359464"","" 359463"","" 360441"","" 360442"","" 359391"","" 359390"","" 359675"","" 359676"","" 389893"","" 403561"","" 368658"","" 368129"","" 368874"","" 373694"","" 373692"","" 360883"","" 61746"","" 318712"","" 442765"","" 663607"","" 442764"","" 663608"","" 663824"","" 663823"","" 442423"","" 389106"","" 442422"","" 61836"","" 61664"","" 61663"","" 61633"","" 60878"","" 62136"","" 61986"","" 433574"","" 433575"","" 56227"","" 52156"","" 61618"","" 25178"","" 67654"","" 300330"","" 368966"","" 368965"","" 61251"","" 61392"","" 61854"","" 61996"","" 12618"","" 61048"","" 61397"","" 61120"","" 61241"","" 61104"","" 319084"","" 334454"","" 199166"","" 67694"","" 24982"","" 67640"","" 25053"","" 62169"","" 62084"","" 61767"","" 61077"","" 61568"","" 60836"","" 61636"","" 61846"","" 62057"","" 61098"","" 61591"","" 61960"","" 61132"","" 62162"","" 61705"","" 61537"","" 61753"","" 61493"","" 61737"","" 61442"","" 61641"","" 367984"","" 339101"","" 339100"","" 202226"","" 61320"","" 61378"","" 67570"","" 203902"","" 61225"","" 61185"","" 202229"","" 200101"","" 301400"","" 62060"","" 62134"","" 334536"","" 319887"","" 315322"","" 663649"","" 663650"","" 333953"","" 338821"","" 346674"","" 357921"","" 315107"","" 60934"","" 61742"","" 373709"","" 373710"","" 373711"","" 373712"","" 373714"","" 373713"","" 373716"","" 373715"","" 60907"","" 60863"","" 333945"","" 61134"","" 61559"","" 61067"","" 336412"","" 61676"","" 62079"","" 293714"","" 61238"","" 60928"","" 25035"","" 67695"","" 62108"","" 61959"","" 61193"","" 62022"","" 60963"","" 25105"","" 67546"","" 359150"","" 359151"","" 318715"","" 383560"","" 383559"","" 387843"","" 387842"","" 359725"","" 359724"","" 318716"","" 318717"","" 335749"","" 402912"","" 402913"","" 300895"","" 61607"","" 61971"","" 60864"","" 61860"","" 67692"","" 25048"","" 61627"","" 60973"","" 62076"","" 67639"","" 61855"","" 61168"","" 62170"","" 61731"","" 396244"","" 315806"","" 315807"","" 67876"","" 25100"","" 61755"","" 61357"","" 58415"","" 369030"","" 369031"","" 369033"","" 369032"","" 367908"","" 367909"","" 368986"","" 61257"","" 61499"","" 61337"","" 61299"","" 61406"","" 61588"","" 61058"","" 414692"","" 414697"","" 414698"","" 414699"","" 335528"","" 335529"","" 62229"","" 61923"","" 61053"","" 339005"","" 61782"","" 25013"","" 67756"","" 67864"","" 61405"","" 61130"","" 368169"","" 359339"","" 361180"","" 370231"","" 359343"","" 359336"","" 370266"","" 359278"","" 360917"","" 359329"","" 61396"","" 61800"","" 61041"","" 60955"","" 61177"","" 61724"","" 61688"","" 61420"","" 62140"","" 67827"","" 315179"","" 318500"","" 68060"","" 67879"","" 67730"","" 67724"","" 67672"","" 67618"","" 67577"","" 67576"","" 67556"","" 62227"","" 351266"","" 351366"","" 61148"","" 25232"","" 25231"","" 25214"","" 25212"","" 25205"","" 25126"","" 442425"","" 442426"","" 24986"","" 12702"","" 25104"","" 67727"","" 351268"","" 351267"","" 331839"","" 293387"","" 294025"","" 300350"","" 67578"","" 200129"","" 368136"","" 67616"","" 199415"","" 316546"","" 67869"","" 67567"","" 430340"","" 373037"","" 373038"","" 323488"","" 323489"","" 323490"","" 67554"","" 159034"","" 67624"","" 67563"","" 67880"","" 67881"","" 199633"","" 199614"","" 296058"","" 199632"","" 199615"","" 296057"","" 3524"","" 199619"","" 199618"","" 199617"","" 199616"","" 238724"","" 238723"","" 199046"","" 25089"","" 67728"","" 3824"","" 312220"","" 312223"","" 334441"","" 389059"","" 389058"","" 67803"","" 25112"","" 336457"","" 59490"","" 67847"","" 67845"","" 67729"","" 25123"","" 441154"","" 2279"","" 335580"","" 335579"","" 335587"","" 335586"","" 335589"","" 335588"","" 338964"","" 398211"","" 200125"","" 67566"","" 199115"","" 438875"","" 59318"","" 350971"","" 67839"","" 67844"","" 159033"","" 334750"","" 199146"","" 2726"","" 25210"","" 67831"","" 403188"","" 403187"","" 238355"","" 203642"","" 294171"","" 392497"","" 313396"","" 368633"","" 368634"","" 350874"","" 350875"","" 298302"","" 67564"","" 52837"","" 53421"","" 323257"","" 198377"","" 332137"","" 358838"","" 358839"","" 25087"","" 67702"","" 239211"","" 351324"","" 351325"","" 5074"","" 67746"","" 67580"","" 67541"","" 70626"","" 67832"","" 67834"","" 67835"","" 4716"","" 59659"","" 53564"","" 58338"","" 159031"","" 67837"","" 293366"","" 333372"","" 335600"","" 431323"","" 431324"","" 433948"","" 433947"","" 53815"","" 310045"","" 337863"","" 68198"","" 199191"","" 2159"","" 200047"","" 56432"","" 239040"","" 201711"","" 307478"","" 67846"","" 358761"","" 358760"","" 25109"","" 67720"","" 318688"","" 67723"","" 25064"","" 293370"","" 296432"","" 67540"","" 293375"","" 370267"","" 372617"","" 372618"","" 25154"","" 67617"","" 67676"","" 25063"","" 25156"","" 297940"","" 300193"","" 389105"","" 293356"","" 67738"","" 67731"","" 356761"","" 310961"","" 369061"","" 368014"","" 368015"","" 369062"","" 67579"","" 371947"","" 371946"","" 372751"","" 372752"","" 67675"","" 387856"","" 67759"","" 387855"","" 25157"","" 25158"","" 663693"","" 663694"","" 67737"","" 25107"","" 200399"","" 359188"","" 359187"","" 296222"","" 67549"","" 25171"","" 67721"","" 25011"","" 25173"","" 67550"","" 7419"","" 67659"","" 293352"","" 25125"","" 67800"","" 25128"","" 67825"","" 399799"","" 360161"","" 360162"","" 67606"","" 438619"","" 373608"","" 373607"","" 335599"","" 67747"","" 67748"","" 57947"","" 60744"","" 310100"","" 310484"","" 199122"","" 67598"","" 6406"","" 25193"","" 67599"","" 25194"","" 67600"","" 67601"","" 25195"","" 373866"","" 25098"","" 67726"","" 25092"","" 67735"","" 67867"","" 25095"","" 67866"","" 25097"","" 316166"","" 297418"","" 59315"","" 297183"","" 663603"","" 59082"","" 159032"","" 5058"","" 312374"","" 300962"","" 318244"","" 239215"","" 53766"","" 59317"","" 59314"","" 314962"","" 371128"","" 52836"","" 323533"","" 323534"","" 323535"","" 323536"","" 298163"","" 298164"","" 298165"","" 59316"","" 59050"","" 59051"","" 59467"","" 58398"","" 203380"","" 293339"","" 307603"","" 25110"","" 67722"","" 60962"","" 67678"","" 25016"","" 61178"","" 61283"","" 61072"","" 61188"","" 61446"","" 25196"","" 67725"","" 61501"","" 61326"","" 61379"","" 60977"","" 351414"","" 61112"","" 61448"","" 61016"","" 61036"","" 61096"","" 61947"","" 373415"","" 373414"","" 25015"","" 67753"","" 61443"","" 25148"","" 67690"","" 61223"","" 67633"","" 24990"","" 25197"","" 67815"","" 61690"","" 62033"","" 25162"","" 67603"","" 61065"","" 61064"","" 61063"","" 61154"","" 61066"","" 60967"","" 60968"","" 61845"","" 61899"","" 60914"","" 62044"","" 67830"","" 25103"","" 61240"","" 62009"","" 307249"","" 431379"","" 431380"","" 60908"","" 62093"","" 60953"","" 25022"","" 67882"","" 61888"","" 62183"","" 62006"","" 61680"","" 25224"","" 67854"","" 61022"","" 61701"","" 61310"","" 61311"","" 60992"","" 60984"","" 61652"","" 61145"","" 61169"","" 62168"","" 67712"","" 25079"","" 61830"","" 61164"","" 62139"","" 61528"","" 61978"","" 61415"","" 61142"","" 61585"","" 61371"","" 61531"","" 61545"","" 61512"","" 61513"","" 61518"","" 61517"","" 61516"","" 61515"","" 61514"","" 61510"","" 61511"","" 335461"","" 335462"","" 335490"","" 335489"","" 335491"","" 335492"","" 335494"","" 335493"","" 335496"","" 335495"","" 335498"","" 335497"","" 335500"","" 335499"","" 335464"","" 335463"","" 335465"","" 335466"","" 335468"","" 335467"","" 335470"","" 335469"","" 335485"","" 335486"","" 335471"","" 335472"","" 335474"","" 335473"","" 335484"","" 335483"","" 335488"","" 335487"","" 373586"","" 373587"","" 60915"","" 61069"","" 61489"","" 61758"","" 61127"","" 62025"","" 61353"","" 301399"","" 25229"","" 300712"","" 61322"","" 61602"","" 60909"","" 61778"","" 61733"","" 61094"","" 61146"","" 67790"","" 25146"","" 61319"","" 61042"","" 61175"","" 359367"","" 359366"","" 67823"","" 61626"","" 3265"","" 61903"","" 438673"","" 438678"","" 25240"","" 61995"","" 70631"","" 61344"","" 61236"","" 61595"","" 60918"","" 61163"","" 61375"","" 60886"","" 61882"","" 61180"","" 61281"","" 377833"","" 377832"","" 67816"","" 25078"","" 25069"","" 67741"","" 61997"","" 361258"","" 376901"","" 60946"","" 61619"","" 60844"","" 61569"","" 60947"","" 60843"","" 61877"","" 60839"","" 61201"","" 60923"","" 61192"","" 337245"","" 67623"","" 25017"","" 25188"","" 67677"","" 67855"","" 67635"","" 61390"","" 388036"","" 388035"","" 390356"","" 390357"","" 67936"","" 25230"","" 359492"","" 359493"","" 334508"","" 293888"","" 60948"","" 200423"","" 62119"","" 293382"","" 70554"","" 663798"","" 62226"","" 3913"","" 53814"","" 3780"","" 372772"","" 318260"","" 59045"","" 59048"","" 52833"","" 58416"","" 60600"","" 52834"","" 60601"","" 323647"","" 323648"","" 323646"","" 58412"","" 59465"","" 327619"","" 327653"","" 56573"","" 327731"","" 52831"","" 376971"","" 376976"","" 375951"","" 374769"","" 7340"","" 55964"","" 68185"","" 68192"","" 53751"","" 55938"","" 56331"","" 56330"","" 200195"","" 200194"","" 59047"","" 53765"","" 59049"","" 200197"","" 68151"","" 331106"","" 53912"","" 300956"","" 62048"","" 2361"","" 2365"","" 2364"","" 61239"","" 61496"","" 61505"","" 60837"","" 61252"","" 61621"","" 61894"","" 25052"","" 67764"","" 61693"","" 61046"","" 339004"","" 61481"","" 60715"","" 67557"","" 296243"","" 296225"","" 67853"","" 61934"","" 333848"","" 333849"","" 61011"","" 61028"","" 61973"","" 62043"","" 61874"","" 60959"","" 62201"","" 61364"","" 61277"","" 61034"","" 61911"","" 62070"","" 61992"","" 60935"","" 297255"","" 297256"","" 60832"","" 68085"","" 61147"","" 61207"","" 60975"","" 61788"","" 2745"","" 67743"","" 25200"","" 60866"","" 61136"","" 61131"","" 60993"","" 67859"","" 24998"","" 61667"","" 373293"","" 373294"","" 61327"","" 62016"","" 67795"","" 25032"","" 433558"","" 433559"","" 433556"","" 433557"","" 327976"","" 67779"","" 25113"","" 61814"","" 61694"","" 61720"","" 325413"","" 325414"","" 325415"","" 60994"","" 61049"","" 70553"","" 293371"","" 60892"","" 61744"","" 61204"","" 61608"","" 61119"","" 61988"","" 61590"","" 61691"","" 61149"","" 61806"","" 61209"","" 61919"","" 60916"","" 62154"","" 200210"","" 61261"","" 61082"","" 374041"","" 67786"","" 25131"","" 67785"","" 25138"","" 25137"","" 67807"","" 67772"","" 25132"","" 67770"","" 25135"","" 67806"","" 25133"","" 61035"","" 61969"","" 199051"","" 359090"","" 359091"","" 60602"","" 199063"","" 368193"","" 368704"","" 57351"","" 62116"","" 323119"","" 335667"","" 60465"","" 60464"","" 371927"","" 371928"","" 60898"","" 61905"","" 62127"","" 61776"","" 61640"","" 317199"","" 317200"","" 25235"","" 67585"","" 199629"","" 199628"","" 199620"","" 199621"","" 199591"","" 199590"","" 199589"","" 199588"","" 199516"","" 199517"","" 199544"","" 199552"","" 199561"","" 199553"","" 199569"","" 199558"","" 199532"","" 199622"","" 199537"","" 199554"","" 199555"","" 199559"","" 199574"","" 199545"","" 199568"","" 199550"","" 199560"","" 199575"","" 199623"","" 199533"","" 199551"","" 199536"","" 199523"","" 199592"","" 199427"","" 199593"","" 199426"","" 199634"","" 199635"","" 199570"","" 199571"","" 203463"","" 199586"","" 199522"","" 199587"","" 203462"","" 199557"","" 238722"","" 238721"","" 296126"","" 296127"","" 199556"","" 199515"","" 199514"","" 199519"","" 199518"","" 67583"","" 319854"","" 67644"","" 67660"","" 67661"","" 67662"","" 67663"","" 67664"","" 59064"","" 67665"","" 202211"","" 202167"","" 202498"","" 293693"","" 62137"","" 335855"","" 368134"","" 368133"","" 359229"","" 359256"","" 293350"","" 60971"","" 334530"","" 334531"","" 334528"","" 371054"","" 371052"","" 315099"","" 332088"","" 296182""}'::text[])::integer[])) IS NOT NULL) OR (ah.lease_customer_id IS NOT NULL))
  • Rows Removed by Filter: 2
9. 37.546 1,704.316 ↓ 13,668.0 13,668 1

Nested Loop Left Join (cost=3.27..179.22 rows=1 width=970) (actual time=112.151..1,704.316 rows=13,668 loops=1)

10. 19.136 1,510.217 ↓ 9,209.0 9,209 1

Nested Loop (cost=2.67..177.56 rows=1 width=965) (actual time=112.126..1,510.217 rows=9,209 loops=1)

11. 13.094 1,463.454 ↓ 9,209.0 9,209 1

Nested Loop (cost=2.53..177.38 rows=1 width=969) (actual time=112.112..1,463.454 rows=9,209 loops=1)

12. 15.656 529.460 ↓ 9,209.0 9,209 1

Nested Loop Left Join (cost=2.11..176.06 rows=1 width=476) (actual time=112.092..529.460 rows=9,209 loops=1)

13. 15.793 486.177 ↓ 9,209.0 9,209 1

Nested Loop Left Join (cost=1.98..175.91 rows=1 width=469) (actual time=112.082..486.177 rows=9,209 loops=1)

14. 14.013 415.130 ↓ 9,209.0 9,209 1

Nested Loop Anti Join (cost=1.69..175.48 rows=1 width=469) (actual time=112.053..415.130 rows=9,209 loops=1)

15. 17.899 388.749 ↓ 12,368.0 12,368 1

Nested Loop Left Join (cost=1.40..175.04 rows=1 width=473) (actual time=112.048..388.749 rows=12,368 loops=1)

16. 13.167 370.850 ↓ 12,368.0 12,368 1

Nested Loop Left Join (cost=1.12..174.73 rows=1 width=278) (actual time=112.042..370.850 rows=12,368 loops=1)

17. 22.616 345.315 ↓ 12,368.0 12,368 1

Nested Loop (cost=0.83..174.35 rows=1 width=114) (actual time=112.035..345.315 rows=12,368 loops=1)

18. 9.340 174.991 ↓ 196.9 24,618 1

Nested Loop (cost=0.54..129.26 rows=125 width=61) (actual time=112.015..174.991 rows=24,618 loops=1)

19. 112.101 112.101 ↓ 357.0 357 1

Function Scan on load_properties load_prop (cost=0.25..1.00 rows=1 width=4) (actual time=111.936..112.101 rows=357 loops=1)

  • Filter: ((is_disabled = 0) AND (is_test = 0))
  • Rows Removed by Filter: 8
20. 53.550 53.550 ↑ 1.8 69 357

Index Scan using idx_ap_details_cid_property_id on ap_details ad (cost=0.29..127.01 rows=125 width=61) (actual time=0.006..0.150 rows=69 loops=357)

  • Index Cond: ((cid = 235) AND (property_id = load_prop.property_id))
  • Filter: ((deleted_by IS NULL) AND (deleted_on IS NULL) AND (post_month <= '2019-08-01'::date))
  • Rows Removed by Filter: 2
21. 147.708 147.708 ↑ 1.0 1 24,618

Index Scan using idx_ap_headers on ap_headers ah (cost=0.29..0.35 rows=1 width=69) (actual time=0.006..0.006 rows=1 loops=24,618)

  • Index Cond: (id = ad.ap_header_id)
  • Filter: ((is_template IS FALSE) AND is_posted AND (NOT is_reimbursement) AND (COALESCE(ap_financial_status_type_id, 0) <> 8) AND (ap_financial_status_type_id IS DISTINCT FROM 8) AND (cid = 235) AND (ap_header_type_id = 5) AND (ad.gl_transaction_type_id = gl_transaction_type_id) AND (ad.post_month = post_month))
  • Rows Removed by Filter: 0
22. 12.368 12.368 ↓ 0.0 0 12,368

Index Scan using pk_property_units on property_units pu (cost=0.29..0.38 rows=1 width=172) (actual time=0.001..0.001 rows=0 loops=12,368)

  • Index Cond: ((ad.cid = cid) AND (cid = 235) AND (ad.property_unit_id = id))
23. 0.000 0.000 ↓ 0.0 0 12,368

Index Scan using idx_property_buildings_id on property_buildings pb (cost=0.28..0.30 rows=1 width=211) (actual time=0.000..0.000 rows=0 loops=12,368)

  • Index Cond: (id = pu.property_building_id)
  • Filter: ((cid = 235) AND (cid = pu.cid))
24. 12.368 12.368 ↓ 0.0 0 12,368

Index Scan using idx_ap_headers on ap_headers ah_reversal (cost=0.29..0.43 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=12,368)

  • Index Cond: (id = ah.reversal_ap_header_id)
  • Filter: ((is_template IS FALSE) AND (post_month <= '2019-08-01'::date) AND (cid = 235) AND (cid = ah.cid))
  • Rows Removed by Filter: 0
25. 55.254 55.254 ↑ 1.0 1 9,209

Index Scan using pk_ap_remittances on ap_remittances apr (cost=0.29..0.43 rows=1 width=12) (actual time=0.006..0.006 rows=1 loops=9,209)

  • Index Cond: ((cid = ah.cid) AND (cid = 235) AND (id = ah.ap_remittance_id))
26. 27.627 27.627 ↑ 1.0 1 9,209

Index Scan using pk_ap_payment_types on ap_payment_types apt (cost=0.14..0.15 rows=1 width=15) (actual time=0.003..0.003 rows=1 loops=9,209)

  • Index Cond: (id = apr.ap_payment_type_id)
27. 920.900 920.900 ↑ 1.0 1 9,209

Index Scan using idx_gl_account_trees_gl_account_id on gl_account_trees gat (cost=0.42..1.31 rows=1 width=501) (actual time=0.016..0.100 rows=1 loops=9,209)

  • Index Cond: (gl_account_id = ad.gl_account_id)
  • Filter: ((cid = 235) AND (is_default = 1))
  • Rows Removed by Filter: 70
28. 27.627 27.627 ↑ 1.0 1 9,209

Index Scan using idx_gl_trees_id on gl_trees gt (cost=0.14..0.18 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=9,209)

  • Index Cond: (id = gat.gl_tree_id)
  • Filter: ((cid = 235) AND (is_system = 1))
29. 64.463 156.553 ↑ 2.0 1 9,209

Bitmap Heap Scan on ap_allocations aa (cost=0.60..1.64 rows=2 width=17) (actual time=0.014..0.017 rows=1 loops=9,209)

  • Recheck Cond: (((cid = 235) AND (ad.id = charge_ap_detail_id)) OR ((cid = 235) AND (ad.id = credit_ap_detail_id)))
  • Filter: ((post_month <= '2019-08-01'::date) AND (cid = ad.cid))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=9,214
30. 9.209 92.090 ↓ 0.0 0 9,209

BitmapOr (cost=0.60..0.60 rows=2 width=0) (actual time=0.010..0.010 rows=0 loops=9,209)

31. 46.045 46.045 ↑ 1.0 1 9,209

Bitmap Index Scan on idx_ap_allocations_cid_charge_ap_detail_id_credit_ap_detail_id (cost=0.00..0.30 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=9,209)

  • Index Cond: ((cid = 235) AND (ad.id = charge_ap_detail_id))
32. 36.836 36.836 ↓ 0.0 0 9,209

Bitmap Index Scan on idx_ap_allocations_cid_credit_ap_detail_id_allocation_amount (cost=0.00..0.30 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=9,209)

  • Index Cond: ((cid = 235) AND (ad.id = credit_ap_detail_id))
33. 23,549.964 23,549.964 ↓ 40.7 4,070 13,668

ProjectSet (cost=0.00..0.52 rows=100 width=4) (actual time=1.259..1.723 rows=4,070 loops=13,668)

34. 0.000 0.000 ↑ 1.0 1 13,668

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=13,668)

35. 109.328 109.328 ↑ 1.0 1 13,666

Index Scan using idx_ap_payees_id on ap_payees ap (cost=0.29..0.39 rows=1 width=26) (actual time=0.008..0.008 rows=1 loops=13,666)

  • Index Cond: (id = ah.ap_payee_id)
  • Filter: ((cid = 235) AND (cid = ah.cid))
36. 81.996 81.996 ↓ 3.0 3 13,666

Index Scan using idx_ap_payee_locations_cid_ap_payee_id on ap_payee_locations apl (cost=0.29..0.41 rows=1 width=21) (actual time=0.005..0.006 rows=3 loops=13,666)

  • Index Cond: ((cid = 235) AND (ap.id = ap_payee_id))
37. 0.000 0.000 ↓ 0.0 0 13,666

Index Scan using pk_gl_dimensions on gl_dimensions gd (cost=0.14..0.16 rows=1 width=15) (actual time=0.000..0.000 rows=0 loops=13,666)

  • Index Cond: ((ad.cid = cid) AND (cid = 235) AND (ad.gl_dimension_id = id))
38. 0.000 0.000 ↓ 0.0 0 13,666

Index Scan using idx_company_departments_id on company_departments cd (cost=0.15..0.17 rows=1 width=666) (actual time=0.000..0.000 rows=0 loops=13,666)

  • Index Cond: (ad.company_department_id = id)
  • Filter: ((cid = 235) AND (ad.cid = cid))
39. 68.330 68.330 ↑ 1.0 11 13,666

Seq Scan on ap_routing_tags art (cost=0.00..1.19 rows=11 width=16) (actual time=0.003..0.005 rows=11 loops=13,666)

  • Filter: (cid = 235)
  • Rows Removed by Filter: 4