/* Stahovani dat Active Power pro MSG Tower */
SELECT *
FROM OPENQUERY 
(RAK_HIS03

, ''
DECLARE @StartDate DateTime
DECLARE @EndDate DateTime
SET @StartDate = dateadd(d,-1,getdate())
SET @EndDate = getdate()
SET NOCOUNT OFF

SELECT   t1.tag as TagName
              , t2.StartDateTime as CollectionDate
              , t1.vValue as Value
              , t2.vValue as BatchId
              , t3.vValue as Status
from (

SELECT temp.TagName as tag, vValue,StartDateTime From (
SELECT  * 
 FROM History
WHERE History.TagName IN ( ''''E143_Active_Power'''',''''E142_Active_Power'''',''''E141_Active_Power'''',''''E140_Active_Power'''',''''DryScrap_Snek_Active_Power''''
                                         ,''''E14_Active_Power'''',''''E65_Active_Power'''',''''E138_Active_Power'''',''''E136_Active_Power'''',''''E89_Active_Power'''',''''E88_Active_Power'''',''''E87_Active_Power''''
                                         ,''''E86_Active_Power'''',''''E85_Active_Power'''',''''E83_Active_Power'''',''''E113_Active_Power'''',''''E1_Active_Power'''',''''E66_Active_Power''''
                                         ,''''E71_Active_Power'''',''''E72_Active_Power'''',''''E70_Active_Power'''',''''E73_Active_Power'''',''''MSG_TWR_FT1480.Out_PV'''')
AND wwRetrievalMode = ''''Cyclic''''
AND wwResolution = 1000 * 60 
 AND wwVersion = ''''Latest''''
AND DateTime >= @StartDate
AND DateTime <= @EndDate) temp
LEFT JOIN AnalogTag ON AnalogTag.TagName =temp.TagName
LEFT JOIN EngineeringUnit ON AnalogTag.EUKey = EngineeringUnit.EUKey
LEFT JOIN QualityMap ON QualityMap.QualityDetail = temp.QualityDetail
WHERE temp.StartDateTime >= @StartDate

) as t1

join 

(

SELECT temp.TagName as tag2 , vValue,StartDateTime From (
SELECT  * 
 FROM History
WHERE History.TagName IN (''''MSG_CRU_QW_Data.BatchID'''')
AND wwRetrievalMode = ''''Cyclic''''
AND wwResolution = 1000 * 60 
 AND wwVersion = ''''Latest''''
AND DateTime >= @StartDate
AND DateTime <= @EndDate) temp
LEFT JOIN AnalogTag ON AnalogTag.TagName =temp.TagName
LEFT JOIN EngineeringUnit ON AnalogTag.EUKey = EngineeringUnit.EUKey
LEFT JOIN QualityMap ON QualityMap.QualityDetail = temp.QualityDetail
WHERE temp.StartDateTime >= @StartDate
) as t2 on t1.StartDateTime = t2.StartDateTime

join 

(

SELECT temp.TagName as tag2 , vValue,StartDateTime From (
SELECT  * 
 FROM History
WHERE History.TagName IN (''''Start_Stop_URACA'''')
AND wwRetrievalMode = ''''Cyclic''''
AND wwResolution = 1000 * 60
AND wwVersion = ''''Latest''''
AND DateTime >= @StartDate
AND DateTime <= @EndDate) temp
LEFT JOIN AnalogTag ON AnalogTag.TagName =temp.TagName
LEFT JOIN EngineeringUnit ON AnalogTag.EUKey = EngineeringUnit.EUKey
LEFT JOIN QualityMap ON QualityMap.QualityDetail = temp.QualityDetail
WHERE temp.StartDateTime >= @StartDate
) as t3 on t2.StartDateTime = t3.StartDateTime
''
)'