title: Why The connection was reset? Joomla & MySQL
body: <pre><code>SELECT t1.id,t1.tx_id,t1.tx_date,t1.bx_date,t1.method,t1.theater_id,t1.showtime_id,t1.category_id,t1.amount,t1.fname,t1.status,t1.mobile,(CASE WHEN (t4.type = '1') THEN ( (t1.full_tickets * 2 ) + (t1.half_tickets)) ELSE ( t1.full_tickets + t1.half_tickets ) END) as no_seats ,u.username FROM 'reservation` as t1 LEFT JOIN `theatercategories` as t4 ON t1.category_id=t4.id JOIN `users` AS u ON u.id = t1.user_id WHERE t1.bx_date &gt;= '2012-08-01' AND t1.bx_date &lt;= '2012-08-31' ORDER BY t1.id desc
  </code></pre>
  
  <p>Above query returns "<code>The connection was reset</code>" error. </p>
  
  <p>It loads 75,000 records(75,195 total, Query took 15.2673 sec). I use MYSQL with Joomla. What seemes be the issue ?</p>
  
  <p>Please guide me. Thanks</p>