select Distinct(prj.projectname),ship.carrier_id,track_nos.tracking_no, prj.bid_number,prj.project_budget,c.client,prj.pid,prj.order_placeon,prj.status,ship.tracking_number ,emp.firstname,emp.lastname,prch.purchaseorder,prc.prjquote,prc.prjcost,prc.prj_completioncost,prc.prj_est_profit,prc.prj_estimatecost, prc.prj_completioncost,tbl_carriers.weblink,pro.prdtntrgtdelvry 
from tbl_newproject as prj 
left join tbl_prjpurchase as prch on prch.pid = prj.pid 
left join tbl_prjorder_shipping as ship on ship.shipping_id=
(select tbl_prjorder_shipping.shipping_id 
from tbl_prjorder_shipping inner join tbl_newproject on tbl_prjorder_shipping.pid = prj.pid order by tbl_prjorder_shipping.shipping_id desc limit 1)
left join tbl_carriers on tbl_carriers.carrier_id = ship.carrier_id 
left join tbl_prjorder_track_no as track_nos on track_nos.track_id= 
(select track.track_id from tbl_prjorder_track_no as track where track.shipping_id=ship.shipping_id order by track.track_id desc limit 1) 
left join tbl_prjpricing as prc on prc.pid = prj.pid 
left join "employeeDB" as emp on emp."employeeID"= prj.project_manager 
left join tbl_prmilestone as pro on pro.pid = prj.pid 
left join "clientDB" c on prj.client=c."ID" 
inner join tbl_prjvendor pv on pv.pid=prj.pid 
left join vendor v on v."vendorID"=pv.vid 
left join vendor on v."vendorID"=pv.vid 
where prch.purchaseorder IS NULL and prj.status =1 and v."vendorID" =372 
order by prj."pid" desc