SELECT * FROM
               `tag_video` AS `tag_video`,
               `tags` AS `tags`,
               `videos` AS `videos` WHERE 
                tags.tag='large' AND 
                tags.id=tag_video.tag_id AND
                tag_video.vid=videos.video_id AND
                videos.video_type='public' AND
                videos.video_approve='1' AND
                videos.video_active='1'
                GROUP BY tag_video.vid
                ORDER BY videos.`video_add_time` DESC, tags.tag_count DESC
                LIMIT 0, 10