diff --git a/data.go b/data.go
index 366e010..ae7875b 100644
--- a/data.go
+++ b/data.go
@@ -136,10 +136,8 @@
 	return
 }
 
-// TODO there's a bug in the db statement
 func (dbc *dbManager) getReadyDeployments() ([]DataDeployment, error) {
 
-
 	rows, err := dbc.getDb().Query(`
 		SELECT 	a.id,
 			a.organization_id,
@@ -153,31 +151,28 @@
 			a.created_at,
 			a.created_by,
 			a.updated_at,
-			a.updated_by,
-			b.local_fs_location
+			a.updated_by
 		FROM metadata_runtime_entity_metadata as a
-		INNER JOIN edgex_blob_available as b
-		ON (a.bean_blob_id = b.id)
 		WHERE a.id IN (
 			SELECT
 					a.id
 				FROM metadata_runtime_entity_metadata as a
-				INNER JOIN edgex_blob_available as b
+				INNER JOIN apid_blob_available as b
 				ON a.resource_blob_id = b.id
 				WHERE a.resource_blob_id != ""
 			INTERSECT
 				SELECT
 					a.id
 				FROM metadata_runtime_entity_metadata as a
-				INNER JOIN edgex_blob_available as b
-				ON a.resource_blob_id = b.id
+				INNER JOIN apid_blob_available as b
+				ON a.bean_blob_id = b.id
 				WHERE a.resource_blob_id != ""
 
 			UNION
 				SELECT
 					a.id
 				FROM metadata_runtime_entity_metadata as a
-				INNER JOIN edgex_blob_available as b
+				INNER JOIN apid_blob_available as b
 				ON a.bean_blob_id = b.id
 				WHERE a.resource_blob_id = ""
 		)