SCROLL
NEWS
NDC PEOPLE
WordPress データベースエラー: [Unknown column 'wp_posts.recommend_zh' in 'order clause']
SELECT
SQL_CALC_FOUND_ROWS wp_posts.*
FROM
wp_posts
INNER JOIN
wp_postmeta AS _order ON (
_order.meta_key = 'order'
AND _order.post_id = wp_posts.ID
)
WHERE
1=1
AND wp_posts.post_type = 'works'
AND wp_posts.post_status = 'publish'
GROUP BY wp_posts.ID
ORDER BY wp_posts.recommend_zh-hans DESC, _order.meta_value DESC, wp_posts.post_date DESC
LIMIT 12
