chamilo / chamilo-lms

                $order_clause.

                ' LIMIT 10';

        if (api_is_multiple_url_enabled()) {

            $tbl_user_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $sql = 'SELECT username, lastname, firstname

                        FROM '.$tbl_user.' user

                        INNER JOIN '.$tbl_user_rel_access_url.' url_user

                        ON (url_user.user_id=user.user_id)

                        WHERE

                            access_url_id = '.$access_url_id.'  AND

                            (

                                username LIKE "'.$needle.'%" OR

                                firstname LIKE "'.$needle.'%" OR

                                lastname LIKE "'.$needle.'%"

                            )

                            AND status=1'.

                        $order_clause.'

                        LIMIT 10';

            }

        }

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

        while ($user = Database :: fetch_array($rs)) {

                INNER JOIN '.$tbl_session.' as session

                ON session.id = session_course.session_id

                AND session.id_coach = ' . $coach_id;

        if (api_is_multiple_url_enabled()) {

            $tbl_session_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $sql = 'SELECT session_course_user.user_id

                        FROM '.$tbl_session_course_user.' as session_course_user

                        INNER JOIN '.$tbl_session_user.' sru

                        ON session_course_user.user_id = sru.user_id AND

                           session_course_user.session_id = sru.session_id

                        INNER JOIN '.$tbl_session_course.' as session_course

                        ON session_course.c_id = session_course_user.c_id AND

                        session_course_user.session_id = session_course.session_id

                        INNER JOIN '.$tbl_session.' as session

                        ON session.id = session_course.session_id AND

                        session.id_coach = '.$coach_id.'

                        INNER JOIN '.$tbl_session_rel_access_url.' session_rel_url

                        ON session.id = session_rel_url.session_id 

                        WHERE access_url_id = '.$access_url_id;

            }

        }

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

                INNER JOIN ' . $tbl_course.' as course

                    ON course.id = session_course.c_id';

        if (api_is_multiple_url_enabled()) {

            $tbl_course_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $sql = 'SELECT DISTINCT c.code

                    FROM ' . $tbl_session_course.' as session_course

                    INNER JOIN '.$tbl_course.' c

                    ON (c.id = session_course.c_id)

                    INNER JOIN ' . $tbl_session.' as session

                    ON session.id = session_course.session_id

                        AND session.id_coach = ' . $coach_id.'

                    INNER JOIN ' . $tbl_course.' as course

                        ON course.id = session_course.c_id

                     INNER JOIN '.$tbl_course_rel_access_url.' course_rel_url

                    ON (course_rel_url.c_id = c.id)';

            }

        }

        if (!empty ($id_session)) {

            $sql .= ' WHERE session_course.session_id='.$id_session;