i wrote the join query with customer table. the query is, when i execute this query they will return 5 records 
        
        $collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
                $collection->getSelect()->joinLeft(array('rating'=>'flrating'),'e.entity_id = rating.reviewed_user_id',array('total_rating'=>'count(rating.review_id)'));
                $collection->getSelect()->group('e.entity_id');
    
    
    but when i execute the simple query they will return correct result(6 records)
    
      $collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
            return $collection;
    
    even i put the following code in collection table also the code is
    
     public function getSelectCountSql()
        {
            $countSelect = parent::getSelectCountSql();
            $countSelect->reset(Zend_Db_Select::GROUP);
            return $countSelect;
        }
    can you please explain what is my problem and how to overcome the pagination issue, for your further information see the below screen.
    
       **result with join query:**
![enter image description here][1]

       


**result with simple query**

![enter image description here][2]


  [1]: https://i.sstatic.net/cu48L.png
  [2]: https://i.sstatic.net/LddXv.png