title: Multiple table query pagination and serach returing results of all tables but not from main table if they have nothing from other tables
body: <p>Here’s what I have :</p>
  
  <p>I have table 1 which is the <code>parties</code> table. It lists all the parties that are scheduled for the month. </p>
  
  <p>I have 4 other tables, each contains the type of party favours that we use.</p>
  
  <pre><code>party_toys
  party_drinks
  party_foods
  party_balloons
  </code></pre>
  
  <p>I need to query all parties that start this coming Saturday and list them back until the beginning of the year.</p>
  
  <p>I have accomplished this.</p>
  
  <p>What I need to do is figure out how to search but the party name from parties table and search all the party favours tables and list the results. </p>
  
  <p>Still sorted this Saturday to the beginning of the year and  filter out parties which we do not have any favours.</p>
  
  <p>Currently I can search only by party name from the parties table. I can’t figure out how to search all of them at the same time.</p>
  
  <p>I also need to paginate all of these.</p>
  
  <p>I currently have pagination working but it currently lists everything including the parties that have no favours assigned.</p>
  
  <p>I am stuck. Does this make sense?</p>
  
  <h2>Structure</h2>
  
  <p>For the parties table: </p>
  
  <pre><code>| party_id | parent_id | party_title | party_description | party_start | party finish |
  </code></pre>
  
  <p>For the party_drinks table:</p>
  
  <pre><code>| party_id | drink_id | drink_title | drink_notes |
  </code></pre>
  
  <p>For the party_foods table:</p>
  
  <pre><code>| party_id | food_id | food_title | food_notes |
  </code></pre>
  
  <p>For the party_toys table:</p>
  
  <pre><code>| party_id | toy_id | toy_title | toy_notes |
  </code></pre>
  
  <p>For the party_balloons table:</p>
  
  <pre><code>| party_id | balloon_id | ballon_title | balloon_notes |
  </code></pre>