How do I sort rows with price * currency rate?
<p>I have a table <strong>properties</strong> in MySQL with price and currency_id columns, and the second table is <strong>currencies</strong> with id and rate.</p>

<p>I need to calculate <em>price</em> multiplied by <em>currency.rate</em> and then sort in Yii CDbCriteria.</p>