title: Select last date and all dates in the future
body: <p>I'd like to select only the nearest date in the past and all the dates in the future.</p>
  
  <p>I reach a result with the following query, but the results are side by side instead row per row.</p>
  
  <p>How should I modifiy my query?</p>
  
  <pre><code>SELECT t1.*, t2.*
  FROM
      (SELECT *
          FROM table1
       WHERE from_p &lt;= NOW()
          AND prod = 3000
       ORDER BY from_p DESC
       LIMIT 1) AS t1
  JOIN
      (SELECT *
          FROM table1
       WHERE from_p &gt;= NOW()
          AND prod = 3000
       ORDER BY from_p DESC
      ) AS t2
  </code></pre>