SELECT make, model, yr, listprice, imagename, id, color, mu.accountno, vin, city, state, new FROM majorunit mu, members mb WHERE mu.accountno = mb.accountno AND vehtype = 'MOTORCYCLES' AND new = 'NEW' AND make = 'HARLEY-DAVIDSON' group by make, model, yr order by yr desc, make, model