title: Error SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=#
body: <p>I am facing a problem with my query ... </p>
  
  <pre><code>SELECT 
  keywords.keyword,
  keywords.keyid,
  sources.s_title,
  sources.s_disc,
  sources.s_link,
  sources.sourceid,
  sources.s_link
  FROM link_ks
  INNER JOIN keywords ON link_ks.keyid = keywords.keyid
  INNER JOIN sources ON link_ks.sourceid = sources.sourceid
  INNER JOIN thumbsup_items ON link_ks.sourceid = thumbsup_items.name
  WHERE link_ks.keyid = :keyid 
  order by thumbsup_items.votes_up desc,thumbsup_items.votes_down asc,(thumbsup_items.votes_up+thumbsup_items.votes_down) desc
  </code></pre>
  
  <p>Every thing was good when database was small but as database become big I am getting this error </p>
  
  <pre><code> The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET
   SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
  </code></pre>
  
  <p>But when I remove </p>
  
  <pre><code> order by thumbsup_items.votes_up desc,thumbsup_items.votes_down asc,
  (thumbsup_items.votes_up+thumbsup_items.votes_down) desc
  </code></pre>
  
  <p>Problem gets solved ... But <code>order by</code> is important for this query ...</p>
  
  <p>is there any other way to write this query or how can I solve this problem ??</p>