[MySQL] Sortowanie według dat Opcje

[aras785]

Cześć.

Jak napisać zapytanie tak aby najpierw pokazało daty w przód (ASC), a później całą resztę (DESC)

Moje zapytanie:

[SQL] pobierz, plaintext 
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID,wp_postmeta.meta_value
FROM wp_posts
INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id)
INNER JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id)
INNER JOIN wp_postmeta AS mt4 ON (wp_posts.ID = mt4.post_id)
INNER JOIN wp_postmeta AS mt5 ON (wp_posts.ID = mt5.post_id)
WHERE 1=1
  AND (wp_postmeta.meta_key = 'data_od'
       AND ((mt1.meta_key = 'post_jest_wydarzeniem'
             AND mt1.meta_value = '1')
            AND (((mt2.meta_key = 'data_od'
                   AND mt2.meta_value >= '20180101')
                  AND (mt3.meta_key = 'data_od'
                       AND mt3.meta_value <= '20180131') )
                 OR ((mt4.meta_key = 'data_do'
                      AND mt4.meta_value >= '20180101')
                     AND (mt5.meta_key = 'data_do'
                          AND mt5.meta_value <= '20180131') ) ) ))
  AND wp_posts.post_type = 'page'
  AND (wp_posts.post_status = 'publish'
       OR wp_posts.post_status = 'future'
       OR wp_posts.post_status = 'draft'
       OR wp_posts.post_status = 'pending'
       OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY 
    wp_postmeta.meta_value >= 20180104 ASC,
    wp_postmeta.meta_value < 20180104 DESC
LIMIT 0,
      8
[SQL] pobierz, plaintext 

[trueblue]

Może tak?

[SQL] pobierz, plaintext 
ORDER BY 
    (CASE WHEN wp_postmeta.meta_value >= 20180104 THEN wp.postmeta.meta_value END) ASC,
    (CASE WHEN wp_postmeta.meta_value < 20180104 THEN wp.postmeta.meta_value END) DESC
[SQL] pobierz, plaintext 

[SmokAnalog]

Można dużo prościej:

[SQL] pobierz, plaintext 
ORDER BY `wp_postmeta`.`meta_value` < UNIX_TIMESTAMP(),
         ABS(`wp_postmeta`.`meta_value` - UNIX_TIMESTAMP())
[SQL] pobierz, plaintext 

Albo chyba wydajniej:

[SQL] pobierz, plaintext 
ORDER BY ABS(`wp_postmeta`.`meta_value` - UNIX_TIMESTAMP()) - (`wp_postmeta`.`meta_value` >= UNIX_TIMESTAMP()) * 9999999999
[SQL] pobierz, plaintext