Sergey (Sentinel)

Sergey (Sentinel)

Был в сети 15 мая 2026, 18:40
Заказы принимаю
[[!pdoResources?
    &parents=`0`
    &depth=`0`
    &tpl=`@INLINE <li>[[+pagetitle]] — [[+count]]</li>`
    &limit=`0`
    &select=`{
      "modResource":"id, pagetitle",
      "Children":"COUNT(Children.id) as count"
    }`
    &leftJoin=`{
      "Children":{"class":"modResource", "on":"modResource.id = Children.parent AND (Children.deleted != 1 AND Children.published = 1)"}
    }`
    &where=`{"Children.id:IS NOT":null}`
    &sortby=`{"id":"ASC"}`
    &groupby=`modResource.id`
  ]]