title: MySQL Invalid query: Too high level of nesting for select
body: <p>I switched the code to Andrews solution:</p>
  
  <pre><code>SELECT s1.biz_name, s1.biz_info, s1.e_address, s1.e_city, s1.e_state,
      s1.e_postal, s1.e_zip_full, s1.loc_LAT_centroid, s1.loc_LONG_centroid,
      s1.biz_phone, s1.biz_phone_ext, s1.biz_fax, s1.biz_email, s1.web_url,
      s2.upc as upc2, s2.retailprice as retailprice2, s2.dollar_sales as
      dollar_sales2, s2.dollar_sales_ly as dollar_sales_ly2, s2.todaydate as
      todaydate2, s2.datetimesql as datetimesql2, s2.shelfposition as
      shelfposition2, s2.reg_sale as reg_sale2, s2.representative as
      representative2, s2.notes as notes2, s3.upc as upc3, s3.retailprice as
      retailprice3, s3.dollar_sales as dollar_sales3, s3.dollar_sales_ly as
      dollar_sales_ly3, s3.todaydate as todaydate3, s3.datetimesql as
      datetimesql3, s3.shelfposition as shelfposition3, s3.reg_sale as reg_sale3,
      s3.representative as representative3, s3.notes as notes3, s4.upc as upc4,
      s4.retailprice as retailprice4, s4.dollar_sales as dollar_sales4,
      s4.dollar_sales_ly as dollar_sales_ly4, s4.todaydate as todaydate4,
      s4.datetimesql as datetimesql4, s4.shelfposition as shelfposition4,
      s4.reg_sale as reg_sale4, s4.representative as representative4, s4.notes as
      notes4, s5.upc as upc5, s5.retailprice as retailprice5, s5.dollar_sales as
      dollar_sales5, s5.dollar_sales_ly as dollar_sales_ly5, s5.todaydate as
      todaydate5, s5.datetimesql as datetimesql5, s5.shelfposition as
      shelfposition5, s5.reg_sale as reg_sale5, s5.representative as
      representative5, s5.notes as notes5 
  FROM allStores AS s1 
  LEFT OUTER JOIN storeCheckRecords AS s2
      ON s1.e_address = s2.e_address AND s2.upc = '650637119004' 
  LEFT OUTER JOIN storeCheckRecords AS s3 
      ON s1.e_address = s3.e_address AND s3.upc = '650637119011' 
  LEFT OUTER JOIN storeCheckRecords AS s4 
      ON s1.e_address = s4.e_address AND s4.upc = '650637374007' 
  LEFT OUTER JOIN storeCheckRecords AS s5 
      ON s1.e_address = s5.e_address AND s5.upc = '650637374014' 
  WHERE  s2.e_address IS NOT NULL
      OR s3.e_address IS NOT NULL
      OR s4.e_address IS NOT NULL
      OR s5.e_address IS NOT NULL
  </code></pre>
  
  <p>Here is the new error: Invalid query: Too many tables; MySQL can only use 61 tables in a join</p>
  
  <p>Any other ideas?  Thanks for the help.</p>