sizzlelab/side — Issue #18: duplicate records
Author: pplegend
Created: 2011-10-30 21:05:11+00:00
State: open

select * from observation_record where ido_type=3 and idperson=28 and idproject=14;
+------------+----------+----------+----------+-----------+---------------------+
| ido_record | ido_type | idmobile | idperson | idproject | time |
+------------+----------+----------+----------+-----------+---------------------+
| 218087 | 3 | 4 | 28 | 14 | 2011-10-06 13:29:00 |
| 218122 | 3 | 4 | 28 | 14 | 2011-10-06 13:29:00 |
| 218125 | 3 | 4 | 28 | 14 | 2011-10-06 13:29:00 |
+------------+----------+----------+----------+-----------+---------------------+

select * from observation_record_value where ido_record in (218087,218122,218125);
+-----------+------------+-------------+-------+
| ido_value | ido_record | ido_keyname | value |
+-----------+------------+-------------+-------+
| 216865 | 218087 | 30 | 119.0 |
| 216866 | 218087 | 31 | 66.0 |
| 216965 | 218122 | 30 | 119.0 |
| 216966 | 218122 | 31 | 66.0 |
| 216969 | 218125 | 30 | 119.0 |
| 216970 | 218125 | 31 | 66.0 |
+-----------+------------+-------------+-------+