Nontrivial active records question

[eluser]german.zvonchuk[/eluser]
Hi, Cristian Gilè.

Thank you, for the help. But I decided that using Active Records it's not possible to generate such a query.

Below is the query which is generated by Active Query using your method:

Code:

SELECT COUNT(*) AS `numrows`
FROM (`item`)
WHERE `id_item_type` = '1'
OR `id_item_type` = '2'
AND `id_item_target` = '1'

And this is what I want the query to be:

Code:

SELECT COUNT(*) AS `numrows`
FROM (`item`)
WHERE (`id_item_type` = '1' OR `id_item_type` = '2')
AND `id_item_target` = '1'