Changes between Version 11 and Version 12 of WorkingGrid/DataProviderSetup/PMLOct06


Ignore:
Timestamp:
02/10/06 17:49:15 (13 years ago)
Author:
mhenning
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • WorkingGrid/DataProviderSetup/PMLOct06

    v11 v12  
    1616 
    1717{{{ 
    18 mhen=# SELECT production_tool.description AS Sensor, COUNT(data_entity.*) AS RecordCount FROM ndg.data_entity, ndg.data_entity_deployment, ndg.production_tool, ndg.deployment WHERE deployment.production_tool_id = production_tool.production_tool_id AND data_entity_deployment.data_entity_id = data_entity.data_entity_id AND data_entity_deployment.deployment_id = deployment.deployment_id GROUP BY(production_tool.description); 
     18mhen=# SELECT production_tool.description AS Sensor, COUNT(data_entity.*) AS RecordCount  
     19FROM ndg.data_entity, ndg.data_entity_deployment, ndg.production_tool, ndg.deployment  
     20WHERE deployment.production_tool_id = production_tool.production_tool_id  
     21AND data_entity_deployment.data_entity_id = data_entity.data_entity_id  
     22AND data_entity_deployment.deployment_id = deployment.deployment_id  
     23GROUP BY(production_tool.description); 
    1924 sensor  | recordcount  
    2025---------+-------------