title: "Cannot convert to a SELECT statement" What does this mean
body: <p>I'm trying to make our mySQL database run faster and I've analyzed our slow query log and the most common slow query is this:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `wp_bad_behavior` (
      `id` INT(11) NOT NULL auto_increment,
      `ip` TEXT NOT NULL,
      `date` DATETIME NOT NULL default '0000-00-00 00:00:00',
      `request_method` TEXT NOT NULL,
      `request_uri` TEXT NOT NULL,
      `server_protocol` TEXT NOT NULL,
      `http_headers` TEXT NOT NULL,
      `user_agent` TEXT NOT NULL,
      `request_entity` TEXT NOT NULL,
      `key` TEXT NOT NULL,
      INDEX (`ip`(15)),
      INDEX (`user_agent`(10)),
      PRIMARY KEY (`id`) );
  </code></pre>
  
  <p>I'm trying to understand why this query keeps getting called because after the table is setup it should not keep happening. </p>
  
  <p>The EXPLAIN result for this is: Cannot convert to a SELECT statement.</p>
  
  <p>Any ideas on this would be fantastic!</p>
  
  <p>Paul</p>