Untitled

 avatar
unknown
plain_text
5 months ago
2.0 kB
3
Indexable
            SELECT 
                line_main.name AS "Line_Name",
                subline.name AS "Subline_Name",
                station.name AS "Station_Name",
                equipment.name AS "Equipment_Name",
                equipment."number" AS "Equipment_Number",                
                engine_model.name AS "Model_Name",
                part_variant.name AS "Variant_Name",
                pm.datetime AS "Parameter_Datetime",
                pm.part_serial_no AS "Part_Serial_Number",
                parameter.name AS "Parameter_Name",         
                pm.value AS "Measurement_Value",
                pm.shift AS "Shift",
                pm.zone AS "Zone",
                pm.is_delay AS "Is_Delay",
                pm.is_tip_dress AS "Is_Tip_Dress",
                pm.is_fault AS "Is_Fault",
                pm.shop_id AS "Shop_ID",
                pm.latest_count AS "Latest_Count"
            FROM 
                "iot-prodigi-parameter-measurement" pm
            LEFT JOIN 
                "iot-prodigi-line" line_main ON pm.line_id = line_main.id
            LEFT JOIN 
                "iot-prodigi-line" subline ON pm.subline_id = subline.id
            LEFT JOIN 
                "iot-prodigi-station" station ON pm.station_id = station.id
            LEFT JOIN 
                "iot-prodigi-equipment" equipment ON pm.equipment_id = equipment.id
            LEFT JOIN 
                "iot-prodigi-engine-model" engine_model ON pm.model_id = engine_model.id
            LEFT JOIN 
                "iot-prodigi-parameter" parameter ON pm.parameter_id = parameter.id
            LEFT JOIN 
                "iot-prodigi-part-variant" part_variant ON parameter.variant_id = part_variant.id
            WHERE 
                pm.datetime >= '2024-07-18 00:00:00' and  pm.datetime < '2024-09-19 00:00:00'
            ORDER BY 
                pm.datetime DESC
            LIMIT 100
Editor is loading...
Leave a Comment