Duplicate record script | Efficiency boost
The troubles with count aside, probably simplest way to make that query fast is adding multicolumn index

(console, price, purchased)


if table wishlist is InnoDB and ID is primary key or

(console, price, purchased, ID)


if table wishlist is MyISAM.

Such index is enough to cover the query.