Helpful votes for en-US how-to articles

gistfile1.txt

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`
	JOIN `wiki_helpfulvotemetadata` ON `wiki_helpfulvote`.`id`=`wiki_helpfulvotemetadata`.`vote_id`
	WHERE `wiki_helpfulvote`.`created` >= '2012-01-01'
	AND `wiki_document`.`locale` LIKE 'en-US'
	AND `wiki_helpfulvote`.`user_agent` NOT LIKE '%bot%'
	AND `wiki_helpfulvote`.`helpful` ='1'
	AND `wiki_document`.`category`='20'
	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`
	JOIN `wiki_helpfulvotemetadata` ON `wiki_helpfulvote`.`id`=`wiki_helpfulvotemetadata`.`vote_id`
	WHERE `wiki_helpfulvote`.`created` >= '2012-01-01'
	AND `wiki_document`.`locale` LIKE 'en-US'
	AND `wiki_document`.`category`='20'
	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;