SELECT YEAR(date_order) AS year, collecting.id, collecting, collecting_en, count(record.id) AS number FROM `collecting` LEFT JOIN record ON id_collecting=collecting.id GROUP BY collecting.id ORDER BY date_order