Lines Matching refs:FROM

90         $count = $this->helper->getDB()->queryValue('SELECT COUNT(*) FROM users');
98         $count = $this->helper->getDB()->queryValue('SELECT COUNT(*) FROM users');
101 … $user = $this->helper->getDB()->queryValue('SELECT user FROM users WHERE user = ?', ['testuser']);
134 …$count = $this->helper->getDB()->queryValue('SELECT COUNT(*) FROM groups WHERE user = ?', ['testus…
138 …$loggedGroups = $this->helper->getDB()->queryAll('SELECT `group` FROM groups WHERE user = ?', ['te…
347         $count = $this->helper->getDB()->queryValue('SELECT COUNT(*) FROM outlinks');
350 … $outlink = $this->helper->getDB()->queryRecord('SELECT * FROM outlinks ORDER BY dt DESC LIMIT 1');
600         $this->helper->getDB()->exec('DELETE FROM campaigns WHERE session = ?', [self::SESSION_ID]);
613                 'SELECT * FROM campaigns WHERE session = ? ORDER BY rowid DESC LIMIT 1',
624                 'SELECT COUNT(*) FROM campaigns WHERE session = ?',
644         $this->helper->getDB()->exec('DELETE FROM campaigns WHERE session = ?', [self::SESSION_ID]);
661             'SELECT COUNT(*) FROM campaigns WHERE session = ?',