SELECT count(*) as total
		FROM tag_video AS tv, tags AS t, video AS v
		WHERE tv.tag_id = t.id
		AND t.tag = 'hatİpoĞlu'
		AND v.type = 'public'
		AND v.approve =1
		AND v.active =1
		AND v.VID=tv.vid
		group by tv.vid