select indexid,photopath,url,goodsid,cityname from cy_adproperty left join cy_city on cy_adproperty.goodsid=cy_city.cityid where pid=1 and subid=3

select indexid,photopath,url,goodsid,cityname from cy_adproperty left join cy_city on cy_adproperty.goodsid=cy_city.cityid where pid=3 and subid=5

select indexid,photopath,url,goodsid,cityname from cy_adproperty left join cy_city on cy_adproperty.goodsid=cy_city.cityid where pid=3 and subid=6