Page History

querystring="SELECT *, sensor.name as sensorName, sensor.Type as sensorType "
                "FROM sensor, cylinder, machine  WHERE "
                "sensor.machine_id = machine.machine_id "
                "AND cylinder.cylinder_id = sensor.cylinder_id "
                "AND machine.ActiveMachine = 1";