SELECT order_date_first, order_date_second FROM (
    SELECT order_id AS order_id_first, order_date AS order_date_first,
        orders_two.order_id_second, orders_two.order_date_second
    FROM orders AS orders_one
        JOIN
    (SELECT order_id AS order_id_second, order_date AS order_date_second FROM orders) AS orders_two
    ON orders_one.order_id = orders_two.order_id_second WHERE order_date = '2013-07-25 00:00:00.0'
) AS joined_two_tables;