I have a MYSQL table with the following columns:
ID, catagoryID1, catagoryID2, score
catagoryID1 and catagoryID2 are keys referencing the same "catagory" table.
I need a query that will give me the row ID of the 10 highest score values, ordered by score values but not duplicating a categoryID whether it is from categoryID1 or categoryID2.
I have spent way to much time on this and am still baffled.