chamilo / chamilo-lms

                $orderBy .= " ORDER BY lastname, firstname ";

            }

            if (!empty($column) && !empty($direction)) {

                // Fixing order due the UNIONs

                $column = str_replace('u.', '', $column);

                $orderBy = " ORDER BY $column $direction ";

            }

        }

        $sql .= $orderBy;

            return $count;

        }

        if (!empty($column) && !empty($direction)) {

            $column = str_replace('u.', '', $column);

            $sql .= " ORDER BY $column $direction ";

        }

        $sql .= $limitCondition;

        $result = Database::query($sql);