Multi-Table query under messy records

select TagID from TagTreeView where ParentID=503

select * from Tags

left outer join MultiLangCategories on MultiLangCategories.CategoryID=Tags.TagID

where SystemID=1 and IsSharing=1 and Deleted=0 

    and TagID in(select TagID from TagTreeView where ParentID=503)

select * from Tags as ata

full join MultiLangCategories as amu on amu.CategoryID=ata.TagID

full join BuyInfo as abu on abu.BuyInfoSort = amu.CategoryID

where SystemID=1 and IsSharing=1 and ata.Deleted=0 

    and TagID in(select TagID from TagTreeView where ParentID=503)

    and abu.autono =3

select value from Tags as ata full join MultiLangCategories as amu on amu.CategoryID=ata.TagID full join BuyInfo as abu on abu.BuyInfoSort = amu.CategoryID where SystemID=1 and IsSharing=1 and ata.Deleted=0 and TagID in(select TagID from TagTreeView where ParentID=503) and abu.autono =3

select TagID from TagTreeView where ParentID=503

select * from Buyinfo

select * from Multilangcategories

select * from Tags