Distinct product sizes. How to implement in yii?

Question

Yii

In the category, I pulled out products by category_id, the product has a modification table (id, catalog_id, size_id, count) and a size table (id, size) for the filter, you need to pull out sizes without repetitions. dbdsgnr.appspot.com/app#agdkYmRzZ25ycg8LEgZTY2hlbW... . How about to implement?

Answer 1

select size from products group by size
either way

$criteria = new CDbCriteria;
$criteria->select = ['id',size'];
$criteria->group = 'size';
$sizes = Products::model()->findAll($criteria);