This website (www2.astrogrid.org) is now deprecated - please go to www.astrogrid.org for up to date information.
Using three tables
Click here to get the file
Size
8.4 kB
-
File type
text/xml
File contents
<?xml version="1.0" encoding="UTF-8"?>
<tool name="wfau.roe.ac.uk/dsa-sdss-catalog/ceaApplication" interface="adql" xmlns="http://www.astrogrid.org/schema/AGWorkflow/v1"><input><parameter name="Query"><ns1:value xmlns:ns1="http://www.astrogrid.org/schema/AGParameterDefinition/v1"><!-- ADQL (originally) generated from: {OldQuery: In scope PhotoObj,Field,Segment,find where Intersection(([ColRef Field(alias 'f').fieldID]) = ([ColRef PhotoObj(alias 'p').fieldID]), Intersection(([ColRef Field(alias 'f').segmentID]) = ([ColRef Segment(alias 'g').segmentID]), Intersection(([ColRef Segment(alias 'g').run]) = ([Real] 1336.0 null), Intersection(([ColRef Segment(alias 'g').camCol]) = ([Real] 1.0 null), Intersection(([ColRef Field(alias 'f').field]) >= ([Real] 11.0 null), Intersection(([ColRef Field(alias 'f').field]) <= ([Real] 13.0 null), Intersection(([ColRef Field(alias 'f').psfWidth_r]) > ([Real] 1.2 null), ([ColRef PhotoObj(alias 'p').colc]) > ([Real] 400.0 null)))))))), returning [TableResults: target=null, cols=[ColRef Segment(alias 'g').run], [ColRef Segment(alias 'g').rerun], [ColRef Segment(alias 'g').camCol], [ColRef Field(alias 'f').field], [ColRef PhotoObj(alias 'p').objID], [ColRef PhotoObj(alias 'p').ra], [ColRef PhotoObj(alias 'p').dec], [ColRef PhotoObj(alias 'p').Rowc], [ColRef PhotoObj(alias 'p').Colc], [ColRef PhotoObj(alias 'p').u], [ColRef PhotoObj(alias 'p').modelMagErr_u], [ColRef PhotoObj(alias 'p').g], [ColRef PhotoObj(alias 'p').modelMagErr_g], [ColRef PhotoObj(alias 'p').r], [ColRef PhotoObj(alias 'p').modelMagErr_r], [ColRef PhotoObj(alias 'p').petroMag_r], [ColRef PhotoObj(alias 'p').extinction_r], Format Default, ]} on Sun Nov 05 14:16:34 GMT 2006 --><?ag-adql-schema-version v1.0a1?><Select xsi:type="selectType" xmlns="http://www.ivoa.net/xml/ADQL/v1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SelectionList xsi:type="selectionListType">
<Item xsi:type="columnReferenceType" Table="g" Name="run"/>
<Item xsi:type="columnReferenceType" Table="g" Name="rerun"/>
<Item xsi:type="columnReferenceType" Table="g" Name="camCol"/>
<Item xsi:type="columnReferenceType" Table="f" Name="field"/>
<Item xsi:type="columnReferenceType" Table="p" Name="objID"/>
<Item xsi:type="columnReferenceType" Table="p" Name="ra"/>
<Item xsi:type="columnReferenceType" Table="p" Name="dec"/>
<Item xsi:type="columnReferenceType" Table="p" Name="Rowc"/>
<Item xsi:type="columnReferenceType" Table="p" Name="Colc"/>
<Item xsi:type="columnReferenceType" Table="p" Name="u"/>
<Item xsi:type="columnReferenceType" Table="p" Name="modelMagErr_u"/>
<Item xsi:type="columnReferenceType" Table="p" Name="g"/>
<Item xsi:type="columnReferenceType" Table="p" Name="modelMagErr_g"/>
<Item xsi:type="columnReferenceType" Table="p" Name="r"/>
<Item xsi:type="columnReferenceType" Table="p" Name="modelMagErr_r"/>
<Item xsi:type="columnReferenceType" Table="p" Name="petroMag_r"/>
<Item xsi:type="columnReferenceType" Table="p" Name="extinction_r"/>
</SelectionList>
<From xsi:type="fromType">
<Table xsi:type="tableType" Name="PhotoObj" Alias="p"/>
<Table xsi:type="tableType" Name="Field" Alias="f"/>
<Table xsi:type="tableType" Name="Segment" Alias="g"/>
</From>
<Where xsi:type="whereType">
<Condition xsi:type="intersectionSearchType">
<Condition xsi:type="comparisonPredType" Comparison="=">
<Arg xsi:type="columnReferenceType" Table="f" Name="fieldID"/>
<Arg xsi:type="columnReferenceType" Table="p" Name="fieldID"/>
</Condition>
<Condition xsi:type="intersectionSearchType">
<Condition xsi:type="comparisonPredType" Comparison="=">
<Arg xsi:type="columnReferenceType" Table="f" Name="segmentID"/>
<Arg xsi:type="columnReferenceType" Table="g" Name="segmentID"/>
</Condition>
<Condition xsi:type="intersectionSearchType">
<Condition xsi:type="comparisonPredType" Comparison="=">
<Arg xsi:type="columnReferenceType" Table="g" Name="run"/>
<Arg xsi:type="atomType">
<Literal xsi:type="realType" Value="1336.0"/>
</Arg>
</Condition>
<Condition xsi:type="intersectionSearchType">
<Condition xsi:type="comparisonPredType" Comparison="=">
<Arg xsi:type="columnReferenceType" Table="g" Name="camCol"/>
<Arg xsi:type="atomType">
<Literal xsi:type="realType" Value="1.0"/>
</Arg>
</Condition>
<Condition xsi:type="intersectionSearchType">
<Condition xsi:type="comparisonPredType" Comparison=">=">
<Arg xsi:type="columnReferenceType" Table="f" Name="field"/>
<Arg xsi:type="atomType">
<Literal xsi:type="realType" Value="11.0"/>
</Arg>
</Condition>
<Condition xsi:type="intersectionSearchType">
<Condition xsi:type="comparisonPredType" Comparison="&lt;=">
<Arg xsi:type="columnReferenceType" Table="f" Name="field"/>
<Arg xsi:type="atomType">
<Literal xsi:type="realType" Value="13.0"/>
</Arg>
</Condition>
<Condition xsi:type="intersectionSearchType">
<Condition xsi:type="comparisonPredType" Comparison=">">
<Arg xsi:type="columnReferenceType" Table="f" Name="psfWidth_r"/>
<Arg xsi:type="atomType">
<Literal xsi:type="realType" Value="1.2"/>
</Arg>
</Condition>
<Condition xsi:type="comparisonPredType" Comparison=">">
<Arg xsi:type="columnReferenceType" Table="p" Name="colc"/>
<Arg xsi:type="atomType">
<Literal xsi:type="realType" Value="400.0"/>
</Arg>
</Condition>
</Condition>
</Condition>
</Condition>
</Condition>
</Condition>
</Condition>
</Condition>
</Where>
</Select></ns1:value></parameter><parameter name="Format"><ns2:value xmlns:ns2="http://www.astrogrid.org/schema/AGParameterDefinition/v1">VOTABLE</ns2:value></parameter></input><output><parameter name="Result"><ns3:value xmlns:ns3="http://www.astrogrid.org/schema/AGParameterDefinition/v1"></ns3:value></parameter></output></tool>