How I had missed this I don't know. thanks vaughan for pointing it out.. I added in the coding for the indexes on 'yesterday' and 'last_update'. Done the frontend changes for last_update, have yet to do the ones for yesterday.