diff --git a/wwwroot/inc/database.php b/wwwroot/inc/database.php
index 0529122..fe295ea 100644
--- a/wwwroot/inc/database.php
+++ b/wwwroot/inc/database.php
@@ -22,7 +22,7 @@ $SQLSchema = array
 			'label' => 'label',
 			'asset_no' => 'asset_no',
 			'objtype_id' => 'objtype_id',
-			'rack_id' => '(SELECT rack_id FROM RackSpace WHERE object_id = RackObject.id ORDER BY rack_id ASC LIMIT 1)',
+			'rack_id' => '(SELECT distinct rack_id FROM RackSpace WHERE object_id = RackObject.id LIMIT 1)',
 			'rack_id_2' => "(SELECT parent_entity_id AS rack_id FROM EntityLink WHERE child_entity_type='object' AND child_entity_id = RackObject.id AND parent_entity_type = 'rack' ORDER BY rack_id ASC LIMIT 1)",
 			'Rack_name' => '(select name from Rack where id = rack_id)',
 			'row_id' => '(select row_id from Rack where id = rack_id)',