Subversion Repositories yanc

Compare Revisions

Rev 98 → Rev 99

trunk/model/Subscriber_JA_Model.php
45,7 → 45,9
public function getCount(){
$where = $this->_where();
 
$query = 'SELECT COUNT(1) FROM #__yanc_subscribers s ';
$query = 'SELECT COUNT(1) FROM #__yanc_subscribers s
LEFT JOIN #__yanc_letters AS l ON s.lid = l.id
LEFT JOIN #__users u ON s.uid = u.id ';
if(count($where) > 0){
$query .= 'WHERE ' . implode(' AND ', $where) . ' ';
}