在SQL中排序：最旧的记录，但在x行中没有重复值

I have a queue of photos to be featured on the homepage of a photography site. Photographers tend to upload several dozen shots at once, meaning that editors selecting the best of the uploads are very likely to put several shots from the same photographer onto the queue one after the other. But we don't want one photographer to own the homepage for hours on end.I have a queue of photos to be featured on the