• Extra: Using where; Using index; Using temporary; Using filesort
• id: 1
• key: writeuptype
• key_len: 4
• possible_keys: PRIMARY,writeuptype
• ref:
• rows: 257650
• select_type: PRIMARY
• table: writeup
• type: range
• Extra: Using where; Using index
• id: 1
• key: PRIMARY
• key_len: 4
• possible_keys: PRIMARY
• ref: everything.writeup.writeup_id
• rows: 16
• select_type: PRIMARY
• table: vote
• type: ref
• Extra: Using index
• id: 2
• key: PRIMARY
• key_len: 8
• possible_keys: PRIMARY,voter_user,vote_voter_user
• ref: everything.vote.vote_id,const
• rows: 1
• select_type: DEPENDENT SUBQUERY
• table: v2
• type: eq_ref

EXPLAIN SELECT vote_id, count(vote_id) 
	AS totalvotes 
	FROM vote INNER JOIN writeup ON writeup_id=vote_id 
	WHERE NOT EXISTS (SELECT 1 
		FROM vote AS v2 
		WHERE v2.vote_id=vote.vote_id 
		AND voter_user=1503725) 
	AND  wrtype_writeuptype<>177599 
	GROUP BY vote_id HAVING totalvotes<=3 
LIMIT 300