Problem With Cdbcriteria And Cactiveprovider

Hello everyone.

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,, 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.