buscando y rebuscando entre muchos querys, me di cuenta de como podía arreglar mi problema, para aquellos que talves topen con esto aqui sta la solución.
Código MySQL:
Ver original(
) AS s
ON s.idtarea
= t.id
o4.idges
= 3 AND o4.tipo
= 4 AND o4.idare
= 65 +---------+-------+----------+---------------------+
| IDOPERA | TAREA | promedio | fecha |
+---------+-------+----------+---------------------+
| 760 | 55 | 20 | 2010-12-06 00:00:00 |
| 760 | 56 | 54 | 2010-12-06 00:00:00 |
| 761 | 59 | 90 | 2010-12-06 00:00:00 |
| 761 | 60 | 80 | 2010-12-06 00:00:00 |
| 761 | 61 | 70 | 2010-12-06 00:00:00 |
| 763 | 62 | 15 | 2010-12-06 00:00:00 |
| 764 | 63 | 67 | 2010-12-06 00:00:00 |
| 764 | 64 | 8 | 2010-12-06 00:00:00 |
| 765 | 65 | 96 | 2010-12-06 00:00:00 |
| 768 | 71 | 50 | 2010-12-06 00:00:00 |
| 768 | 72 | 80 | 2010-12-06 00:00:00 |
| 771 | 70 | 30 | 2010-12-06 00:00:00 |
| 772 | 57 | 50 | 2010-12-06 00:00:00 |
| 772 | 58 | 50 | 2010-12-06 18:55:00 |
+---------+-------+----------+---------------------+