My Media : 151020

Publishing

Document

VDO

e-Courseware

Sound

Photo

Mobile

ศูนย์นวัตกรรมและเทคโนโลยีการศึกษา The Center for Educational Innovation and Technology

อาคารเครื่องมือ 7 (F7) มหาวิทยาลัยเทคโนโลยีสุรนารี ต.สุรนารี อ.เมือง จ.นครราชสีมา 30000 โทรศัพท์ 0-4422-4972 โทรสาร 0-4422-4974 e-mail : elearning@sut.ac.th

select m.*, mg.*, mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 1 order by m.media_id desc

select m.*, mg.*, mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 2 order by m.media_id desc

select m.*, mg.*, mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 3 order by m.media_id desc

select m.*, mg.*, mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 4 order by m.media_id desc

select m.*, mg.*, mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 5 order by m.media_id desc

select m.*, mg.*, mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 6 order by m.media_id desc

select m.*, mg.*, mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 7 order by m.media_id desc

My Media : 151020

select m., mg., mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 1 order by m.media_id desc

select m., mg., mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 2 order by m.media_id desc

select m., mg., mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 3 order by m.media_id desc

select m., mg., mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 4 order by m.media_id desc

select m., mg., mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 5 order by m.media_id desc

select m., mg., mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 6 order by m.media_id desc

select m., mg., mc.* from media m, media_categorise mc, media_group mg where m.create_user = 19357 and m.is_publish = 1 and m.is_drop = 0 and m.categorise_id = mc.categorise_id and mc.group_id = mg.group_id and mg.group_id = 7 order by m.media_id desc