note: the human brain is not in a satisfactory state to write complex SQL queries in the late afternoon. try again in the morning.