vijinho / f3-cms

        // get total results

        $query = 'SELECT COUNT(*) AS results FROM ' . $db->quotekey($m->table()) . ' WHERE ';

        if (empty($users_uuid)) {

             $query .= join(' OR ', $sqlClauses);

        } else {

             $query .= ' users_uuid = ' . $db->quote($users_uuid)  . ' AND ('.  join(' OR ', $sqlClauses) . ')';

        }

        $rows = $db->exec($query);

        $rows = (int) $rows[0]['results'];

        if ($rows < 1) {

        // retrieve results

        $query = 'SELECT * FROM ' . $db->quotekey($m->table()) . ' WHERE ';

        if (empty($users_uuid)) {

             $query .= join(' OR ', $sqlClauses);

        } else {

             $query .= ' users_uuid = ' . $db->quote($users_uuid)  . ' AND ('.  join(' OR ', $sqlClauses) . ')';

        }

        $query .= sprintf(' LIMIT %d,%d', (1 == $page) ? 0 : ($page - 1) * $perPage, $perPage);

        $results = $db->exec($query);

        foreach ($results as $row) {