Command-Line Tutorial

Indexing Database Tables with HTMids

HMpTy can be used from the command-line to add Hierarchical Triangular Mesh (HTM) IDs to any database table that has populated equatorial coordinate columns.

To generate and populate the htm10ID, htm13ID and htm16ID columns on a table run either:

hmpty index transientBucket primaryKeyId raDeg decDeg -s /path/to/my-settings.yaml

where the settings file contains the database credentials:

database settings:
    db: mydatabase
    host: localhost
    user: myusername
    password: mypass

Or alternatively you can pass the credentials in directory via the command-line (less secure obviously):

hmpty index transientBucket primaryKeyId raDeg decDeg --host localhost --user myusername --passwd mypass --dbName mydatabase

Conesearching Database Tables

It’s possible to perform a conesearch on a database table (with existing HTMId columns pre-populated) from the command-line.

The syntax for the cl-conesearch is:

hmpty search <tableName> <raCol> <decCol> <ra> <dec> <radius> (-s <pathToSettingsFile>|--host <host> --user <user> --passwd <passwd> --dbName <dbName>)

So to perform a 10 arcsec conesearch on a transientBucket table with ra and dec columns named raDeg and decDeg respectively around the coordinates “21:19:41.31”, “+21:57:56.3”:

hmpty search transientBucket raDeg decDeg 21:19:41.31 +21:57:56.3 10. -s /path/to/my-settings.yaml
+------------+-------------------+----------+---------------+------------+-----------------------+-------------------------+-----------------+-------------------+----------+---------+---------------+---------------------------------+--------------+------------------------------------------------------------------+--------------------------+----------------------------------------------------------------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------+---------------+-----------+-------------+---------------+---------+-----------------+------------+---------------------+--------------------+-----------+--------------+--------------+------------------+----------------------+-----------------+--------------------+-------------+-------------------------+-----------------------+----------+---------+---------------------------------------------------------------------------------------------------------------------------------------+----------+--------------+----------------------+------------+-----------------+-----------------+--------------+------------------+-----------------+---------------+----------------+
| decDegErr  | hostRedshiftType  | decDeg   | masterIDFlag  | telescope  | lastNonDetectionDate  | sherlockClassification  | discoveryPhase  | dateLastModified  | cy       | cx      | dateLastRead  | transientTypePredicationSource  | dateDeleted  | tripletImageUrl                                                  | transientTypePrediction  | surveyObjectUrl                                                      | htm10ID   | targetImageUrl                                                                                                                           | primaryKeyId  | raDeg     | instrument  | hostRedshift  | filter  | finderImageUrl  | htm13ID    | subtractedImageUrl  | transientRedshift  | raDegErr  | dateCreated  | cmSepArcsec  | observationDate  | classificationPhase  | observationMJD  | transientBucketId  | name        | transientRedshiftNotes  | classificationWRTMax  | tmpFlag  | cz      | referenceImageUrl                                                                                                                     | reducer  | htm16ID      | lastNonDetectionMJD  | magnitude  | survey          | magnitudeError  | limitingMag  | replacedByRowId  | htm20ID         | spectralType  | lightcurveURL  |
+------------+-------------------+----------+---------------+------------+-----------------------+-------------------------+-----------------+-------------------+----------+---------+---------------+---------------------------------+--------------+------------------------------------------------------------------+--------------------------+----------------------------------------------------------------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------+---------------+-----------+-------------+---------------+---------+-----------------+------------+---------------------+--------------------+-----------+--------------+--------------+------------------+----------------------+-----------------+--------------------+-------------+-------------------------+-----------------------+----------+---------+---------------------------------------------------------------------------------------------------------------------------------------+----------+--------------+----------------------+------------+-----------------+-----------------+--------------+------------------+-----------------+---------------+----------------+
|            |                   | 21.9656  | 1             |            | 2016-09-25            | SN                      |                 | 2016-09-30        | -0.5971  | 0.7096  |               |                                 |              |                                                                  |                          | http://wis-tns.weizmann.ac.il/object/2016grk                         | 13458566  |                                                                                                                                          | 1387901       | 319.9221  |             |               | Clear-  |                 | 861348238  |                     |                    |           | 2016-09-30   | 0.0043       | 2016-09-30       |                      | 57661.2291      | 1387901            | AT2016grk   |                         |                       |          | 0.3741  |                                                                                                                                       |          | 55126287254  |                      | 18.7000    | POSS            |                 | 0            | 0                | 14112329537188  |               |                |
|            |                   | 21.9656  | 0             |            |                       |                         |                 | 2016-10-01        | -0.5971  | 0.7096  |               |                                 |              | https://c4.staticflickr.com/6/5313/29951445811_cf5c76e8aa_o.jpg  | SN                       | http://www.rochesterastronomy.org/supernova.html#2016grk             | 13458566  |                                                                                                                                          | 1392947       | 319.9221  |             |               |         |                 | 861348238  |                     |                    |           | 2016-10-01   | 0.0043       | 2016-09-30       |                      | 57661.2290      | 1387901            | AT2016grk   |                         |                       |          | 0.3741  |                                                                                                                                       |          | 55126287254  |                      | 18.7000    | bright sn list  |                 | 0            | 0                | 14112329537188  |               |                |
|            |                   | 21.9658  | 0             |            |                       |                         |                 | 2016-10-01        | -0.5971  | 0.7096  |               |                                 |              |                                                                  |                          | http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/  | 13458566  |                                                                                                                                          | 1398488       | 319.9220  |             |               | c       |                 | 861348238  |                     |                    |           | 2016-10-01   | 0.5654       | 2016-09-30       |                      | 57661.3788      | 1387901            | ATLAS16dbz  |                         |                       |          | 0.3741  |                                                                                                                                       |          | 55126287254  |                      | 17.7500    | ATLAS           | 0.0700          | 0            | 0                | 14112329537190  |               |                |
|            |                   | 21.9657  | 0             |            |                       |                         |                 | 2016-10-01        | -0.5971  | 0.7096  |               |                                 |              |                                                                  |                          | http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/  | 13458566  |                                                                                                                                          | 1398490       | 319.9220  |             |               | c       |                 | 861348238  |                     |                    |           | 2016-10-01   | 0.6391       | 2016-09-30       |                      | 57661.4019      | 1387901            | ATLAS16dbz  |                         |                       |          | 0.3741  |                                                                                                                                       |          | 55126287255  |                      | 17.9400    | ATLAS           | 0.0800          | 0            | 0                | 14112329537309  |               |                |
|            |                   | 21.9658  | 0             |            |                       |                         |                 | 2016-10-01        | -0.5971  | 0.7096  |               |                                 |              |                                                                  | orphan                   |                                                                      | 13458566  | http://psweb.mp.qub.ac.uk/sne/atlas3/site_media/images/data/atlas3//57661/1211941281215756900_57661.401_02a57661o0355c_8445_target.jpeg  | 1398485       | 319.9220  |             |               | c       |                 | 861348238  |                     |                    |           | 2016-10-01   | 0.6537       | 2016-09-30       |                      | 57661.3495      | 1387901            | ATLAS16dbz  |                         |                       |          | 0.3741  | http://psweb.mp.qub.ac.uk/sne/atlas3/site_media/images/data/atlas3//57661/1211941281215756900_57661.401_02a57661o0355c_8445_ref.jpeg  |          | 55126287255  |                      | 17.8800    | ATLAS           |                 | 0            | 0                | 14112329537309  |               |                |
|            |                   | 21.9658  | 0             |            |                       |                         |                 | 2016-10-01        | -0.5971  | 0.7096  |               |                                 |              |                                                                  |                          | http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/  | 13458566  |                                                                                                                                          | 1398489       | 319.9220  |             |               | c       |                 | 861348238  |                     |                    |           | 2016-10-01   | 0.6893       | 2016-09-30       |                      | 57661.3588      | 1387901            | ATLAS16dbz  |                         |                       |          | 0.3741  |                                                                                                                                       |          | 55126287254  |                      | 17.8000    | ATLAS           | 0.0700          | 0            | 0                | 14112329537198  |               |                |
|            |                   | 21.9658  | 0             |            |                       |                         |                 | 2016-10-01        | -0.5971  | 0.7096  |               |                                 |              |                                                                  |                          | http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/  | 13458566  |                                                                                                                                          | 1398486       | 319.9220  |             |               | c       |                 | 861348238  |                     |                    |           | 2016-10-01   | 0.7532       | 2016-09-30       |                      | 57661.3679      | 1387901            | ATLAS16dbz  |                         |                       |          | 0.3741  |                                                                                                                                       |          | 55126287254  |                      | 17.8600    | ATLAS           | 0.0700          | 0            | 0                | 14112329537185  |               |                |
|            |                   | 21.9657  | 0             |            |                       |                         |                 | 2016-10-01        | -0.5971  | 0.7096  |               |                                 |              |                                                                  |                          | http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/  | 13458566  |                                                                                                                                          | 1398487       | 319.9219  |             |               | c       |                 | 861348238  |                     |                    |           | 2016-10-01   | 0.8138       | 2016-09-30       |                      | 57661.3494      | 1387901            | ATLAS16dbz  |                         |                       |          | 0.3741  |                                                                                                                                       |          | 55126287255  |                      | 17.8800    | ATLAS           | 0.0700          | 0            | 0                | 14112329537311  |               |                |
+------------+-------------------+----------+---------------+------------+-----------------------+-------------------------+-----------------+-------------------+----------+---------+---------------+---------------------------------+--------------+------------------------------------------------------------------+--------------------------+----------------------------------------------------------------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------+---------------+-----------+-------------+---------------+---------+-----------------+------------+---------------------+--------------------+-----------+--------------+--------------+------------------+----------------------+-----------------+--------------------+-------------+-------------------------+-----------------------+----------+---------+---------------------------------------------------------------------------------------------------------------------------------------+----------+--------------+----------------------+------------+-----------------+-----------------+--------------+------------------+-----------------+---------------+----------------+

Note RA and DEC can be in either sexegesiaml or decimal degree formats.

Again, you can instead pass in the database credientials via the command-line instead of a settings file:

hmpty search transientBucket raDeg decDeg 319.92212 21.96564 10. --host localhost --user myusername --passwd mypass --dbName mydatabase 

Renders

To render the results of the conesearch as json, csv, yaml or markdown use the -r <format> flag. For example:

hmpty search transientBucket raDeg decDeg 21:19:41.31 +21:57:56.3 10. -s /path/to/my-settings.yaml -r json
[
    {
        "classificationPhase": null,
        "classificationWRTMax": null,
        "cmSepArcsec": 0.0043467057710126393,
        "cx": 0.709625112642,
        "cy": -0.597091649225,
        "cz": 0.374050480461,
        "dateCreated": "20160930t192332",
        "dateDeleted": null,
        "dateLastModified": "20160930t192332",
        "dateLastRead": null,
        "decDeg": 21.9656388889,
        "decDegErr": null,
        "discoveryPhase": null,
        "filter": "Clear-",
        "finderImageUrl": null,
        "hostRedshift": null, 
        ....

It’s possible to also render the results as MySQL insert statements, but the name of the table to insert the result into is also needed.

hmpty search transientBucket raDeg decDeg 21:19:41.31 +21:57:56.3 10. -s /path/to/my-settings.yaml -r mysql my_results
INSERT INTO `my_results` (classificationPhase,classificationWRTMax,cmSepArcsec,cx,cy,cz,dateCreated,dateDeleted,dateLastModified,dateLastRead,decDeg,decDegErr,discoveryPhase,filter,finderImageUrl,hostRedshift,hostRedshiftType,htm10ID,htm13ID,htm16ID,htm20ID,instrument,lastNonDetectionDate,lastNonDetectionMJD,lightcurveURL,limitingMag,magnitude,magnitudeError,masterIDFlag,name,observationDate,observationMJD,primaryKeyId,raDeg,raDegErr,reducer,referenceImageUrl,replacedByRowId,sherlockClassification,spectralType,subtractedImageUrl,survey,surveyObjectUrl,targetImageUrl,telescope,tmpFlag,transientBucketId,transientRedshift,transientRedshiftNotes,transientTypePredicationSource,transientTypePrediction,tripletImageUrl) VALUES (null ,null ,"0.00434670577101" ,"0.709625112642" ,"-0.597091649225" ,"0.374050480461" ,"2016-09-30 19:23:32" ,null ,"2016-09-30 19:23:32" ,null ,"21.9656388889" ,null ,null ,"Clear-" ,null ,null ,null ,"13458566" ,"861348238" ,"55126287254" ,"14112329537188" ,null ,"2016-09-25 05:16:07" ,null ,null ,"0" ,"18.7" ,null ,"1" ,"AT2016grk" ,"2016-09-30 05:29:57" ,"57661.2291319" ,"1387901" ,"319.922125" ,null ,null ,null ,"0" ,"SN" ,null ,null ,"POSS" ,"http://wis-tns.weizmann.ac.il/object/2016grk" ,null ,null ,null ,"1387901" ,null ,null ,null ,null ,null)  ON DUPLICATE KEY UPDATE  classificationPhase=null, classificationWRTMax=null, cmSepArcsec="0.00434670577101", cx="0.709625112642", cy="-0.597091649225", cz="0.374050480461", dateCreated="2016-09-30 19:23:32", dateDeleted=null, dateLastModified="2016-09-30 19:23:32", dateLastRead=null, decDeg="21.9656388889", decDegErr=null, discoveryPhase=null, filter="Clear-", finderImageUrl=null, hostRedshift=null, hostRedshiftType=null, htm10ID="13458566", htm13ID="861348238", htm16ID="55126287254", htm20ID="14112329537188", instrument=null, lastNonDetectionDate="2016-09-25 05:16:07", lastNonDetectionMJD=null, lightcurveURL=null, limitingMag="0", magnitude="18.7", magnitudeError=null, masterIDFlag="1", name="AT2016grk", observationDate="2016-09-30 05:29:57", observationMJD="57661.2291319", primaryKeyId="1387901", raDeg="319.922125", raDegErr=null, reducer=null, referenceImageUrl=null, replacedByRowId="0", sherlockClassification="SN", spectralType=null, subtractedImageUrl=null, survey="POSS", surveyObjectUrl="http://wis-tns.weizmann.ac.il/object/2016grk", targetImageUrl=null, telescope=null, tmpFlag=null, transientBucketId="1387901", transientRedshift=null, transientRedshiftNotes=null, transientTypePredicationSource=null, transientTypePrediction=null, tripletImageUrl=null, updated=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.00434670577101" AND  cx="0.709625112642" AND  cy="-0.597091649225" AND  cz="0.374050480461" AND  dateCreated="2016-09-30 19:23:32" AND  dateDeleted is null AND  dateLastModified="2016-09-30 19:23:32" AND  dateLastRead is null AND  decDeg="21.9656388889" AND  decDegErr is null AND  discoveryPhase is null AND  filter="Clear-" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287254" AND  htm20ID="14112329537188" AND  instrument is null AND  lastNonDetectionDate="2016-09-25 05:16:07" AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="18.7" AND  magnitudeError is null AND  masterIDFlag="1" AND  name="AT2016grk" AND  observationDate="2016-09-30 05:29:57" AND  observationMJD="57661.2291319" AND  primaryKeyId="1387901" AND  raDeg="319.922125" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification="SN" AND  spectralType is null AND  subtractedImageUrl is null AND  survey="POSS" AND  surveyObjectUrl="http://wis-tns.weizmann.ac.il/object/2016grk" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, 0, 1), dateLastModified=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.00434670577101" AND  cx="0.709625112642" AND  cy="-0.597091649225" AND  cz="0.374050480461" AND  dateCreated="2016-09-30 19:23:32" AND  dateDeleted is null AND  dateLastModified="2016-09-30 19:23:32" AND  dateLastRead is null AND  decDeg="21.9656388889" AND  decDegErr is null AND  discoveryPhase is null AND  filter="Clear-" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287254" AND  htm20ID="14112329537188" AND  instrument is null AND  lastNonDetectionDate="2016-09-25 05:16:07" AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="18.7" AND  magnitudeError is null AND  masterIDFlag="1" AND  name="AT2016grk" AND  observationDate="2016-09-30 05:29:57" AND  observationMJD="57661.2291319" AND  primaryKeyId="1387901" AND  raDeg="319.922125" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification="SN" AND  spectralType is null AND  subtractedImageUrl is null AND  survey="POSS" AND  surveyObjectUrl="http://wis-tns.weizmann.ac.il/object/2016grk" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, dateLastModified, NOW()) ;
INSERT INTO `my_results` (classificationPhase,classificationWRTMax,cmSepArcsec,cx,cy,cz,dateCreated,dateDeleted,dateLastModified,dateLastRead,decDeg,decDegErr,discoveryPhase,filter,finderImageUrl,hostRedshift,hostRedshiftType,htm10ID,htm13ID,htm16ID,htm20ID,instrument,lastNonDetectionDate,lastNonDetectionMJD,lightcurveURL,limitingMag,magnitude,magnitudeError,masterIDFlag,name,observationDate,observationMJD,primaryKeyId,raDeg,raDegErr,reducer,referenceImageUrl,replacedByRowId,sherlockClassification,spectralType,subtractedImageUrl,survey,surveyObjectUrl,targetImageUrl,telescope,tmpFlag,transientBucketId,transientRedshift,transientRedshiftNotes,transientTypePredicationSource,transientTypePrediction,tripletImageUrl) VALUES (null ,null ,"0.00434670577101" ,"0.709625112642" ,"-0.597091649225" ,"0.374050480461" ,"2016-10-01 06:25:16" ,null ,"2016-10-01 06:25:16" ,null ,"21.9656388889" ,null ,null ,null ,null ,null ,null ,"13458566" ,"861348238" ,"55126287254" ,"14112329537188" ,null ,null ,null ,null ,"0" ,"18.7" ,null ,"0" ,"AT2016grk" ,"2016-09-30 05:29:45" ,"57661.2289931" ,"1392947" ,"319.922125" ,null ,null ,null ,"0" ,null ,null ,null ,"bright sn list" ,"http://www.rochesterastronomy.org/supernova.html#2016grk" ,null ,null ,null ,"1387901" ,null ,null ,null ,"SN" ,"https://c4.staticflickr.com/6/5313/29951445811_cf5c76e8aa_o.jpg")  ON DUPLICATE KEY UPDATE  classificationPhase=null, classificationWRTMax=null, cmSepArcsec="0.00434670577101", cx="0.709625112642", cy="-0.597091649225", cz="0.374050480461", dateCreated="2016-10-01 06:25:16", dateDeleted=null, dateLastModified="2016-10-01 06:25:16", dateLastRead=null, decDeg="21.9656388889", decDegErr=null, discoveryPhase=null, filter=null, finderImageUrl=null, hostRedshift=null, hostRedshiftType=null, htm10ID="13458566", htm13ID="861348238", htm16ID="55126287254", htm20ID="14112329537188", instrument=null, lastNonDetectionDate=null, lastNonDetectionMJD=null, lightcurveURL=null, limitingMag="0", magnitude="18.7", magnitudeError=null, masterIDFlag="0", name="AT2016grk", observationDate="2016-09-30 05:29:45", observationMJD="57661.2289931", primaryKeyId="1392947", raDeg="319.922125", raDegErr=null, reducer=null, referenceImageUrl=null, replacedByRowId="0", sherlockClassification=null, spectralType=null, subtractedImageUrl=null, survey="bright sn list", surveyObjectUrl="http://www.rochesterastronomy.org/supernova.html#2016grk", targetImageUrl=null, telescope=null, tmpFlag=null, transientBucketId="1387901", transientRedshift=null, transientRedshiftNotes=null, transientTypePredicationSource=null, transientTypePrediction="SN", tripletImageUrl="https://c4.staticflickr.com/6/5313/29951445811_cf5c76e8aa_o.jpg", updated=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.00434670577101" AND  cx="0.709625112642" AND  cy="-0.597091649225" AND  cz="0.374050480461" AND  dateCreated="2016-10-01 06:25:16" AND  dateDeleted is null AND  dateLastModified="2016-10-01 06:25:16" AND  dateLastRead is null AND  decDeg="21.9656388889" AND  decDegErr is null AND  discoveryPhase is null AND  filter is null AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287254" AND  htm20ID="14112329537188" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="18.7" AND  magnitudeError is null AND  masterIDFlag="0" AND  name="AT2016grk" AND  observationDate="2016-09-30 05:29:45" AND  observationMJD="57661.2289931" AND  primaryKeyId="1392947" AND  raDeg="319.922125" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="bright sn list" AND  surveyObjectUrl="http://www.rochesterastronomy.org/supernova.html#2016grk" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction="SN" AND  tripletImageUrl="https://c4.staticflickr.com/6/5313/29951445811_cf5c76e8aa_o.jpg", 0, 1), dateLastModified=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.00434670577101" AND  cx="0.709625112642" AND  cy="-0.597091649225" AND  cz="0.374050480461" AND  dateCreated="2016-10-01 06:25:16" AND  dateDeleted is null AND  dateLastModified="2016-10-01 06:25:16" AND  dateLastRead is null AND  decDeg="21.9656388889" AND  decDegErr is null AND  discoveryPhase is null AND  filter is null AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287254" AND  htm20ID="14112329537188" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="18.7" AND  magnitudeError is null AND  masterIDFlag="0" AND  name="AT2016grk" AND  observationDate="2016-09-30 05:29:45" AND  observationMJD="57661.2289931" AND  primaryKeyId="1392947" AND  raDeg="319.922125" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="bright sn list" AND  surveyObjectUrl="http://www.rochesterastronomy.org/supernova.html#2016grk" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction="SN" AND  tripletImageUrl="https://c4.staticflickr.com/6/5313/29951445811_cf5c76e8aa_o.jpg", dateLastModified, NOW()) ;
INSERT INTO `my_results` (classificationPhase,classificationWRTMax,cmSepArcsec,cx,cy,cz,dateCreated,dateDeleted,dateLastModified,dateLastRead,decDeg,decDegErr,discoveryPhase,filter,finderImageUrl,hostRedshift,hostRedshiftType,htm10ID,htm13ID,htm16ID,htm20ID,instrument,lastNonDetectionDate,lastNonDetectionMJD,lightcurveURL,limitingMag,magnitude,magnitudeError,masterIDFlag,name,observationDate,observationMJD,primaryKeyId,raDeg,raDegErr,reducer,referenceImageUrl,replacedByRowId,sherlockClassification,spectralType,subtractedImageUrl,survey,surveyObjectUrl,targetImageUrl,telescope,tmpFlag,transientBucketId,transientRedshift,transientRedshiftNotes,transientTypePredicationSource,transientTypePrediction,tripletImageUrl) VALUES (null ,null ,"0.56535588648" ,"0.70962346768" ,"-0.597092274742" ,"0.374052602667" ,"2016-10-01 19:12:26" ,null ,"2016-10-01 19:12:26" ,null ,"21.96577" ,null ,null ,"c" ,null ,null ,null ,"13458566" ,"861348238" ,"55126287254" ,"14112329537190" ,null ,null ,null ,null ,"0" ,"17.75" ,"0.07" ,"0" ,"ATLAS16dbz" ,"2016-09-30 09:05:29" ,"57661.3788134" ,"1398488" ,"319.92203" ,null ,null ,null ,"0" ,null ,null ,null ,"ATLAS" ,"http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" ,null ,null ,null ,"1387901" ,null ,null ,null ,null ,null)  ON DUPLICATE KEY UPDATE  classificationPhase=null, classificationWRTMax=null, cmSepArcsec="0.56535588648", cx="0.70962346768", cy="-0.597092274742", cz="0.374052602667", dateCreated="2016-10-01 19:12:26", dateDeleted=null, dateLastModified="2016-10-01 19:12:26", dateLastRead=null, decDeg="21.96577", decDegErr=null, discoveryPhase=null, filter="c", finderImageUrl=null, hostRedshift=null, hostRedshiftType=null, htm10ID="13458566", htm13ID="861348238", htm16ID="55126287254", htm20ID="14112329537190", instrument=null, lastNonDetectionDate=null, lastNonDetectionMJD=null, lightcurveURL=null, limitingMag="0", magnitude="17.75", magnitudeError="0.07", masterIDFlag="0", name="ATLAS16dbz", observationDate="2016-09-30 09:05:29", observationMJD="57661.3788134", primaryKeyId="1398488", raDeg="319.92203", raDegErr=null, reducer=null, referenceImageUrl=null, replacedByRowId="0", sherlockClassification=null, spectralType=null, subtractedImageUrl=null, survey="ATLAS", surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/", targetImageUrl=null, telescope=null, tmpFlag=null, transientBucketId="1387901", transientRedshift=null, transientRedshiftNotes=null, transientTypePredicationSource=null, transientTypePrediction=null, tripletImageUrl=null, updated=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.56535588648" AND  cx="0.70962346768" AND  cy="-0.597092274742" AND  cz="0.374052602667" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.96577" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287254" AND  htm20ID="14112329537190" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.75" AND  magnitudeError="0.07" AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 09:05:29" AND  observationMJD="57661.3788134" AND  primaryKeyId="1398488" AND  raDeg="319.92203" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, 0, 1), dateLastModified=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.56535588648" AND  cx="0.70962346768" AND  cy="-0.597092274742" AND  cz="0.374052602667" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.96577" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287254" AND  htm20ID="14112329537190" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.75" AND  magnitudeError="0.07" AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 09:05:29" AND  observationMJD="57661.3788134" AND  primaryKeyId="1398488" AND  raDeg="319.92203" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, dateLastModified, NOW()) ;
INSERT INTO `my_results` (classificationPhase,classificationWRTMax,cmSepArcsec,cx,cy,cz,dateCreated,dateDeleted,dateLastModified,dateLastRead,decDeg,decDegErr,discoveryPhase,filter,finderImageUrl,hostRedshift,hostRedshiftType,htm10ID,htm13ID,htm16ID,htm20ID,instrument,lastNonDetectionDate,lastNonDetectionMJD,lightcurveURL,limitingMag,magnitude,magnitudeError,masterIDFlag,name,observationDate,observationMJD,primaryKeyId,raDeg,raDegErr,reducer,referenceImageUrl,replacedByRowId,sherlockClassification,spectralType,subtractedImageUrl,survey,surveyObjectUrl,targetImageUrl,telescope,tmpFlag,transientBucketId,transientRedshift,transientRedshiftNotes,transientTypePredicationSource,transientTypePrediction,tripletImageUrl) VALUES (null ,null ,"0.639098796909" ,"0.709622938008" ,"-0.597093309838" ,"0.374051955215" ,"2016-10-01 19:12:26" ,null ,"2016-10-01 19:12:26" ,null ,"21.96573" ,null ,null ,"c" ,null ,null ,null ,"13458566" ,"861348238" ,"55126287255" ,"14112329537309" ,null ,null ,null ,null ,"0" ,"17.94" ,"0.08" ,"0" ,"ATLAS16dbz" ,"2016-09-30 09:38:41" ,"57661.4018678" ,"1398490" ,"319.92196" ,null ,null ,null ,"0" ,null ,null ,null ,"ATLAS" ,"http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" ,null ,null ,null ,"1387901" ,null ,null ,null ,null ,null)  ON DUPLICATE KEY UPDATE  classificationPhase=null, classificationWRTMax=null, cmSepArcsec="0.639098796909", cx="0.709622938008", cy="-0.597093309838", cz="0.374051955215", dateCreated="2016-10-01 19:12:26", dateDeleted=null, dateLastModified="2016-10-01 19:12:26", dateLastRead=null, decDeg="21.96573", decDegErr=null, discoveryPhase=null, filter="c", finderImageUrl=null, hostRedshift=null, hostRedshiftType=null, htm10ID="13458566", htm13ID="861348238", htm16ID="55126287255", htm20ID="14112329537309", instrument=null, lastNonDetectionDate=null, lastNonDetectionMJD=null, lightcurveURL=null, limitingMag="0", magnitude="17.94", magnitudeError="0.08", masterIDFlag="0", name="ATLAS16dbz", observationDate="2016-09-30 09:38:41", observationMJD="57661.4018678", primaryKeyId="1398490", raDeg="319.92196", raDegErr=null, reducer=null, referenceImageUrl=null, replacedByRowId="0", sherlockClassification=null, spectralType=null, subtractedImageUrl=null, survey="ATLAS", surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/", targetImageUrl=null, telescope=null, tmpFlag=null, transientBucketId="1387901", transientRedshift=null, transientRedshiftNotes=null, transientTypePredicationSource=null, transientTypePrediction=null, tripletImageUrl=null, updated=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.639098796909" AND  cx="0.709622938008" AND  cy="-0.597093309838" AND  cz="0.374051955215" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.96573" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287255" AND  htm20ID="14112329537309" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.94" AND  magnitudeError="0.08" AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 09:38:41" AND  observationMJD="57661.4018678" AND  primaryKeyId="1398490" AND  raDeg="319.92196" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, 0, 1), dateLastModified=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.639098796909" AND  cx="0.709622938008" AND  cy="-0.597093309838" AND  cz="0.374051955215" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.96573" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287255" AND  htm20ID="14112329537309" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.94" AND  magnitudeError="0.08" AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 09:38:41" AND  observationMJD="57661.4018678" AND  primaryKeyId="1398490" AND  raDeg="319.92196" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, dateLastModified, NOW()) ;
INSERT INTO `my_results` (classificationPhase,classificationWRTMax,cmSepArcsec,cx,cy,cz,dateCreated,dateDeleted,dateLastModified,dateLastRead,decDeg,decDegErr,discoveryPhase,filter,finderImageUrl,hostRedshift,hostRedshiftType,htm10ID,htm13ID,htm16ID,htm20ID,instrument,lastNonDetectionDate,lastNonDetectionMJD,lightcurveURL,limitingMag,magnitude,magnitudeError,masterIDFlag,name,observationDate,observationMJD,primaryKeyId,raDeg,raDegErr,reducer,referenceImageUrl,replacedByRowId,sherlockClassification,spectralType,subtractedImageUrl,survey,surveyObjectUrl,targetImageUrl,telescope,tmpFlag,transientBucketId,transientRedshift,transientRedshiftNotes,transientTypePredicationSource,transientTypePrediction,tripletImageUrl) VALUES (null ,null ,"0.653735010571" ,"0.709623008285" ,"-0.597092861276" ,"0.374052537922" ,"2016-10-01 19:12:26" ,null ,"2016-10-01 19:12:26" ,null ,"21.965766" ,null ,null ,"c" ,null ,null ,null ,"13458566" ,"861348238" ,"55126287255" ,"14112329537309" ,null ,null ,null ,null ,"0" ,"17.88" ,null ,"0" ,"ATLAS16dbz" ,"2016-09-30 08:23:12" ,"57661.34945" ,"1398485" ,"319.921984" ,null ,null ,"http://psweb.mp.qub.ac.uk/sne/atlas3/site_media/images/data/atlas3//57661/1211941281215756900_57661.401_02a57661o0355c_8445_ref.jpeg" ,"0" ,null ,null ,null ,"ATLAS" ,null ,"http://psweb.mp.qub.ac.uk/sne/atlas3/site_media/images/data/atlas3//57661/1211941281215756900_57661.401_02a57661o0355c_8445_target.jpeg" ,null ,null ,"1387901" ,null ,null ,null ,"orphan" ,null)  ON DUPLICATE KEY UPDATE  classificationPhase=null, classificationWRTMax=null, cmSepArcsec="0.653735010571", cx="0.709623008285", cy="-0.597092861276", cz="0.374052537922", dateCreated="2016-10-01 19:12:26", dateDeleted=null, dateLastModified="2016-10-01 19:12:26", dateLastRead=null, decDeg="21.965766", decDegErr=null, discoveryPhase=null, filter="c", finderImageUrl=null, hostRedshift=null, hostRedshiftType=null, htm10ID="13458566", htm13ID="861348238", htm16ID="55126287255", htm20ID="14112329537309", instrument=null, lastNonDetectionDate=null, lastNonDetectionMJD=null, lightcurveURL=null, limitingMag="0", magnitude="17.88", magnitudeError=null, masterIDFlag="0", name="ATLAS16dbz", observationDate="2016-09-30 08:23:12", observationMJD="57661.34945", primaryKeyId="1398485", raDeg="319.921984", raDegErr=null, reducer=null, referenceImageUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/site_media/images/data/atlas3//57661/1211941281215756900_57661.401_02a57661o0355c_8445_ref.jpeg", replacedByRowId="0", sherlockClassification=null, spectralType=null, subtractedImageUrl=null, survey="ATLAS", surveyObjectUrl=null, targetImageUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/site_media/images/data/atlas3//57661/1211941281215756900_57661.401_02a57661o0355c_8445_target.jpeg", telescope=null, tmpFlag=null, transientBucketId="1387901", transientRedshift=null, transientRedshiftNotes=null, transientTypePredicationSource=null, transientTypePrediction="orphan", tripletImageUrl=null, updated=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.653735010571" AND  cx="0.709623008285" AND  cy="-0.597092861276" AND  cz="0.374052537922" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.965766" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287255" AND  htm20ID="14112329537309" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.88" AND  magnitudeError is null AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 08:23:12" AND  observationMJD="57661.34945" AND  primaryKeyId="1398485" AND  raDeg="319.921984" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/site_media/images/data/atlas3//57661/1211941281215756900_57661.401_02a57661o0355c_8445_ref.jpeg" AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl is null AND  targetImageUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/site_media/images/data/atlas3//57661/1211941281215756900_57661.401_02a57661o0355c_8445_target.jpeg" AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction="orphan" AND  tripletImageUrl=null, 0, 1), dateLastModified=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.653735010571" AND  cx="0.709623008285" AND  cy="-0.597092861276" AND  cz="0.374052537922" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.965766" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287255" AND  htm20ID="14112329537309" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.88" AND  magnitudeError is null AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 08:23:12" AND  observationMJD="57661.34945" AND  primaryKeyId="1398485" AND  raDeg="319.921984" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/site_media/images/data/atlas3//57661/1211941281215756900_57661.401_02a57661o0355c_8445_ref.jpeg" AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl is null AND  targetImageUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/site_media/images/data/atlas3//57661/1211941281215756900_57661.401_02a57661o0355c_8445_target.jpeg" AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction="orphan" AND  tripletImageUrl=null, dateLastModified, NOW()) ;
INSERT INTO `my_results` (classificationPhase,classificationWRTMax,cmSepArcsec,cx,cy,cz,dateCreated,dateDeleted,dateLastModified,dateLastRead,decDeg,decDegErr,discoveryPhase,filter,finderImageUrl,hostRedshift,hostRedshiftType,htm10ID,htm13ID,htm16ID,htm20ID,instrument,lastNonDetectionDate,lastNonDetectionMJD,lightcurveURL,limitingMag,magnitude,magnitudeError,masterIDFlag,name,observationDate,observationMJD,primaryKeyId,raDeg,raDegErr,reducer,referenceImageUrl,replacedByRowId,sherlockClassification,spectralType,subtractedImageUrl,survey,surveyObjectUrl,targetImageUrl,telescope,tmpFlag,transientBucketId,transientRedshift,transientRedshiftNotes,transientTypePredicationSource,transientTypePrediction,tripletImageUrl) VALUES (null ,null ,"0.689312710877" ,"0.709623267865" ,"-0.597092106613" ,"0.37405325012" ,"2016-10-01 19:12:26" ,null ,"2016-10-01 19:12:26" ,null ,"21.96581" ,null ,null ,"c" ,null ,null ,null ,"13458566" ,"861348238" ,"55126287254" ,"14112329537198" ,null ,null ,null ,null ,"0" ,"17.8" ,"0.07" ,"0" ,"ATLAS16dbz" ,"2016-09-30 08:36:38" ,"57661.3587675" ,"1398489" ,"319.92203" ,null ,null ,null ,"0" ,null ,null ,null ,"ATLAS" ,"http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" ,null ,null ,null ,"1387901" ,null ,null ,null ,null ,null)  ON DUPLICATE KEY UPDATE  classificationPhase=null, classificationWRTMax=null, cmSepArcsec="0.689312710877", cx="0.709623267865", cy="-0.597092106613", cz="0.37405325012", dateCreated="2016-10-01 19:12:26", dateDeleted=null, dateLastModified="2016-10-01 19:12:26", dateLastRead=null, decDeg="21.96581", decDegErr=null, discoveryPhase=null, filter="c", finderImageUrl=null, hostRedshift=null, hostRedshiftType=null, htm10ID="13458566", htm13ID="861348238", htm16ID="55126287254", htm20ID="14112329537198", instrument=null, lastNonDetectionDate=null, lastNonDetectionMJD=null, lightcurveURL=null, limitingMag="0", magnitude="17.8", magnitudeError="0.07", masterIDFlag="0", name="ATLAS16dbz", observationDate="2016-09-30 08:36:38", observationMJD="57661.3587675", primaryKeyId="1398489", raDeg="319.92203", raDegErr=null, reducer=null, referenceImageUrl=null, replacedByRowId="0", sherlockClassification=null, spectralType=null, subtractedImageUrl=null, survey="ATLAS", surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/", targetImageUrl=null, telescope=null, tmpFlag=null, transientBucketId="1387901", transientRedshift=null, transientRedshiftNotes=null, transientTypePredicationSource=null, transientTypePrediction=null, tripletImageUrl=null, updated=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.689312710877" AND  cx="0.709623267865" AND  cy="-0.597092106613" AND  cz="0.37405325012" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.96581" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287254" AND  htm20ID="14112329537198" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.8" AND  magnitudeError="0.07" AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 08:36:38" AND  observationMJD="57661.3587675" AND  primaryKeyId="1398489" AND  raDeg="319.92203" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, 0, 1), dateLastModified=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.689312710877" AND  cx="0.709623267865" AND  cy="-0.597092106613" AND  cz="0.37405325012" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.96581" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287254" AND  htm20ID="14112329537198" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.8" AND  magnitudeError="0.07" AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 08:36:38" AND  observationMJD="57661.3587675" AND  primaryKeyId="1398489" AND  raDeg="319.92203" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, dateLastModified, NOW()) ;
INSERT INTO `my_results` (classificationPhase,classificationWRTMax,cmSepArcsec,cx,cy,cz,dateCreated,dateDeleted,dateLastModified,dateLastRead,decDeg,decDegErr,discoveryPhase,filter,finderImageUrl,hostRedshift,hostRedshiftType,htm10ID,htm13ID,htm16ID,htm20ID,instrument,lastNonDetectionDate,lastNonDetectionMJD,lightcurveURL,limitingMag,magnitude,magnitudeError,masterIDFlag,name,observationDate,observationMJD,primaryKeyId,raDeg,raDegErr,reducer,referenceImageUrl,replacedByRowId,sherlockClassification,spectralType,subtractedImageUrl,survey,surveyObjectUrl,targetImageUrl,telescope,tmpFlag,transientBucketId,transientRedshift,transientRedshiftNotes,transientTypePredicationSource,transientTypePrediction,tripletImageUrl) VALUES (null ,null ,"0.753210240087" ,"0.709623009487" ,"-0.597092312286" ,"0.374053411983" ,"2016-10-01 19:12:26" ,null ,"2016-10-01 19:12:26" ,null ,"21.96582" ,null ,null ,"c" ,null ,null ,null ,"13458566" ,"861348238" ,"55126287254" ,"14112329537185" ,null ,null ,null ,null ,"0" ,"17.86" ,"0.07" ,"0" ,"ATLAS16dbz" ,"2016-09-30 08:49:45" ,"57661.3678845" ,"1398486" ,"319.92201" ,null ,null ,null ,"0" ,null ,null ,null ,"ATLAS" ,"http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" ,null ,null ,null ,"1387901" ,null ,null ,null ,null ,null)  ON DUPLICATE KEY UPDATE  classificationPhase=null, classificationWRTMax=null, cmSepArcsec="0.753210240087", cx="0.709623009487", cy="-0.597092312286", cz="0.374053411983", dateCreated="2016-10-01 19:12:26", dateDeleted=null, dateLastModified="2016-10-01 19:12:26", dateLastRead=null, decDeg="21.96582", decDegErr=null, discoveryPhase=null, filter="c", finderImageUrl=null, hostRedshift=null, hostRedshiftType=null, htm10ID="13458566", htm13ID="861348238", htm16ID="55126287254", htm20ID="14112329537185", instrument=null, lastNonDetectionDate=null, lastNonDetectionMJD=null, lightcurveURL=null, limitingMag="0", magnitude="17.86", magnitudeError="0.07", masterIDFlag="0", name="ATLAS16dbz", observationDate="2016-09-30 08:49:45", observationMJD="57661.3678845", primaryKeyId="1398486", raDeg="319.92201", raDegErr=null, reducer=null, referenceImageUrl=null, replacedByRowId="0", sherlockClassification=null, spectralType=null, subtractedImageUrl=null, survey="ATLAS", surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/", targetImageUrl=null, telescope=null, tmpFlag=null, transientBucketId="1387901", transientRedshift=null, transientRedshiftNotes=null, transientTypePredicationSource=null, transientTypePrediction=null, tripletImageUrl=null, updated=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.753210240087" AND  cx="0.709623009487" AND  cy="-0.597092312286" AND  cz="0.374053411983" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.96582" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287254" AND  htm20ID="14112329537185" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.86" AND  magnitudeError="0.07" AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 08:49:45" AND  observationMJD="57661.3678845" AND  primaryKeyId="1398486" AND  raDeg="319.92201" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, 0, 1), dateLastModified=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.753210240087" AND  cx="0.709623009487" AND  cy="-0.597092312286" AND  cz="0.374053411983" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.96582" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287254" AND  htm20ID="14112329537185" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.86" AND  magnitudeError="0.07" AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 08:49:45" AND  observationMJD="57661.3678845" AND  primaryKeyId="1398486" AND  raDeg="319.92201" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, dateLastModified, NOW()) ;
INSERT INTO `my_results` (classificationPhase,classificationWRTMax,cmSepArcsec,cx,cy,cz,dateCreated,dateDeleted,dateLastModified,dateLastRead,decDeg,decDegErr,discoveryPhase,filter,finderImageUrl,hostRedshift,hostRedshiftType,htm10ID,htm13ID,htm16ID,htm20ID,instrument,lastNonDetectionDate,lastNonDetectionMJD,lightcurveURL,limitingMag,magnitude,magnitudeError,masterIDFlag,name,observationDate,observationMJD,primaryKeyId,raDeg,raDegErr,reducer,referenceImageUrl,replacedByRowId,sherlockClassification,spectralType,subtractedImageUrl,survey,surveyObjectUrl,targetImageUrl,telescope,tmpFlag,transientBucketId,transientRedshift,transientRedshiftNotes,transientTypePredicationSource,transientTypePrediction,tripletImageUrl) VALUES (null ,null ,"0.813780637869" ,"0.70962235838" ,"-0.597094302902" ,"0.374051469625" ,"2016-10-01 19:12:26" ,null ,"2016-10-01 19:12:26" ,null ,"21.9657" ,null ,null ,"c" ,null ,null ,null ,"13458566" ,"861348238" ,"55126287255" ,"14112329537311" ,null ,null ,null ,null ,"0" ,"17.88" ,"0.07" ,"0" ,"ATLAS16dbz" ,"2016-09-30 08:23:12" ,"57661.3494495" ,"1398487" ,"319.92189" ,null ,null ,null ,"0" ,null ,null ,null ,"ATLAS" ,"http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" ,null ,null ,null ,"1387901" ,null ,null ,null ,null ,null)  ON DUPLICATE KEY UPDATE  classificationPhase=null, classificationWRTMax=null, cmSepArcsec="0.813780637869", cx="0.70962235838", cy="-0.597094302902", cz="0.374051469625", dateCreated="2016-10-01 19:12:26", dateDeleted=null, dateLastModified="2016-10-01 19:12:26", dateLastRead=null, decDeg="21.9657", decDegErr=null, discoveryPhase=null, filter="c", finderImageUrl=null, hostRedshift=null, hostRedshiftType=null, htm10ID="13458566", htm13ID="861348238", htm16ID="55126287255", htm20ID="14112329537311", instrument=null, lastNonDetectionDate=null, lastNonDetectionMJD=null, lightcurveURL=null, limitingMag="0", magnitude="17.88", magnitudeError="0.07", masterIDFlag="0", name="ATLAS16dbz", observationDate="2016-09-30 08:23:12", observationMJD="57661.3494495", primaryKeyId="1398487", raDeg="319.92189", raDegErr=null, reducer=null, referenceImageUrl=null, replacedByRowId="0", sherlockClassification=null, spectralType=null, subtractedImageUrl=null, survey="ATLAS", surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/", targetImageUrl=null, telescope=null, tmpFlag=null, transientBucketId="1387901", transientRedshift=null, transientRedshiftNotes=null, transientTypePredicationSource=null, transientTypePrediction=null, tripletImageUrl=null, updated=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.813780637869" AND  cx="0.70962235838" AND  cy="-0.597094302902" AND  cz="0.374051469625" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.9657" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287255" AND  htm20ID="14112329537311" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.88" AND  magnitudeError="0.07" AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 08:23:12" AND  observationMJD="57661.3494495" AND  primaryKeyId="1398487" AND  raDeg="319.92189" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, 0, 1), dateLastModified=IF( classificationPhase=null AND  classificationWRTMax is null AND  cmSepArcsec="0.813780637869" AND  cx="0.70962235838" AND  cy="-0.597094302902" AND  cz="0.374051469625" AND  dateCreated="2016-10-01 19:12:26" AND  dateDeleted is null AND  dateLastModified="2016-10-01 19:12:26" AND  dateLastRead is null AND  decDeg="21.9657" AND  decDegErr is null AND  discoveryPhase is null AND  filter="c" AND  finderImageUrl is null AND  hostRedshift is null AND  hostRedshiftType is null AND  htm10ID="13458566" AND  htm13ID="861348238" AND  htm16ID="55126287255" AND  htm20ID="14112329537311" AND  instrument is null AND  lastNonDetectionDate is null AND  lastNonDetectionMJD is null AND  lightcurveURL is null AND  limitingMag="0" AND  magnitude="17.88" AND  magnitudeError="0.07" AND  masterIDFlag="0" AND  name="ATLAS16dbz" AND  observationDate="2016-09-30 08:23:12" AND  observationMJD="57661.3494495" AND  primaryKeyId="1398487" AND  raDeg="319.92189" AND  raDegErr is null AND  reducer is null AND  referenceImageUrl is null AND  replacedByRowId="0" AND  sherlockClassification is null AND  spectralType is null AND  subtractedImageUrl is null AND  survey="ATLAS" AND  surveyObjectUrl="http://psweb.mp.qub.ac.uk/sne/atlas3/candidate/1211941281215756900/" AND  targetImageUrl is null AND  telescope is null AND  tmpFlag is null AND  transientBucketId="1387901" AND  transientRedshift is null AND  transientRedshiftNotes is null AND  transientTypePredicationSource is null AND  transientTypePrediction is null AND  tripletImageUrl=null, dateLastModified, NOW()) ;