予約投稿
この記事を読んだ方へのおすすめです
WordPress データベースエラー: [Can't find FULLTEXT index matching the column list]SELECT 16474 AS reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('')) * 2 + (MATCH (post_title) AGAINST ('予約投稿')) * 2 + (1 = 0) * 1 + COUNT(DISTINCT IF( terms.term_taxonomy_id IN (1), terms.term_taxonomy_id, null )) * 1,4) AS score
FROM wp678437posts
left join wp678437term_relationships as terms on ( terms.object_id = wp678437posts.ID )
WHERE post_status IN ( 'publish', 'static' ) AND post_password ='' AND post_type IN ('product') AND wp678437posts.ID NOT IN (16474)
GROUP BY ID
HAVING score >= 1.000000 AND ID != 0 ORDER BY score DESC LIMIT 4
