Select d.draw, count(damssire.horse_name) as count_offspring, 
           sire.horse_name as sire,d.class_name, l.event_name, l.sponsor_logo, 
             sire.horse_name AS sire_name, 
             damssire.pedid as damssire_id,dam.horse_name AS dam_name,
             damssire.horse_name AS damssire_name, l.sponsor_url, damssire.pedid as damssire_id
            FROM draws d
            JOIN
               list_events l
            ON
               l.eventid = d.eventresults_id
              LEFT JOIN 
                horse_ped_ids h ON d.pedigree_id = h.pedid 
            LEFT JOIN
                horse_ped_ids AS sire ON h.sireid = sire.pedid
            LEFT JOIN
                horse_ped_ids AS dam ON h.damid = dam.pedid
            LEFT JOIN
                horse_ped_ids AS damssire ON dam.sireid = damssire.pedid
            WHERE
                damssire.horse_name IS NOT NULL
            AND 
                damssire.horse_name!=''
            AND 0=0  GROUP BY
                damssire.horse_name
             ORDER BY Earners desc<BR><BR>Unknown column 'Earners' in 'ORDER BY'