Custom mySQL query/filter in snippet - no results [Evolution]

<?php
function getPrice() {
global $modx;
$output = '';

$result = $modx->db->query( '

           SELECT t3.value

           FROM         `hlp_site_tmplvar_contentvalues` t 
           INNER JOIN   (`hlp_site_tmplvar_contentvalues` t2,  
                                `hlp_site_tmplvar_contentvalues` t3)

           ON           t.contentid = t2.contentid
           AND          t2.contentid = t3.contentid
           AND          t.tmplvarid = '48' 
           AND          t2.tmplvarid = '50'
           AND          t3.tmplvarid = '26'

           WHERE      t.value >= '28' AND t2.value >= '24'

           ORDER BY t3.value ASC 
           LIMIT 1
           ');

if( $modx->db->getRecordCount( $result ) >= 1 ) {
      while( $row = $modx->db->getRowArray( $result ) ) {
            $output .= 'Value: ' . $row['t3.value'];
            }
}

else {
    $output = 'No records to show' ;
}
return $output;
}
?>

$result = $modx->db->query( " SELECT ... etc ........  " );

if(!function_exists('getPrice')) {
   function getPrice() {
   ...
   }
}

	           SELECT value
	
	           FROM   `hlp_site_tmplvar_contentvalues`
	
	           WHERE  tmplvarid = '26'
	
	           ORDER BY value ASC 
	           LIMIT 10

      while( $row = $modx->db->getRow($result) ) {
            $output .= 'Value: ' . $row['value'];
            }

$rows=$modx->db->makeArray($result);

if (count($rows)>0){
    //echo'<pre>'.print_r($rows,1).'</pre>';
    foreach ($rows as $row){
        $output .= 'Value: ' . $row['value'];
    }
}