title: SQL: Need to select items by different conditions
body: <p><strong>My table looks like this -</strong>
  <a href="https://i.stack.imgur.com/yhpqJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yhpqJ.png" alt="enter image description here"></a></p>
  
  <p><strong>Explanation</strong><br>
  I'm working on an online shop that sells <strong>tours</strong> and <strong>spa</strong>. I'm showing all together on one page.</p>
  
  <p></p>
  
  <p><strong>What I need to select?</strong><br>
  1. All spa products (based on "Spa" column), no conditions.<br>
  2. All parent tours that have children with an upcoming date.</p>
  
  <p></p>
  
  <p><strong>Meaning</strong><br>
  Products ID 1, 4, 5.</p>
  
  <p></p>
  
  <p><strong>Why?</strong><br>
  Product 6 have a child, but from 1999. And although product 1 have one child at 2000, it has another one in 2017. All spa products are selected by default, without conditions.</p>
  
  <p><br><i>I hope I made my question clear as I could. I would appreciate any help, my SQL is really bad.</i></p>