SELECT * FROM
               `tag_video` AS `tag_video`,
               `tags` AS `tags`,
               `videos` AS `videos` WHERE
                tags.tag='islandais' 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, 20