Can anyone help me construct this query? In ad hoc php/ html programming I've had a query within a result loop. I'm sure it must be easier than this.

Any advice would be gratefully received.