SELECT p.post_id ,p.post_forid,p.post_name,p.post_lat,p.post_lng,p.post_hidelocation,p.post_typeid,p.post_pricesale,p.post_pricerent,p.post_saddr,p.post_thumb,p.mem_id,p.post_update,p.post_orderdate,p.post_viporder, p.post_sumsize, p.post_rooms, p.post_bathroom, p.post_floor, p.post_usagesize,p.post_options,a.refmem_id AS agent_id,a.pagt_thumb AS agent_thb,a.pagt_name AS agent_name,p.post_short
FROM tb_posts p
INNER JOIN tb_members m ON p.mem_id = m.mem_id
LEFT JOIN tb_posts_agent a ON p.mem_id = a.refmem_id WHERE (p.mem_id='70352') AND (p.is_visible=1 AND m.mem_active=1) ORDER BY post_viporder DESC, p.post_orderdate DESC
ประกาศของ SChain1
รายละเอียด F O R S A L E Atmoz Oasis Onnut Size 1 Bed Exclusive / Extra / Plus 24.1 - 34.8 Sq.m Floor 1 - 8 Type 1 Bed 1 Bath Fully furnished Price Starting 1,7
FOR SALE The Present Sukhumvit - Samutprakan Size 33 Sqm. Floor 8 Type 1 Bed 1 Bath Fully furnished Sale Price 2,400,000 ฿ - ติด BTS แพรกษา - Robinson สมุทรปราก
