SELECT p.id, p.title, p.title_big5, p.slug, p.price, p.price_negotiable, prov.en_name as province,
p.is_featured, p.published_at, p.category_id,
c.name AS cat_name, c.name_big5 AS cat_name_ch,
(SELECT filename FROM classified_post_images img
WHERE img.post_id = p.id ORDER BY img.sort_order ASC LIMIT 1) AS cover_image
FROM classified_posts p
LEFT JOIN classified_category c ON c.id = p.category_id
LEFT JOIN province prov on prov.id = p.province_id
WHERE p.display = 'Y' AND (p.end_post_date IS NULL OR p.end_post_date >= CURDATE())
ORDER BY p.is_featured DESC, p.published_at DESC
LIMIT 12 OFFSET 0
餐館請人
Ajax