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);

        while ($row = Database::fetch_array($result)) {

                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;