Query failed (SELECT id FROM dances  d INNER JOIN publications p ON d.publication=p.pub WHERE  ( publication = "Country Dance Book, New Series" OR adaptorPublication="Country Dance Book, New Series") AND  hasKRCD  ORDER BY p.pubYear,p.sortPublication,ABS(yearCreated), sortName, name): Column 'id' in field list is ambiguous