set @proj = '80047';

select l.* from project_Lot as l where l.project_id_=@proj;

select i.* from project_Iteration as i
    inner join project_Lot as l on i.lot_id_=l.id_
    where l.project_id_=@proj;

select ph.* from project_Phase as ph
    inner join project_Iteration as i on ph.iteration_id_=i.id_
    inner join project_Lot as l on i.lot_id_=l.id_
    where l.project_id_=@proj;

select t.* from project_Task as t
    inner join project_Phase as ph on t.phase_id_=ph.id_
    inner join project_Iteration as i on ph.iteration_id_=i.id_
    inner join project_Lot as l on i.lot_id_=l.id_
    where l.project_id_=@proj;

select a.* from timemanagement_Assignment as a
    inner join project_Task as t on a.task_id_=t.id_
    inner join project_Phase as ph on t.phase_id_=ph.id_
    inner join project_Iteration as i on ph.iteration_id_=i.id_
    inner join project_Lot as l on i.lot_id_=l.id_
    where l.project_id_=@proj;