මේක try කරලා බලපන්..
select x.*, coalesce( y.count,0) from
(SELECT distinct year(logDate) year,a.*
FROM tbl_log ,
( select 1 'month'
union
select 2 'month'
union
select 3 'month'
union
select 4 'month'
union
select 5 'month'
union
select 6 'month'
union
select 7 'month'
union...