{//dede:sql sql="select * from (
SELECT s.id sid,p.id as pid,s.org_name,s.photo,p.IndustryName FROM `portal_industrytype` p , service_org_info s
WHERE p.IndustryCode = s.industry_code ) as t where t.pid>=1335 and t.pid<=1386 limit 0,6"}
{///dede:sql}
{//dede:sql sql="select * from (
SELECT s.id sid,p.id as pid,s.org_name,s.photo,p.IndustryName FROM `portal_industrytype` p , service_org_info s
WHERE p.IndustryCode = s.industry_code ) as t where t.pid>=1466 and t.pid<=1490 limit 0,6"}
{///dede:sql}
{//dede:sql sql="select org_name , id,create_timestamp from service_org_info where industry_code=9422 order by create_timestamp desc limit 6"}
{///dede:sql}