select m.*
from media_categorise c, media m
where c.categorise_id = m.categorise_id and m.is_publish = 1 and c.group_id = 3 and m.is_drop = 0
order by m.publish_time desc
limit 0, 8
select m.*
from media_categorise c, media m
where c.categorise_id = m.categorise_id and m.is_publish = 1 and c.group_id = 6 and m.is_drop = 0
order by m.publish_time desc
limit 0, 11