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