Project machine names that depend on project machine name

console.sql

SELECT DISTINCT fdfpmn.field_project_machine_name_value, pdd.dependency
FROM project_dependency_dependency pdd
  LEFT JOIN project_dependency_component pdc ON pdc.component_id = pdd.component_id
  LEFT JOIN field_data_field_release_project fdfrp ON fdfrp.entity_id = pdc.release_nid
  LEFT JOIN field_data_field_project_machine_name fdfpmn on fdfpmn.entity_id = fdfrp.field_release_project_target_id
WHERE pdd.dependency IN (SELECT DISTINCT pdc.name FROM project_dependency_dependency pdd
  LEFT JOIN  project_dependency_component pdc ON pdc.component_id = pdd.component_id
  LEFT JOIN field_data_field_release_project fdfrp ON fdfrp.entity_id = pdc.release_nid
  LEFT JOIN field_data_field_project_machine_name fdfpmn on fdfpmn.entity_id = fdfrp.field_release_project_target_id
WHERE fdfpmn.field_project_machine_name_value = 'context')
AND pdd.core_api REGEXP '7.x|8.x';