SELECT structure_1.id ,structure_ol_1.structure_ol_title AS title ,structure_1.structure_image_2 AS image ,structure_1.structure_text_1 AS construction ,structure_1.structure_textarea_2 AS discount ,structure_1.structure_date_1 AS date_1 ,structure_1.structure_date_2 AS date_2 ,structure_1.structure_created_date AS date ,structure_1.structure_double_5 AS ping_min ,structure_1.structure_double_6 AS ping_max ,structure_1.structure_double_1 AS price_min ,structure_1.structure_double_2 AS price_max ,structure_1.structure_double_9 AS tprice_min ,structure_1.structure_double_10 AS tprice_max ,(SELECT structure_ol_title FROM structure_ol WHERE id IN (SELECT s.structure_id FROM structure s, structure_ol so WHERE s.id = so.id AND s.id = structure_1.structure_category_id_2)) AS city ,(SELECT structure_ol_title FROM structure_ol WHERE id = structure_1.structure_category_id_2) AS area ,(SELECT structure_ol_title FROM structure_ol WHERE id = structure_1.structure_category_id_3) AS type ,(SELECT COUNT(id) FROM structure WHERE structure_id = '1058' AND structure_category_id_2 = structure_1.id) AS count ,(SELECT COUNT(id) FROM structure WHERE structure_id = '1057' AND structure_category_id_2 = structure_1.id) AS count2 FROM structure structure_1 ,structure_ol structure_ol_1 WHERE structure_1.id = structure_ol_1.id AND structure_1.structure_id = '1004' AND structure_1.structure_boolean_1 = 'Y' AND structure_1.structure_hidden != 'Y' AND structure_1.structure_visible = 'Y' AND structure_ol_1.lid = '1' AND structure_1.structure_date_1 <= ? AND structure_1.structure_date_2 > ? ORDER BY structure_1.structure_date_2 ASC LIMIT ? OFFSET ?
首頁 > 揪團潛銷
團購買屋購物諮詢、購屋行情  |  Chango 台中新屋團購網
客服信箱:123@cgo-h.com 聯絡專線:0978-888216 ( 時間:週一至週五 09:00~21:00 )