How to transfer a query to a Yii model?

Question

Yii

Good afternoon,
I'm wondering how it is possible to execute the following query in Yii

SELECT * FROM users WHERE id IN (SELECT o.user_id FROM orders o WHERE MAX(o.DATE) <= :DATE GROUP BY o.user_id)

1. With the receipt of the object model.
2. With the help of pure SQL and somehow pick up the data.
And I’m also interested in how to execute such a query using Yii and pick up count :

SELECT COUNT(mc_offers .bid_id) 
FROM mc_offers 
LEFT JOIN m_bids ON m_bids.id = mc_offers.bid_id 
WHERE m_bids.customer_id = 'x';

Answer 1

I'm wondering how it is possible to execute the following query in Yii

yiiframework.ru/doc/guide/en/database.dao
or look at the query builder - which is easy to translate your query
look at the link to queryScalar