Untitled
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