Андрей

[[!yandexMaps?
    &tvCoords=`coords`
    &fieldForBalloonContent=`description`
    &fieldForHint=`pagetitle`
    &objectsTypesJSON=`[
        {
            "InvestProjects": {
                "parent":"5",
                "preset":"islands#violetStretchyIcon",
                "presetText":"Реализованный",
                "title":"Инвестиционные проекты"
            },
            "InvestPlaygrounds": {
                "parent":"6",
                "icon":"/images/playgrounds_map_icon.png",
                "title":"Инвестиционные площадки"
            }
        }
    ]`
]]

"tvStatus.value:=": "да"

[[!pdoResources?
    &parents=`137`
    &depth=`5`
    &tpl=`tpl.long`
    &sortby=`menuindex`
    &sortdir=`ASC`
    &where=`{
    "pagetitle":"[[*pagetitle]]",
		"tvStatus.value:=": "да" 
    }`
    &showUnpublished=`1`
    &limit=`100`
    &leftJoin=`{
        "tvLong":{
            "class":"modTemplateVarResource", 
            "on":"modResource.parent = tvLong.contentid AND tvLong.tmplvarid = 14",
        "tvStatus":{
            "class":"modTemplateVarResource", 
            "on":"modResource.parent = tvStatus.contentid AND tvStatus.tmplvarid = 31"            
        }
    }`
    &select=`{
        "tvLong": "SUM(tvLong.value) as tv_long_sum"
    }`

[pdoTools] Error 42S22: Unknown column 'tvLong.value' in 'field list'

{if $parent | resource: 'tv_parametr' == 'да'}
<tr>
	<td>[[#[[+parent]].tv.long]]</td>
</tr>
{/if}

[[!pdoResources?
                         &parents=`137`
                         &depth=`5`
                         &tpl=`tpl.tpl`
                         &sortby=`menuindex`
                         &sortdir=`ASC`
                         &where=`{"pagetitle":"[[*pagetitle]]"}`
                         &showUnpublished=`1`
                         &limit=`100`
                        ]]

<td>[[#[[+parent]].tv.long]]</td>