ACTIVITY FROM ACTIVITY BOX

SELECT DISTINCT 
	animals.id AS animal_id, bursts.daytime, signals.burst, signals.signal, signals.noise, signals.mod
    FROM animals
       LEFT JOIN channelsettings ON(channelsettings.animal = animals.id)
       LEFT JOIN bursts ON(bursts.channel = channelsettings.id)
       LEFT JOIN signals ON(signals.burst = bursts.id)
    WHERE bursts.daytime >= '10-jul-2005' AND bursts.daytime <= '16-jul-2005'
	AND animals.id = 124 
        AND channelsettings.antennas = 64
    ORDER BY animals.id, signals.burst, bursts.daytime