SELECT order_date FROM (
SELECT
  @cdate := date_add( @cdate, INTERVAL - 1 DAY ) AS order_date 
FROM
  (
  SELECT
    @cdate := date_add( DATE_FORMAT( order_date, '%Y-%m-%d' ), INTERVAL + 1 DAY ) 
  FROM
    (
    SELECT
      @xi := @xi + 1 AS xc,
      '2024-12-31' AS order_date 
    FROM
      ( SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 ) xc1,
      ( SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 ) xc2,
      ( SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 ) xc3,
      ( SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 ) xc4,
      ( SELECT @xi := 0 ) xc0 
    ) tmp1 
  ) AS t
) AS a WHERE order_date BETWEEN '2024-01-01' AND '2024-12-31'