{"issue":{"state":"open","created_at":"2011-10-30T21:05:11Z","updated_at":"2011-11-22T15:15:12Z","comments":3,"user":{"gravatar_id":"d2f15c42f38a9a049809574c3bc033d2","id":203899,"url":"https://api.github.com/users/pplegend","login":"pplegend","avatar_url":"https://secure.gravatar.com/avatar/d2f15c42f38a9a049809574c3bc033d2?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"body":"select * from observation_record where ido_type=3 and idperson=28 and idproject=14;                                                                              \r\n+------------+----------+----------+----------+-----------+---------------------+\r\n| ido_record | ido_type | idmobile | idperson | idproject | time                |\r\n+------------+----------+----------+----------+-----------+---------------------+\r\n|     218087 |        3 |        4 |       28 |        14 | 2011-10-06 13:29:00 |\r\n|     218122 |        3 |        4 |       28 |        14 | 2011-10-06 13:29:00 |\r\n|     218125 |        3 |        4 |       28 |        14 | 2011-10-06 13:29:00 |\r\n+------------+----------+----------+----------+-----------+---------------------+\r\n\r\n select * from observation_record_value where ido_record in (218087,218122,218125);\r\n+-----------+------------+-------------+-------+\r\n| ido_value | ido_record | ido_keyname | value |\r\n+-----------+------------+-------------+-------+\r\n|    216865 |     218087 |          30 | 119.0 |\r\n|    216866 |     218087 |          31 | 66.0  |\r\n|    216965 |     218122 |          30 | 119.0 |\r\n|     216966 |     218122 |          31 | 66.0  |\r\n|    216969 |     218125 |          30 | 119.0 |\r\n|    216970 |     218125 |          31 | 66.0  |\r\n+-----------+------------+-------------+-------+","assignee":{"gravatar_id":"7574675017b72e7b500d0f75d5768e1e","id":471529,"url":"https://api.github.com/users/zxhwd2008","login":"zxhwd2008","avatar_url":"https://secure.gravatar.com/avatar/7574675017b72e7b500d0f75d5768e1e?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"id":2092200,"labels":[{"name":"API","color":"02e10c","url":"https://api.github.com/repos/sizzlelab/side/labels/API"},{"name":"Mobile","color":"d7e102","url":"https://api.github.com/repos/sizzlelab/side/labels/Mobile"}],"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"number":18,"title":"duplicate records","html_url":"https://github.com/sizzlelab/side/issues/18","closed_at":null,"url":"https://api.github.com/repos/sizzlelab/side/issues/18","milestone":null},"action":"created","comment":{"created_at":"2011-11-22T15:15:12Z","updated_at":"2011-11-22T15:15:12Z","user":{"gravatar_id":"bc4ad3cc0da6b841ceee97de021680ad","id":362205,"url":"https://api.github.com/users/mataanin","login":"mataanin","avatar_url":"https://secure.gravatar.com/avatar/bc4ad3cc0da6b841ceee97de021680ad?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"body":"Until 27th.","id":2835462,"url":"https://api.github.com/repos/sizzlelab/side/issues/comments/2835462"}}