PHP / MYSQL – Counting How Many Consecutive Previous Weeks Results Have Same Value As Current Week (Music Charts)

I’m trying (and failing) miserably to come up with a mysql query to calculate how many times a song has previously been in the same chart position on previous consecutive weeks. So for example, given the data set below, how would I write a query (based on supplying a date) which returns: