SELECT * FROM tag_video AS tv, tags AS t, video AS v
			WHERE tv.tag_id = t.id
			AND t.tag = 'spartan'
			AND v.type = 'public'
			AND v.approve =1
			AND v.active =1
			AND v.VID=tv.vid
			group by tv.vid ORDER BY v.title LIMIT 0, 32