chamilo / chamilo-lms

            }

            // Showing only the courses of the current Chamilo access_url_id

            if (api_is_multiple_url_enabled()) {

                $url_access_id = api_get_current_access_url_id();

                $tbl_url_rel_course = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);

                if ($category_code != "ALL") {

                    $sql = "SELECT * FROM $tbl_course as course

                            INNER JOIN $tbl_url_rel_course as url_rel_course

                            ON (url_rel_course.c_id = course.id)

                            WHERE

                                access_url_id = $url_access_id AND

                                category_code='$category_code'

                                $without_special_courses

                                $visibilityCondition

                            ORDER BY title $limitFilter";

                } else {

                    $sql = "SELECT * FROM $tbl_course as course

                            INNER JOIN $tbl_url_rel_course as url_rel_course

                            ON (url_rel_course.c_id = course.id)

                            WHERE

                                access_url_id = $url_access_id

                                $without_special_courses

                                $visibilityCondition

                            ORDER BY title $limitFilter";

                }

            }

        }

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

                    ON (s.id_coach = u.user_id) ".

            $where;

        if (api_is_multiple_url_enabled()) {

            $table_access_url_rel_session = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $where .= " AND ar.access_url_id = $access_url_id ";

                $query = "$select

                    FROM $tbl_session s

                    LEFT JOIN $tbl_session_field_values fv ON (fv.session_id = s.id)

                    LEFT JOIN $tbl_session_field_options fvo ON (fv.field_id = fvo.field_id)

                    LEFT JOIN $tbl_session_rel_course src ON (src.id_session = s.id)

                    LEFT JOIN $tbl_course c ON (src.c_id = c.id)

                    LEFT JOIN $tbl_session_category sc ON (s.session_category_id = sc.id)

                    INNER JOIN $tbl_user u ON (s.id_coach = u.user_id)

                    INNER JOIN $table_access_url_rel_session ar ON (ar.session_id = s.id)

                    $where";

            }

        }

        $query .= ") AS session_table";