Ohne zerbrochenen Code, es kann eigentlich nur das gemeint sein:
SELECT * FROM (SELECT * FROM value v, devices d WHERE v.geraet_id = d.id AND d.art ='1' ) as t WHERE DATE_FORMAT( t.zeit, '%i' ) = '00' AND t.zeit BETWEEN '2006.10.30 0:00:00' AND '2006.10.30 09:08:02'
Kommentar