Help with this SELECT statement

[eluser]jerry4christ[/eluser]
[quote author="rufnex" date="1413537883"]next try ;o)

Code:

->select("SUM(IF(comments.is_active = '1',1,0)) total_comments", false)

[/quote]


Now you just hit the Jackpot!.... Thanks man;-)

but could you please explain what role that false is playing there


Nooooo.... the condition affected the selection on the parent table(blog). it's not supposed to filter the blog:down: