title: FORCE INDEX in MySQL - where do I put it?
body: <p>I have the following MySQL query that works perfectly fine. Except that I need to add a <code>FORCE INDEX</code> and I'm unsure on where I have to do this. I tried just about every location and always receive a MySQL error. What am I doing wrong?</p>
  <p>Here is the original query:</p>
  <pre><code>$sql_select_recent_items = $db-&gt;query(&quot;SELECT * FROM (SELECT owner_id, product_id, start_time, price, currency, name, closed, active, approved, deleted, creation_in_progress FROM db_products ORDER BY start_time DESC) as resultstable
  WHERE resultstable.closed=0 AND resultstable.active=1 AND resultstable.approved=1 AND resultstable.deleted=0 AND resultstable.creation_in_progress=0
  GROUP BY resultstable.owner_id
  ORDER BY start_time DESC&quot;);
  </code></pre>
  <p>The query is constructed this way so that I can do the <code>ORDER BY</code> before the <code>GROUP BY</code>, in case you're wondering.</p>
  <p>What I need to add is:</p>
  <pre><code>FORCE INDEX (products_start_time)
  </code></pre>
  <p>I tried it just about everywhere without success, which leads me to believe that there's something more complex that I'm missing?</p>