Hello,
Code:
SELECT sql_calc_found_rows gstime,
MAX(stoptime) AS mx,
MIN(starttime) AS mn,
Sec_to_time(SUM(Time_to_sec(Timediff(stoptime, starttime)))) AS totalworktime
FROM (SELECT gstime,
gstime AS stoptime,
Coalesce((SELECT MAX(b.gstime)
FROM xydata b
WHERE objectid = '17'
AND clientid = '1'
AND gstime > '2010-04-20 08:22:27'
AND gstime < '2010-04-26 10:22:27'
AND b.objectid = a.objectid
AND b.gstime < a.gstime), gstime) AS starttime
FROM xydata a
INNER JOIN fm4features f
ON f.id = a.id
WHERE objectid = '17'
AND clientid = '1'
AND gstime > '2010-04-20 08:22:27'
AND gstime < '2010-04-26 10:22:27'
AND f.dataid = '1'
AND f.VALUE = '1') derived
GROUP BY Date_format(gstime, '%Y-%m-%d')
ORDER BY gstime ASC
How do i change this into Hibernate,
please help me anybody having idea.
Bakthavachalam E