Unnamed
Posted by Anonymous
highlighted in
VB.net
- ActionScript
- ActionScript 3
- Bash
- Brainfuck
- C
- C#
- C++
- CSS
- Diff
- Django/Jinja
- ERB
- Erlang
- Genshi
- Genshi Text
- Gettext Catalog
- HTML
- INI
- Java
- JavaScript
- Lua
- Mako
- Myghty
- MySQL
- Objective-C
- Perl
- PHP
- Plaintext
- Python
- Python 3
- Python console session
- Python Traceback
- RHTML
- Ruby
- Ruby irb session
- Smarty
- SQL
- VB.net
- XML
- XSLT
SELECT DISTINCT `businesses_businessmeta`.*
FROM `businesses_businessmeta`
INNER JOIN `businesses_businessmeta__categories`
ON (`businesses_businessmeta`.`id` = `businesses_businessmeta__categories`.`business_id`)
INNER JOIN `businesses_category`
ON (`businesses_businessmeta__categories`.`category_id` = `businesses_category`.`id`)
INNER JOIN `businesses_featuredcategory_categories_m2m`
ON (`businesses_category`.`id` = `businesses_featuredcategory_categories_m2m`.`category_id`)
WHERE (`businesses_featuredcategory_categories_m2m`.`featuredcategory_id` = 11
AND `businesses_businessmeta__categories`.`state_id` = 51
AND `businesses_businessmeta__categories`.`city_id` = 33599
AND `businesses_businessmeta`.`status` >= 10
AND `businesses_businessmeta__categories`.`country_id` = 'ca' )
ORDER BY `businesses_businessmeta`.`status` DESC
LIMIT 55
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: businesses_featuredcategory_categories_m2m
type: ref
possible_keys: featuredcategory_id,category_id_refs_id_7fd351de
key: featuredcategory_id
key_len: 4
ref: const
rows: 7
Extra: Using index; Using temporary; Using filesort
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: businesses_category
type: eq_ref
possible_keys: PRIMARY,id
key: PRIMARY
key_len: 4
ref: ibegin_iplatform.businesses_featuredcategory_categories_m2m.category_id
rows: 1
Extra: Using index
*************************** 3. 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,ibegin_iplatform.businesses_category.id
rows: 1
Extra: Using where
*************************** 4. row ***************************
id: 1
select_type: SIMPLE
table: businesses_businessmeta
type: eq_ref
possible_keys: PRIMARY,idx_status
key: PRIMARY
key_len: 4
ref: ibegin_iplatform.businesses_businessmeta__categories.business_id
rows: 1
Extra: Using where
4 rows in set (0.00 sec)