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