Select roundtime,uljl_jam,ps1_jam FROM (Select SUM(jam_area.jam_ulgl = 1) AS uljl_jam, SUM(jam_area.jam_ps1 = 1) AS ps1_jam, FROM_UNIXTIME(CEIL(UNIX_TIMESTAMP(jam_area.t_stamp) / 60) * 60) roundtime FROM jam_area Where (jam_area.t_stamp BETWEEN :starttime AND :endtime) and ('Induct 1' = :Induct) Group BY FROM_UNIXTIME(CEIL(UNIX_TIMESTAMP(jam_area.t_stamp) / 1800) * 1800) Order By jam_area.t_stamp ASC ) okeyjam