<?xml version="1.0"?>
<!-- sample data query specification instance for the datamanager library -->
<dq:dataquery 
	xmlns:dq="eml://ecoinformatics.org/dataquery" 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xsi:schemaLocation="eml://ecoinformatics.org/dataquery dataquery.xsd ">
	<!--
		This sample XML is parsed by the Data Manager to produce the following SQL
		(formatted for improved legibility):
		
		SELECT Datos_Meteorologicos.DATE,
			Datos_Meteorologicos.TIME,
			Datos_Meteorologicos.T_AIR,
			Datos_Meteorologicos.RH,
			'otherTable' AS fakeColumn 
		FROM Datos_Meteorologicos  
		where  Datos_Meteorologicos.DATE = Datos_Meteorologicos.TIME 
		AND Datos_Meteorologicos.DATE = '01/01/01' 
		AND Datos_Meteorologicos.TIME IN 
			(SELECT Datos_Meteorologicos.TIME 
			FROM Datos_Meteorologicos  
			where  Datos_Meteorologicos.DATE = '01/01/01' 
			AND Datos_Meteorologicos.DATE = '01/02/01'  ) 
		AND ( Datos_Meteorologicos.DATE = '01/01/01' OR Datos_Meteorologicos.DATE = '01/01/01' )  
		
		UNION ALL 
		
		SELECT Datos_Meteorologicos.DATE,
			Datos_Meteorologicos.TIME,
			Datos_Meteorologicos.T_AIR,
			Datos_Meteorologicos.RH,
			'blah' AS fakeColumn 
		FROM Datos_Meteorologicos  
		where Datos_Meteorologicos.T_AIR >= 15;
		
	-->
	<union order="true">
		<!-- first query in UNION -->
		<query distinct="false">
			<selection>
				<datapackage id="tao.1.1">
					<entity name="Datos Meteorologicos">
						<attribute index="0"/>
						<attribute index="1"/>
						<attribute index="2"/>
						<attribute name="RH"/>						
					</entity>
				</datapackage>
				<staticItem name="fakeColumn" value="blah"/>
			</selection>
			<where>
				<condition type="condition">
					<left>
						<datapackage id="tao.1.1">
							<entity index="0">
								<attribute index="2"/>
							</entity>
						</datapackage>
					</left>
					<operator>>=</operator>					
					<right>
						<value>15</value>
					</right>
				</condition>
			</where>
		</query>
		<!-- second query in UNION -->
		<query>
			<selection>
				<datapackage id="tao.1.1">
					<entity index="0">
						<attribute index="0"/>
						<attribute index="1"/>
						<attribute index="2"/>
						<attribute name="RH"/>
					</entity>
				</datapackage>
				<staticItem name="fakeColumn" value="otherTable"/>
			</selection>
			<where>
				<and>
					<condition type="join">
						<left>
							<datapackage id="tao.1.1">
								<entity index="0">
									<attribute index="0"/>
								</entity>
							</datapackage>
						</left>
						<operator>=</operator>
						<right>
							<datapackage id="tao.1.1">
								<entity index="0">
									<attribute index="1"/>
								</entity>
							</datapackage>
						</right>
					</condition>
					<condition type="condition">
						<left>
							<datapackage id="tao.1.1">
								<entity index="0">
									<attribute index="0"/>
								</entity>
							</datapackage>
						</left>
						<operator>=</operator>
						<right>
							<value>01/01/01</value>
						</right>
					</condition>
					
					<!-- subquery clause-->
					<condition type="subquery">
						<left>
							<datapackage id="tao.1.1">
								<entity index="0">
									<attribute index="1"/>
								</entity>
							</datapackage>
						</left>
						<operator>IN</operator>						
						<right>
							<subquery>
								<selection>
									<datapackage id="tao.1.1">
										<entity index="0">
											<attribute index="1"/>
										</entity>
									</datapackage>
								</selection>
								<where>
									<and>
										<condition type="condition">
											<left>
												<datapackage id="tao.1.1">
													<entity index="0">
														<attribute index="0"/>
													</entity>
												</datapackage>
											</left>
											<operator>=</operator>
											<right>
												<value>01/01/01</value>
											</right>
										</condition>
										<condition type="condition">
											<left>
												<datapackage id="tao.1.1">
													<entity index="0">
														<attribute index="0"/>
													</entity>
												</datapackage>
											</left>
											<operator>=</operator>											
											<right>
												<value>01/02/01</value>
											</right>
										</condition>
									</and>	
								</where>
							</subquery>
						</right>
					</condition>
					
					<!-- nested OR relation --> 
					<or>
						<condition type="condition">
							<left>
								<datapackage id="tao.1.1">
									<entity index="0">
										<attribute index="0"/>
									</entity>
								</datapackage>
							</left>
							<operator>=</operator>
							<right>
								<value>01/01/01</value>
							</right>
						</condition>
						<condition type="condition">
							<left>
								<datapackage id="tao.1.1">
									<entity index="0">
										<attribute index="0"/>
									</entity>
								</datapackage>
							</left>
							<operator>=</operator>
							<right>
								<value>01/01/01</value>
							</right>
						</condition>
					</or>
				</and>	
			</where>
		</query>
	</union>
</dq:dataquery>