select m.*, mg.*, mc.* from media m, media_categorise mc, media_group mg where m.create_user = 10181 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 = 10181 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 = 10181 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 = 10181 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 = 10181 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 = 10181 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 = 10181 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