SELECT g.name,
m.name,
m.phone,
m.mobile
FROM Appuser as u,
linkgroup AS g,
linkman as m
WHERE u.username = 'zealot '
&& u.ID = g.userid
&& g.ID = m.GID
&& ( m.phone like '%139% '
|| m.mobile like '%139% '
);
SELECT A.AGENTID, A.Mname, A.BriefInfo
FROM
AGENT AS A
INNER JOIN TBSupplierProperty as t
INNER JOIN [WholesalerProperty] AS W
ON A.AGENTID=T.AGENTID A.AGENTID=W.AGNTID
WEHRE 1=1 AND T.IsSellOne=1 AND T.Fee=1 AND
T.IsSellOne=1
select top 10
a.agentid,
a.CateId,
d.AdInfoName,
d.AdImageAdress,
d.AdLinkAdress
from [ads] as d INNER JOIN [agent] as a
on d.AgentId=a.AgentId
select * from [ADs]