spookyru

$query = $modx->prepare($sql);
	$modx->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	
	try
	{
	    $query->execute($paramArray);
	    return $query->fetchAll(PDO::FETCH_ASSOC);
	}
	catch (PDOException $e) {
          //log exception
        }

$sql = 'SELECT имяполя, COUNT(*) FROM ' . $modx->getTableName('КлассТаблицы1') . ' t1, ' . $modx->getTableName('КлассТаблицы2') . ' t2, WHERE t1.имяполя = t2.имяполя2 GROUP BY t1.имяполя ORDER BY COUNT(*) ASC ';