hi can anybody help me to check this query is written in good way
select ATX_Status.Server as `Server`, ATX_Status.Load as `Load`,ATX_Status.System as `System`, atx.ATX_Status.Timestamp as `TimeStamp`, `Coverage`, atx.ATX_Summary.Testware as `View`, `Traffic`, ATX_Status.Status as `Status`, ATX_Request.Requestor as `Requestor`, atx.ATX_Summary. Logs as `Logs`, `Priority`, `Server_IP_Address`, atx.ATX_Request.isHostBuild as `isHost`, atx.ATX_WebLogs.Logs as `WLogs`, `TestRun`, `PRequestor`, `Reason`, `AbortRqstr`, DATE_SUB( str_to_date(ATX_Status.Timestamp, '%m%d%Y-%H'), INTERVAL ATX_Time.TimeDiff HOUR_MINUTE) as `ConvTime`, ATX_Reruns.isRerun as rerun, ATX_Reruns.comment as reruncomment, atx.ATX_RuntimeStats. lbtStartTime, atx.ATX_RuntimeStats.runStartTime, atx.ATX_RuntimeStats.totalRunDuration from atx.ATX_Status left join atx.ATX_Request on atx.ATX_Request.Timestamp = atx.ATX_Status.Timestamp left join atx.ATX_WebLogs on atx.ATX_Status.Timestamp = atx.ATX_WebLogs.Timestamp left join atx.ATX_Server on atx.ATX_Status.Server = atx.ATX_Server.Server_Name left join atx.ATX_Time on atx.ATX_Server.Server_Location = atx.ATX_Time.Server_Location left join atx.ATX_RuntimeStats on atx.ATX_Status.Timestamp = atx.ATX_RuntimeStats.Timestamp left join atx.ATX_AbortedJobs on atx.ATX_Status.Timestamp = atx.ATX_AbortedJobs.Timestamp left join atx.ATX_Reruns on atx.ATX_Status.Timestamp = atx.ATX_Reruns.Timestamp left join atx.ATX_Summary on atx.ATX_Summary.Timestamp = atx.ATX_Status.Timestamp where ( ATX_Status.Status like '%running%' or ATX_Status.Status like '%queued%' or ATX_Status.Status like '%migrating%' or ATX_Status.Status like '%loading%' or ATX_Status.Status like '%configuring%' or ATX_Status.Status like '%activating%' ) and ATX_Server.Server_Status=1 and ATX_Status.isAlive=1 and ATX_Status.Server = 'ALIL-CHN RLAB' and ATX_Status.System = 'ETSI-NFXSA-NANTA-ISAM-01' and ATX_Status.Load = 'SD_4003.418' and str_to_date(ATX_Status.Timestamp, '%m%d%Y') thanks in advance Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com
