SELECT params.module_param__name0,stat.auto__id0,MAX(stat.time__id0)
FROM stat,
(SELECT updates.host__id0,updates.time__id0
FROM updates 
WHERE host__id0=(SELECT host__id0 
		 FROM updates 
		 WHERE update__type0='hostname' 
		 AND value__id0='sys367.dhcp.local' 
		 ORDER BY time__id0 
		 DESC LIMIT 1) 
GROUP BY time__id0) AS times,
(SELECT module_param__id0,module_param__name0
FROM module_param
WHERE module__id0=(SELECT module__id0
		   FROM module
		   WHERE module__name0='net'
		   LIMIT 1)
AND module_param__name0 REGEXP '^(ip|model|name)$') AS params
WHERE stat.module_param__id0=params.module_param__id0
AND stat.time__id0=times.time__id0
AND stat.host__id0=times.host__id0
GROUP BY params.module_param__name0