Retrieves post with id 23 using the 'first' finder.
Posts::first(array('conditions' => array('id' => 23)));
Posts::findById(23);
Posts::findById(23);
All posts that have a trueish is_published field.
Posts::all(array('conditions' => array('is_published' => true)));
Posts::findAll(array('conditions' => array('is_published' => true)));
Posts::findAllByIsPublshed(true)
Counts all posts.
Posts::count()