select @pivot_sql;
select t.title, MONTH(ts.date_close) as test_month, YEAR(ts.date_close) as test_year, count(ts.*) as test_count
FROM
test_selected as ts
LEFT JOIN test as t ON ts.id_test = t.id
WHERE ts.date_close BETWEEN :date_begin AND :date_end
GROUP BY t.title, MONTH(ts.date_close),YEAR(ts.date_close)
ORDER BY test_year, test_month