SELECT `businesses_businessmeta`.* FROM `businesses_businessmeta` INNER JOIN `businesses_businessmeta__categories` ON (`businesses_businessmeta`.`id` = `businesses_businessmeta__categories`.`business_id`) WHERE (`businesses_businessmeta__categories`.`state_id` = 8  AND `businesses_businessmeta__categories`.`category_id` = 1555  AND `businesses_businessmeta__categories`.`city_id` = 6437  AND `businesses_businessmeta`.`status` >= 10  AND `businesses_businessmeta__categories`.`country_id` = 'us' ) ORDER BY `businesses_businessmeta`.`status` DESC LIMIT 55\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: businesses_businessmeta__categories
         type: ref
possible_keys: business_id,idx_category2,idx_category
          key: idx_category2
      key_len: 18
          ref: const,const,const,const
         rows: 187
        Extra: Using where; Using temporary; Using filesort
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: businesses_businessmeta
         type: eq_ref
possible_keys: PRIMARY,idx_status
          key: PRIMARY
      key_len: 4
          ref: loadedweb_us_iplatform.businesses_businessmeta__categories.business_id
         rows: 1
        Extra: Using where
2 rows in set (0.00 sec)


----------------------------------------+
| businesses_businessmeta__categories | CREATE TABLE `businesses_businessmeta__categories` (
  `id` int(11) NOT NULL auto_increment,
  `business_id` int(10) unsigned default NULL,
  `category_id` int(10) unsigned default NULL,
  `country_id` char(2) default NULL,
  `state_id` int(10) unsigned default NULL,
  `city_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `business_id` (`business_id`,`category_id`),
  KEY `idx_category2` (`country_id`,`state_id`,`city_id`,`category_id`),
  KEY `idx_category` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13153075 DEFAULT CHARSET=latin1 |

| businesses_businessmeta | CREATE TABLE `businesses_businessmeta` (
  `business_id` char(32) character set latin1 default NULL,
  `id` int(10) unsigned NOT NULL auto_increment,
  `status` smallint(6) NOT NULL,
  `priority` int(11) default '0',
  `country_id` char(2) default NULL,
  `state_id` int(10) unsigned default NULL,
  `state_slug` varchar(32) character set latin1 NOT NULL,
  `city_id` int(10) unsigned default NULL,
  `city_slug` varchar(32) character set latin1 NOT NULL,
  `name` varchar(128) NOT NULL,
  `description` longtext character set latin1,
  `slug` varchar(128) character set latin1 NOT NULL,
  `address` varchar(255) character set latin1 default NULL,
  `zip_code` varchar(16) character set latin1 NOT NULL,
  `phone` varchar(20) character set latin1 default NULL,
  `fax` varchar(20) character set latin1 default NULL,
  `url` varchar(255) character set latin1 default NULL,
  `categories` longtext character set latin1 NOT NULL,
  `aliases` varchar(255) character set latin1 default NULL,
  `date_added` datetime NOT NULL,
  `date_changed` datetime NOT NULL,
  `photo_image` varchar(128) character set latin1 default NULL,
  `photo_label` varchar(64) character set latin1 default NULL,
  `photo_id` int(10) unsigned default NULL,
  `ratings_votes` int(10) unsigned NOT NULL,
  `ratings_score` int(11) NOT NULL,
  `tags` varchar(256) default NULL,
  `data` text character set latin1,
  `old_state_id` char(32) character set latin1 default NULL,
  `coords` point NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `city_id` (`city_id`,`slug`),
  UNIQUE KEY `idx_business_id` (`business_id`),
  KEY `phone` (`phone`),
  KEY `date_added` (`date_added`),
  KEY `date_changed` (`date_changed`),
  KEY `idx_business` (`business_id`,`status`),
  KEY `idx_location` (`country_id`,`state_id`,`city_id`),
  KEY `idx_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=12963792 DEFAULT CHARSET=utf8 | 

+- TEMPORARY
   table          temporary(businesses_businessmeta__categories,businesses_businessmeta)
   +- JOIN
      +- Filter with WHERE
      |  +- Bookmark lookup
      |     +- Table
      |     |  table          businesses_businessmeta
      |     |  possible_keys  PRIMARY,idx_status
      |     +- Unique index lookup
      |        key            businesses_businessmeta->PRIMARY
      |        possible_keys  PRIMARY,idx_status
      |        key_len        4
      |        ref            loadedweb_us_iplatform.businesses_businessmeta__categories.business_id
      |        rows           1
      +- Filter with WHERE
         +- Bookmark lookup
            +- Table
            |  table          businesses_businessmeta__categories
            |  possible_keys  business_id,idx_category2,idx_category
            +- Index lookup
               key            businesses_businessmeta__categories->idx_category2
               possible_keys  business_id,idx_category2,idx_category
               key_len        18
               ref            const,const,const,const
               rows           187