title: #1222 - The used SELECT statements have a different number of columns UNION error
body: <p>I spend over two days fixing this query ,but i cannot find where my problem is.My ques is that the last UNION is causing some errors ,without it everything works perfect.
  However in the last UNION i don't have different number of columns as MYSQL error state.
  Here is the query :</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>INSERT INTO email_queues (queueid, queuetype, ownerid, processed, recipient)
  SELECT DISTINCT 323,
                  'export',
                  1,
                  0,
                  subscriberid
  FROM
    (SELECT DISTINCT subscribers.subscriberid AS subscriberid
     FROM email_list_subscribers AS subscribers
     JOIN email_lists AS lists ON lists.listid = subscribers.listid
     AND lists.listid IN (34)
     WHERE subscribers.listid IN (34)
       AND ((subscribers.emailaddress LIKE '%a%'))
     UNION SELECT DISTINCT subscribers.subscriberid AS subscriberid
     FROM email_list_subscribers AS subscribers
     JOIN email_lists AS lists ON lists.listid = subscribers.listid
     AND lists.listid IN (37)
     WHERE subscribers.listid IN (37)
       AND ((subscribers.emailaddress LIKE '%kim%'))) AS T1
  WHERE subscriberid NOT IN
      (SELECT DISTINCT subscribers.subscriberid AS subscriberid
       FROM email_list_subscribers AS subscribers
       JOIN email_lists AS lists ON lists.listid = subscribers.listid
       AND lists.listid IN (37,
                            34)
       WHERE subscribers.listid IN (37,
                                    34)
         AND ((subscribers.emailaddress LIKE '%a%'
               OR subscribers.emailaddress LIKE '%kim%')))
  UNION
  SELECT DISTINCT subscribers.subscriberid AS subscriberid
  FROM email_list_subscribers AS subscribers
  JOIN email_lists AS lists ON lists.listid = subscribers.listid
  AND lists.listid IN (33)
  WHERE subscribers.listid IN (33)
    AND ((subscribers.emailaddress LIKE '%v%'))</code></pre>
  </div>
  </div>
  </p>