Context Navigation

Changes between Initial Version and Version 1 of Ticket #57767, comment 5

-                      initial
+                      v1
 {{{
 SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
                                         FROM wp_posts  LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )  LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id AND mt2.meta_key = 'プラン' )
+                                        FROM wp_posts  LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'プラン' )
                                         WHERE 1=1  AND (
   wp_postmeta.meta_key = 'プラン'
+  AND
+  (
+    mt1.meta_key = 'プラン'
+    OR
+    mt2.post_id IS NULL
+  )
+  OR
+  mt1.post_id IS NULL
 ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'
 OR wp_posts.post_status = 'private')))
                                         GROUP BY wp_posts.ID
                                         ORDER BY wp_postmeta.meta_value DESC, wp_posts.post_date DESC
+                                        ORDER BY CAST(wp_postmeta.meta_value AS CHAR) DESC, CAST(mt1.meta_value AS CHAR) DESC, wp_posts.post_date DESC
                                         LIMIT 0, 10
 }}}