# Time: 2018-12-03T05:02:26.243369Z
# User@Host: dbname[dbname] @ localhost [] Id: 13187589
# Query_time: 24.966048 Lock_time: 0.000866 Rows_sent: 10 Rows_examined: 3013851
use dbname;
SET timestamp=1543813346;
SELECT^M
^M
wp_posts.post_title as title,^M
wp_posts.ID as id,^M
wp_posts.post_date as date,^M
wp_posts.post_content as content,^M
'' as excerpt,^M
'pagepost' as content_type,^M
(SELECT^M
wp_users.display_name as author^M
FROM wp_users^M
WHERE wp_users.ID = wp_posts.post_author^M
) as author,^M
'' as ttid,^M
wp_posts.post_type as post_type,^M
((case when^M
(wp_posts.post_title LIKE 'random value over here')^M
then 20 else 0 end) + (case when^M
(wp_posts.post_title LIKE 'another random value over here')^M
then 10 else 0 end) + (case when^M
(wp_posts.post_title LIKE 'random random random')^M
then 10 else 0 end) + (case when^M
(wp_terms.name = 'the best random value you can ever see')^M
then 10 else 0 end)) as relevance^M
FROM wp_posts^M
LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID^M
^M
LEFT JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id^M