All helpful votes for en-US articles

gistfile1.sql

SELECT positive_search_votes.date_created as created_date, positive_search_votes.votes, all_search_votes.votes, (positive_search_votes.votes/all_search_votes.votes*100) as helpful_votes
FROM 
(
	SELECT DATE(`wiki_helpfulvote`.`created`) as date_created, count(*) as votes
	FROM `wiki_helpfulvote` 
	JOIN `wiki_revision` ON `wiki_helpfulvote`.`revision_id`=`wiki_revision`.`id` 
	JOIN `wiki_document` ON `wiki_revision`.`document_id`=`wiki_document`.`id`
	WHERE `wiki_helpfulvote`.`created` BETWEEN '2012-09-22 0:0:0' AND '2012-09-23 23:59:59'
	AND `wiki_document`.`locale` LIKE 'en-US'
	AND `wiki_helpfulvote`.`user_agent` NOT LIKE '%bot%'
	AND `wiki_helpfulvote`.`helpful` ='1'	
	GROUP by DATE(`wiki_helpfulvote`.`created`)
) as positive_search_votes
JOIN  
(
	SELECT DATE(`wiki_helpfulvote`.`created`) as date_created, count(*) as votes
	FROM `wiki_helpfulvote` 
	JOIN `wiki_revision` ON `wiki_helpfulvote`.`revision_id`=`wiki_revision`.`id` 
	JOIN `wiki_document` ON `wiki_revision`.`document_id`=`wiki_document`.`id`
	WHERE `wiki_helpfulvote`.`created` BETWEEN '2012-09-22 0:0:0' AND '2012-09-23 23:59:59'
	AND `wiki_document`.`locale` LIKE 'en-US'
	AND `wiki_helpfulvote`.`user_agent` NOT LIKE '%bot%'
	GROUP by DATE(`wiki_helpfulvote`.`created`)
) as all_search_votes
ON positive_search_votes.date_created=all_search_votes.date_created;