This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use the new forum.
Home » plugins » User management plugins » count query
count query [message #61529] Mon, 22 September 2008 15:51
mechandankr  is currently offline mechandankr
Messages: 22
Registered: May 2008
Location: noida
Junior Member
This query:

select p.property_name, COUNT(c.commentable_id) as count from promoter as p left join sf_comment as c on p.id=c.commentable_id group by p.id


how to write with Criteria.

Help?


Thanks

[Updated on: Mon, 22 September 2008 15:52]

Previous Topic:sfGuard Usage
Next Topic:Redirecting to the refering page: after successfully login
Goto Forum:
  

powered by FUDforum - copyright ©2001-2004 FUD Forum Bulletin Board Software