HMpTy

Documentation Status Coverage Status

A python package and command-line tools for working with Hierarchical Triangular Meshes (HTMs). Generate HTM-ids, crossmatch sets of sky-coordinates and more.

http://i.imgur.com/5GG4979.png

Here’s a summary of what’s included in the python package:

Classes

HMpTy.htm.sets Given a list of coordinates and a crossmatch radius, split the list up into sets of associated locations
HMpTy.mysql.conesearch The worker class for the conesearch module
HMpTy.htm.htm.HTM A Hierarchical Triangular Mesh object
HMpTy.htm.htm.Matcher A matcher-array object to match other arrays of ra,dec against

Functions

HMpTy.mysql.add_htm_ids_to_mysql_database_table Given a database connection, a name of a table and the column names for RA and DEC, generates ID for one or more HTM level in the table

Installation

The easiest way to install HMpTy is to use pip:

pip install HMpTy

Or you can clone the github repo and install from a local version of the code:

git clone git@github.com:thespacedoctor/HMpTy.git
cd HMpTy
python setup.py install

To upgrade to the latest version of HMpTy use the command:

pip install HMpTy --upgrade

Development

If you want to tinker with the code, then install in development mode. This means you can modify the code from your cloned repo:

git clone git@github.com:thespacedoctor/HMpTy.git
cd HMpTy
python setup.py develop

Pull requests are welcomed!

Sublime Snippets

If you use Sublime Text as your code editor, and you’re planning to develop your own python code with HMpTy, you might find my Sublime Snippets useful.

Issues

Please report any issues here.

Command-Line Usage

Documentation for HMpTy can be found here: http://HMpTy.readthedocs.org/en/stable


Usage:
    hmpty htmid <level> <ra> <dec>
    hmpty [-f] index <tableName> <primaryIdCol> <raCol> <decCol> (-s <pathToSettingsFile>|--host <host> --user <user> --passwd <passwd> --dbName <dbName>)
    hmpty search <tableName> <raCol> <decCol> <ra> <dec> <radius> (-s <pathToSettingsFile>|--host <host> --user <user> --passwd <passwd> --dbName <dbName>) [(-r <format>|-r mysql <resultsTable>)]

Options:
    index                 add HTMids to database table
    search                perform a conesearch on a database table
    htmid                 generate the htmID at the given coordinates for the give HTM level

    tableName                                                       name of the table to add the HTMids to
    primaryIdCol                                                    the name of the unique primary ID column of the database table
    raCol                                                           name of the table column containing the right ascension
    decCol                                                          name of the table column containing the declination
    ra                                                              the right ascension of the centre of the conesearch circle or coordinate set
    dec                                                             the declination of the centre of the conesearch circle or coordinate set
    radius                                                          the radius of the conesearch circle (arcsec)
    level                                                           the HTM level required

    -f, --force                                                     force a regeneration of all HTMIDs
    -h, --help                                                      show this help message
    -v, --version                                                   show version
    -s <pathToSettingsFile>, --settings <pathToSettingsFile>        path to a settings file containing the database credentials
    --host <host>                                                   database host address
    --user <user>                                                   database username
    --passwd <passwd>                                               database password
    --dbName <dbName>                                               database name
    -r <format>, --render <format>                                  select a format to render your results in

Documentation

Documentation for HMpTy is hosted by Read the Docs (last stable version and latest version).

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 credientials:

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

Or alternatively you can pass the credientials 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()) ;