I have a problem with CActiveDataProvider and CDbCriteria.
I want to run a query to later show a CGridView.
The query is:
"[b]SELECT u.id_user, u.name, count(u.id_user)
FROM user u LEFT JOIN experiment e ON u.id_user = e.id_user GROUP BY u.id_user ORDER BY u.id_user ASC[/b]"
Run the query in SQL is easy and doesn´t cause problems, but I need to know how to make that query with CBdCriteria, because from what I’ve seen, CActiveDataProvider necessarily need to send an CDbCriteria.
Thank you very much.