MySQL – left join on last (or first) record in the right table | Murray Hopkins' bits and pieces

After spending a few hours searching and testing this one I thought I'd better share it since I found many similar questions but no answers. I am not a MySQL expert so there may be a better way to do this. Please tell me if there is!! This is a simplified

murrayhopkins.wordpress.com