$sql = 'select distinct doc.id, tv1.value
from modx_site_content as doc, modx_site_tmplvar_contentvalues as tv1
where tv1.tmplvarid="22" and doc.parent="17" and doc.published="1" and doc.deleted="0" and doc.isfolder="0" order by tv1.value';
$wave = $modx->db->query($sql);

//asort($wave);

while($row = $modx->db->getRow($wave)) {
        
        $area = $row['value'];
        $docid = $row['id'];
        
        $out[] = htmlspecialchars($area).'=='.$docid;
        
}

select distinct doc.id, tv1.value
from modx_site_content as doc 
join modx_site_tmplvar_contentvalues as tv1
on tv1.tmplvarid="22" and doc.parent="17" and doc.published="1" and doc.deleted="0" and doc.isfolder="0" order by tv1.value

select distinct tv.value, tv.tmplvarid
from modx_site_tmplvar_contentvalues as tv
where tv.tmplvarid="22" order by tv.value

select distinct value, tmplvarid
from modx_site_tmplvar_contentvalues
where tmplvarid="22" order by value