Table not exist
SELECT xbtc_danh_muc_chung_id as k,CONCAT(xbtc_danh_muc_chung_ma , ' - ' ,xbtc_danh_muc_chung_ten_vn) as ten FROM xbtc_danh_muc_chung WHERE UPPER(xbtc_danh_muc_chung_ten_bang) = UPPER(?) AND xbtc_danh_muc_chung_ma NOT IN('04','05','06') AND xbtc_danh_muc_chung_en = 1 ORDER BY xbtc_danh_muc_chung_ma

Table not exist
SELECT xbtc_danh_muc_chung_id as k,CONCAT(xbtc_danh_muc_chung_ma , ' - ' ,xbtc_danh_muc_chung_ten_vn) as ten FROM xbtc_danh_muc_chung WHERE UPPER(xbtc_danh_muc_chung_ten_bang) = UPPER(?) AND xbtc_danh_muc_chung_en = 1 ORDER BY xbtc_danh_muc_chung_ma

Table not exist
SELECT DISTINCT xbtc_tap_chi_id, xbtc_tap_chi_so,xbtc_tap_chi_ngay_xb FROM xbtc_tap_chi where xbtc_tap_chi_hien_thi =1 ORDER BY xbtc_tap_chi_ngay_xb desc,xbtc_tap_chi_so

Table not exist
SELECT * FROM xbtc_thong_so_chung

Table not exist
SELECT xbtc_danh_muc_chung_id as k, xbtc_danh_muc_chung_ten_vn as ten FROM xbtc_danh_muc_chung WHERE UPPER(xbtc_danh_muc_chung_ten_bang) = UPPER(?) AND xbtc_danh_muc_chung_id in (select distinct xbtc_danh_muc_chung_id_cha from xbtc_bai_bao inner join xbtc_danh_muc_chung on xbtc_linh_vuc_id = xbtc_danh_muc_chung_id where xbtc_bai_bao_trong_truong = 1 AND xbtc_trang_thai_bai_bao_ma = 'CongBo' ) ORDER BY xbtc_danh_muc_chung_ten

Table not exist
SELECT DISTINCT(xbtc_ban_tin_dinh_ky_nam) FROM xbtc_ban_tin_dinh_ky ORDER BY xbtc_ban_tin_dinh_ky_nam DESC

Table not exist
SELECT distinct xbtc_bc_thuong_nien_nam ten FROM xbtc_bao_cao_thuong_nien ORDER BY xbtc_bc_thuong_nien_nam DESC

Table not exist
SELECT DISTINCT xbtc_tap_chi_id, xbtc_tap_chi_so,xbtc_tap_chi_ngay_xb FROM xbtc_tap_chi where xbtc_tap_chi_hien_thi = 1 AND xbtc_tap_chi_ngon_ngu = 1 ORDER BY xbtc_tap_chi_ngay_xb desc,xbtc_tap_chi_so

Table not exist
SELECT DISTINCT xbtc_tap_chi_id, xbtc_tap_chi_so,xbtc_tap_chi_ngay_xb FROM xbtc_tap_chi where xbtc_tap_chi_hien_thi = 1 AND xbtc_tap_chi_ngon_ngu = 2 ORDER BY xbtc_tap_chi_ngay_xb desc,xbtc_tap_chi_so

Table not exist
SELECT DISTINCT a.xbtc_bai_bao_nam FROM xbtc_bai_bao a, xbtc_danh_muc_chung b WHERE a.xbtc_loai_bai_bao_id = b.xbtc_danh_muc_chung_id AND a.xbtc_trang_thai_bai_bao_ma = ? AND a.xbtc_bai_bao_trong_truong =0 AND b.xbtc_danh_muc_chung_ma IN ('01','02','03') AND a.xbtc_bai_bao_trong_nuoc = 1 AND a.xbtc_bai_bao_trong_truong = 0 ORDER BY a.xbtc_bai_bao_nam DESC

Table not exist
SELECT DISTINCT a.xbtc_bai_bao_nam FROM xbtc_bai_bao a, xbtc_danh_muc_chung b WHERE a.xbtc_loai_bai_bao_id = b.xbtc_danh_muc_chung_id AND a.xbtc_trang_thai_bai_bao_ma = ? AND a.xbtc_bai_bao_trong_truong =0 AND b.xbtc_danh_muc_chung_ma IN ('01','02','03') AND a.xbtc_bai_bao_trong_nuoc = '0' ORDER BY a.xbtc_bai_bao_nam DESC

Table not exist
SELECT DISTINCT a.xbtc_bai_bao_nam FROM xbtc_bai_bao a, xbtc_danh_muc_chung b WHERE a.xbtc_loai_bai_bao_id = b.xbtc_danh_muc_chung_id AND a.xbtc_trang_thai_bai_bao_ma = ? AND a.xbtc_bai_bao_trong_truong =0 AND b.xbtc_danh_muc_chung_ma = '05' ORDER BY a.xbtc_bai_bao_nam DESC

Table not exist
SELECT DISTINCT a.xbtc_bai_bao_nam FROM xbtc_bai_bao a, xbtc_danh_muc_chung b WHERE a.xbtc_loai_bai_bao_id = b.xbtc_danh_muc_chung_id AND a.xbtc_trang_thai_bai_bao_ma = ? AND a.xbtc_bai_bao_trong_truong =0 AND b.xbtc_danh_muc_chung_ma = '06' ORDER BY a.xbtc_bai_bao_nam DESC

Table not exist
SELECT DISTINCT a.xbtc_bai_bao_nam FROM xbtc_bai_bao a, xbtc_danh_muc_chung b WHERE a.xbtc_loai_bai_bao_id = b.xbtc_danh_muc_chung_id AND a.xbtc_trang_thai_bai_bao_ma = ? AND a.xbtc_bai_bao_trong_truong =0 AND b.xbtc_danh_muc_chung_ma = '04' ORDER BY a.xbtc_bai_bao_nam DESC

Table not exist
SELECT doc_gia_so_dong_tren_trang FROM XBTC_THONG_SO_CHUNG

Table not exist
SELECT * FROM xbtc_ban_tin_dinh_ky ORDER BY xbtc_ban_tin_ngay_tao DESC

Table not exist
SELECT baibao.xbtc_bai_bao_id, baibao.xbtc_bai_bao_ma_doi, baibao.xbtc_bai_bao_ma_doi_trang_thai, baibao.xbtc_bai_bao_ten_vn as xbtc_bai_bao_ten,baibao.xbtc_bai_bao_nam,ql_guest_id, CONCAT(baibao.ql_guest_id , ',' , ifnull(baibao.xbtc_dong_tac_gia, '') ) nhom_tac_gia_id, baibao.xbtc_nhom_tac_gia_hien_thi as nhom_tac_gia_hien_thi, baibao.xbtc_trang_thai_bai_bao_ma, baibao.xbtc_bai_bao_trong_truong, baibao.xbtc_bai_bao_tom_tat, baibao.xbtc_nha_xuat_ban, baibao.xbtc_bai_bao_ten_tap_chi, xbtc_trich_dan.xbtc_trich_dan_noi_dung, case when xbtc_bai_bao_trong_truong=1 then xbtc_tap_chi.xbtc_tap_chi_so else baibao.XBTC_BAI_BAO_SO_TAP_CHI END xbtc_tap_chi_so, case when xbtc_bai_bao_trong_truong=1 then xbtc_noi_dung_tap_chi.xbtc_xuat_ban_so_trang else baibao.xbtc_bai_bao_so_trang END xbtc_bai_bao_so_trang FROM XBTC_BAI_BAO baibao LEFT JOIN xbtc_noi_dung_tap_chi ON xbtc_noi_dung_tap_chi.xbtc_bai_bao_id = baibao.xbtc_bai_bao_id LEFT JOIN xbtc_tap_chi ON xbtc_tap_chi.xbtc_tap_chi_id = xbtc_noi_dung_tap_chi.xbtc_tap_chi_id LEFT JOIN xbtc_trich_dan ON baibao.xbtc_bai_bao_id = xbtc_trich_dan.xbtc_bai_bao_id AND XBTC_TRICH_DAN_TRANG_THAI = 1 WHERE xbtc_bai_bao_trong_truong = 1 AND baibao.xbtc_trang_thai_bai_bao_ma IN('DaXuatBan', 'CongBo') ORDER BY IFNULL(xbtc_bai_bao_ngay_cap_nhat,0) desc

Bài báo - Tạp chí :: Quản lý đào tạo - TRƯỜNG ĐẠI HỌC Y - DƯỢC
  • Dữ liệu chưa được khởi tạo.
    • Trang chủ
    Bản tin định kỳ
      Bài báo mới nhất
         
         
         
         
        Vui lòng chờ...