| | |
| | | " ON (m.contact_id = c.".$this->primary_key.")"; |
| | | |
| | | $sql_result = $this->db->limitquery( |
| | | "SELECT * FROM ".$this->db_name." AS c ".$join . |
| | | "SELECT * FROM ".$this->db_name." AS c" . |
| | | $join . |
| | | " WHERE c.del<>1" . |
| | | " AND c.user_id=?" . |
| | | ($this->group_id ? " AND m.contactgroup_id=?" : ""). |
| | |
| | | else if ($this->list_page <= 1) { |
| | | if ($cnt < $this->page_size && $subset == 0) |
| | | $this->result->count = $cnt; |
| | | else if (isset($this->cache['count'])) |
| | | $this->result->count = $this->cache['count']; |
| | | else |
| | | $this->result->count = $this->_count(); |
| | | } |
| | |
| | | // count contacts for this user |
| | | $sql_result = $this->db->query( |
| | | "SELECT COUNT(c.contact_id) AS rows". |
| | | " FROM ".$this->db_name." AS c ".$join. |
| | | " FROM ".$this->db_name." AS c". |
| | | $join. |
| | | " WHERE c.del<>1". |
| | | " AND c.user_id=?". |
| | | ($this->group_id ? " AND m.contactgroup_id=?" : ""). |