Lines Matching refs:sql

33             $sql = "SELECT thread_participant.user_id,
42             $r = $this->model->sqlite->query($sql, $from, $to);
44             $sql = "SELECT user_id,
53             $r = $this->model->sqlite->query($sql);
63             $sql = "SELECT COUNT(*)*1.0/COUNT(DISTINCT thread_id) AS kpi
66             $r = $this->model->sqlite->query($sql, $from, $to);
68             $sql = "SELECT COUNT(*)*1.0/COUNT(DISTINCT thread_id) AS kpi
71             $r = $this->model->sqlite->query($sql);
82             $sql = "SELECT COUNT(DISTINCT user_id)
90             $r = $this->model->sqlite->query($sql, $from, $to, $from, $to);
92             $sql = "SELECT COUNT(DISTINCT user_id)
97             $r = $this->model->sqlite->query($sql);
111             $sql = "SELECT label_name,
128             $r = $this->model->sqlite->query($sql, $from, $to);
130             $sql = "SELECT label_name,
147             $r = $this->model->sqlite->query($sql);
157             $sql = "SELECT label_name,
172             $r = $this->model->sqlite->query($sql, $from, $to);
174             $sql = "SELECT label_name,
189             $r = $this->model->sqlite->query($sql);