SELECT p.*,
(SELECT e.actividad_estatus FROM entregable e WHERE e.id_actividad = p.id and e.actividad_resp3 = 15) as status_entregable_usuario,
(SELECT e.id_entregable FROM entregable e WHERE e.id_actividad = p.id and e.actividad_resp3 = 15) as entregable_usuario
FROM `pap_sub_eje` p WHERE p.padre = 41879