select a.webser,a.input,a.prop,d.dist_chi_shtdesc,a.cbname,a.floor,a.gross,a.gdn,a.askprice,a.rent,a.igeti,a.prhno,a.photo_ts, a.level,
(select p.imagestorename from photos p where p.asking_ref = a.branchPhotoRef and p.asking_ref <> '' and p.valid = 1 limit 0,1)
as imagestorename
from asking a left join dcode d on a.dcode=d.dcode where a.sysid = 'YYP' and a.input >= '2026-01-29' and a.isvalid=1 and 20260731203 order by a.input desc, a.photo_ts desc limit 0,10
宜家置業，村屋專家 - 實盤實相
