WordPress 資料庫錯誤: [Regex error 'quantifier does not follow a repeatable item at offset 57']
SELECT
upi1_posts.post_title as title,
upi1_posts.ID as id,
upi1_posts.post_date as date,
upi1_posts.post_content as content,
upi1_posts.post_excerpt as excerpt,
upi1_users.user_nicename as author,
upi1_posts.post_type as post_type,
(SELECT DISTINCT CONCAT('--', GROUP_CONCAT( upi1_term_taxonomy.term_id SEPARATOR '----' ), '--') FROM upi1_term_taxonomy
LEFT JOIN upi1_term_relationships ON upi1_term_relationships.term_taxonomy_id = upi1_term_taxonomy.term_taxonomy_id
WHERE (upi1_term_relationships.object_id = upi1_posts.ID) ) as ttid,
((case when
(lower(upi1_posts.post_title) REGEXP '這個表情符號(emoji)原本的意思,竟然是|😂')
then 10 else 0 end) + (case when
(lower(upi1_posts.post_content) REGEXP 'media|credit|alignnone|align|756|width')
then 8 else 0 end)) as relevance
FROM upi1_posts
LEFT JOIN upi1_postmeta ON upi1_postmeta.post_id = upi1_posts.ID
LEFT JOIN upi1_users ON upi1_users.ID = upi1_posts.post_author
WHERE
(upi1_posts.ID <> 1014) AND
(upi1_posts.post_type REGEXP '[[:<:]]dummy_notting[[:>:]]|[[:<:]]post[[:>:]]|[[:<:]]page[[:>:]]') AND
upi1_posts.ID NOT IN (-99) AND
(upi1_posts.post_status = 'publish') AND
((lower(upi1_posts.post_title) REGEXP '這個表情符號(emoji)原本的意思,竟然是|😂') OR (lower(upi1_posts.post_content) REGEXP '這個表情符號(emoji)原本的意思,竟然是|😂') OR (lower(upi1_posts.post_excerpt) REGEXP '這個表情符號(emoji)原本的意思,竟然是|😂') OR (lower(upi1_posts.post_content) REGEXP 'media|credit|alignnone|align|756|width') OR (lower(upi1_posts.post_title) REGEXP 'media|credit|alignnone|align|756|width') OR (lower(upi1_posts.post_excerpt) REGEXP 'media|credit|alignnone|align|756|width'))
GROUP BY upi1_posts.ID
HAVING (ttid NOT REGEXP '--57--|--27--|--3--|--1--|--34--')
ORDER BY relevance DESC, upi1_posts.post_date DESC
LIMIT 5