SELECT WELLNAME AS WELL_NAME,
MD AS WELL_DEPTH,
BITDEPTH AS BIT_DEPTH,
TOTALTIME AS DRILLING_TIME,
WOB,
ROP,
TORQUE AS ROTARY_TORQUE,
RPM AS ROTATE_SPEED,
STANDPRES AS STANDPIPE_PRESSURE,
CASPRES AS CASING_PRESSURE,
SPM1 AS SPM,
WEIGHTIN AS MUD_DENS_IN,
WEIGHTIN AS EQUIVALENT_FLUID_DENSITY,
WEIGHTOUT AS MUD_DENS_OUT,
TEMPIN AS MUD_TEMP_IN,
TEMPOUT AS MUD_TEMP_OUT,
FLOWIN AS FLOW_IN,
FLOWOUT AS FLOW_OUT,
CONDIN AS MCI,
CONDOUT AS MCO,
TOTALPIT AS TOTAL_POOL_VOL,
ECD AS EQUIVALENT_FLUID_DENSITY,
HOOKLOAD AS WHO,
TG AS GAS,
BKHT AS BLOCK_HEIGHT,
INPUTTIME AS TIME,
FOOTAGE AS DRILLING_FOOTAGE
FROM V_DR_STE_ST_REALTIME_DATA
WHERE MD >= 0
AND BITDEPTH >= 0
AND TOTALTIME >= 0
AND WOB >= 0
AND ROP >= 0
AND TORQUE >= 0
AND RPM >= 0
AND STANDPRES >= 0
AND CASPRES >= 0
AND SPM1 >= 0
AND WEIGHTIN >= 0
AND WEIGHTOUT >= 0
AND TEMPIN >= 0
AND TEMPOUT >= 0
AND FLOWIN >= 0
AND FLOWOUT >= 0
AND CONDIN >= 0
AND CONDOUT >= 0
AND TOTALPIT >= 0
AND ECD >= 0
AND HOOKLOAD >= 0
AND TG >= 0
AND BKHT >= 0
AND FOOTAGE >= 0
ORDER BY MD ASC;