SELECT person.initials, person.last_name, DATE_FORMAT(sale_annual.sale_date,'%D %b, %Y') as formated_date, member.herd_prefix, sale_annual.sale_name, sale_annual.sale_location, sale_annual.sale_type, sale_annual.sale_breed, sale_annual.sale_id, sale_annual.sale_north_south, sale_annual.sale_combined, sale_participants.no_sold, sale_participants.avg_price, sale_participants.top_price, sale_participants.purchaser,sale_participants.comments
FROM person RIGHT JOIN (member RIGHT JOIN (sale_annual LEFT JOIN sale_participants ON sale_annual.sale_id = sale_participants.sale_id) ON member.id = sale_participants.member_id) ON person.id = member.person_id
WHERE sale_annual.sale_breed = ''
AND YEAR(sale_annual.sale_date) = 2010
AND sale_type = '2yr'
AND sale_participants.no_sold > 0
ORDER BY sale_annual.sale_north_south, sale_annual.sale_date, sale_annual.sale_id;
