SQL: Need to select items by different conditions : <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>
