Warning (2): Undefined variable $error [CORE/cake/libs/cake_object.php, line 213]

        }

        echo $_this->_output($level, $error, $code, $helpCode, $description, $file, $line, $context);

Debugger::handleError() - CORE/cake/libs/debugger.php, line 223
CakeObject::cakeError() - CORE/cake/libs/cake_object.php, line 213
TopicDiscussionsController::index() - APP/controllers/topic_discussions_controller.php, line 14
CakeObject::dispatchMethod() - CORE/cake/libs/cake_object.php, line 126
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 247
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 211
[main] - APP/webroot/index.php, line 99

<pre class="cake-debug"> <a href='javascript:void(0);' onclick='document.getElementById("CakeStackTrace77").style.display = (document.getElementById("CakeStackTrace77").style.display == "none" ? "" : "none")'><b>Warning</b> (2)</a>: Undefined array key "Company" [<b>APP/views/layouts/default.ctp</b>, line <b>55</b>] </pre> <div id="CakeStackTrace77" class="cake-stack-trace" style="display: none;"><a href='javascript:void(0);' onclick='document.getElementById("CakeErrorCode77").style.display = (document.getElementById("CakeErrorCode77").style.display == "none" ? "" : "none")'>Code</a><div id="CakeErrorCode77" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000"> }</span></code> <code><span style="color: #000000"></span></code> <span class="code-highlight"><code><span style="color: #000000"> echo $_this->_output($level, $error, $code, $helpCode, $description, $file, $line, $context);</span></code></span> </pre></div><pre>Debugger::handleError() - CORE/cake/libs/debugger.php, line 223 include - APP/views/layouts/default.ctp, line 55 View::_render() - CORE/cake/libs/view/view.php, line 667 DebugView::_render() - CORE/plugins/debug_kit/views/debug.php, line 60 View::renderLayout() - CORE/cake/libs/view/view.php, line 457 View::render() - CORE/cake/libs/view/view.php, line 393 DebugView::render() - CORE/plugins/debug_kit/views/debug.php, line 80 Controller::render() - CORE/cake/libs/controller/controller.php, line 779 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 250 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 211 [main] - APP/webroot/index.php, line 99</pre></div> <pre class="cake-debug"> <a href='javascript:void(0);' onclick='document.getElementById("CakeStackTrace78").style.display = (document.getElementById("CakeStackTrace78").style.display == "none" ? "" : "none")'><b>Warning</b> (2)</a>: Trying to access array offset on value of type null [<b>APP/views/layouts/default.ctp</b>, line <b>55</b>] </pre> <div id="CakeStackTrace78" class="cake-stack-trace" style="display: none;"><a href='javascript:void(0);' onclick='document.getElementById("CakeErrorCode78").style.display = (document.getElementById("CakeErrorCode78").style.display == "none" ? "" : "none")'>Code</a><div id="CakeErrorCode78" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000"> }</span></code> <code><span style="color: #000000"></span></code> <span class="code-highlight"><code><span style="color: #000000"> echo $_this->_output($level, $error, $code, $helpCode, $description, $file, $line, $context);</span></code></span> </pre></div><pre>Debugger::handleError() - CORE/cake/libs/debugger.php, line 223 include - APP/views/layouts/default.ctp, line 55 View::_render() - CORE/cake/libs/view/view.php, line 667 DebugView::_render() - CORE/plugins/debug_kit/views/debug.php, line 60 View::renderLayout() - CORE/cake/libs/view/view.php, line 457 View::render() - CORE/cake/libs/view/view.php, line 393 DebugView::render() - CORE/plugins/debug_kit/views/debug.php, line 80 Controller::render() - CORE/cake/libs/controller/controller.php, line 779 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 250 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 211 [main] - APP/webroot/index.php, line 99</pre></div> | ...

COVID-19: En función de proteger a nuestros clientes y permitir que se practique adecuadamente el distanciamiento social sin perder el uso de sus cupones, hemos extendido la vigencia de los cupones aún vigentes que se vieron afectados por COVID-19 para poder ser canjeados.

Cupones con descuentos del 50-90% en los mejores lugares

Clic aquí para suscribirte a recibir nuestras ofertas

Cupón Club

San Salvador

Más Ciudades

7568-9447

Pagas $5 y consumes $12 en Burger Boss!

Sigue este tema

Page 1 de 1

margaritaargueta comentó on 6/6/11
cuantos cupones por mesa se pueden usar
comentó on 6/6/11
Hola margaritaargueta, no hay ningún restricción sobre cupones por mesa. Puedes usar hasta 2 por persona.
cibely comentó on 6/6/11
tienen fecha de vencimiento los cupones
AArteaga comentó on 8/6/11
Consumo de comida y bebibas verdad?, solo la propina es efectiva por separado?
comentó on 8/6/11
Hola AArteaga, si de comida y bebidas. Y exactamente solo la propina no es incluida.
cruzgua comentó on 9/6/11
Hola! Si yo voy con 7 personas y llevo 3 cupones cuenta?
comentó on 9/6/11
Hola cruzgua! Si cuenta!
youngwicks comentó on 15/7/11
hola me puede brindar el telefono o decirme cuales son los horarios, gracias ..

« Anterior Siguiente »

Session
Session
- Config
  - userAgentba15070f06aa4c878a6794410449d967
  - time1792627217
  - rand1912221228
  - timeout10
- city_attachment(empty)
- _Tokena:5:{s:3:"key";s:40:"0fcdc4d2ac8b2834f7a8677ba1e106d30fbfe369";s:7:"expires";i:1792621217;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}
Request
Request

Cake Params
- pass
  - 0147
- named
  - citySan-salvador
- controllertopic_discussions
- actionindex
- plugin(null)
- url
  - exthtml
  - urlSan-salvador/topic_discussions/index/147
- form(empty)
- isAjax(false)
- _Token
  - key0fcdc4d2ac8b2834f7a8677ba1e106d30fbfe369
  - expires1792621217
  - allowedControllers(empty)
  - allowedActions(empty)
  - disabledFields(empty)
- paging
  - TopicDiscussion
    - page1
    - current8
    - count8
    - prevPage(false)
    - nextPage(false)
    - pageCount1
    - defaults
      limit20
      step1
      conditions
      0
      TopicDiscussion.topic_id147
      contain
      Topic
      fields
      0Topic.name
      User
      0UserAvatar
      fields
      0User.user_type_id
      1User.username
      2User.id
      order
      TopicDiscussion.idasc
      recursive1
    - options
      page1
      limit20
      conditions
      0
      TopicDiscussion.topic_id147
      contain
      Topic
      fields
      0Topic.name
      User
      0UserAvatar
      fields
      0User.user_type_id
      1User.username
      2User.id
      order
      TopicDiscussion.idasc
      recursive1
$_GET
- urlSan-salvador/topic_discussions/index/147
Cookie
- Box
  - viewed
    - 0482
  - category
    - 31
- city_languagees
- city_slugSan-salvador
Current Route
- 0/:city/:controller/:action/*
- 1#^(?:/((?!app|pages|devs|images|cybersource_logs|translations|languages|user_cash_withdrawals|subscription_emails|user_openids|gift_users|credomatic_logs|temp_contacts|user_comments|companies|invoices|deal_sub_categories|authorizenet_docapture_logs|bp_transaction_types|user_permission_preferences|transaction_types|payment_gateways|city_suggestions|users|scheduled_emails|user_logins|crons|cities|email_segments|fraud_status_logs|business_suggestions|user_profiles|user_friends|fc_companies|topic_discussions|deal_user_coupons|subscriptions|transactions|fc_company_addresses|email_templates|banned_ips|cash_coupons|paypal_transaction_logs|company_addresses|fc_coupons|user_views|paypal_mobile_logs|deal_categories|countries|deal_users|bonus_point_transactions|states|contacts|payment_gateway_settings|deal_categories_subscriptions|topics_users|deals|cybersource_tokens|settings|topics|paypal_docapture_logs|user_payment_profiles|blocked_users|cash_coupon|company|fc_company|fc_coupon|fraud_status_log|deal|page|user|admin|deal_user|contactus|sitemap|robots|sitemap.xml|robots.txt|welcome_to_cupon_club)[^\/]*))(?:/([^\/]+))?(?:/([^\/]+))?(?:/(.*))?[\/]*$#
- 2
  - 0city
  - 1controller
  - 2action
- 3
  - plugin(null)
  - controller(null)
  - actionindex
- 4
  - city(?!app|pages|devs|images|cybersource_logs|translations|languages|user_cash_withdrawals|subscription_emails|user_openids|gift_users|credomatic_logs|temp_contacts|user_comments|companies|invoices|deal_sub_categories|authorizenet_docapture_logs|bp_transaction_types|user_permission_preferences|transaction_types|payment_gateways|city_suggestions|users|scheduled_emails|user_logins|crons|cities|email_segments|fraud_status_logs|business_suggestions|user_profiles|user_friends|fc_companies|topic_discussions|deal_user_coupons|subscriptions|transactions|fc_company_addresses|email_templates|banned_ips|cash_coupons|paypal_transaction_logs|company_addresses|fc_coupons|user_views|paypal_mobile_logs|deal_categories|countries|deal_users|bonus_point_transactions|states|contacts|payment_gateway_settings|deal_categories_subscriptions|topics_users|deals|cybersource_tokens|settings|topics|paypal_docapture_logs|user_payment_profiles|blocked_users|cash_coupon|company|fc_company|fc_coupon|fraud_status_log|deal|page|user|admin|deal_user|contactus|sitemap|robots|sitemap.xml|robots.txt|welcome_to_cupon_club)[^\/]*

Sql Log

Sql Logs

default

32 queries took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Setting`.`id`, `Setting`.`setting_category_id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`options`, `Setting`.`label`, `Setting`.`order`, `SettingCategory`.`id`, `SettingCategory`.`created`, `SettingCategory`.`modified`, `SettingCategory`.`name`, `SettingCategory`.`description`, `SiteLogo`.`id`, `SiteLogo`.`created`, `SiteLogo`.`modified`, `SiteLogo`.`class`, `SiteLogo`.`foreign_id`, `SiteLogo`.`filename`, `SiteLogo`.`dir`, `SiteLogo`.`mimetype`, `SiteLogo`.`filesize`, `SiteLogo`.`height`, `SiteLogo`.`width`, `SiteLogo`.`thumb`, `SiteLogo`.`description` FROM `settings` AS `Setting` LEFT JOIN `setting_categories` AS `SettingCategory` ON (`Setting`.`setting_category_id` = `SettingCategory`.`id`) LEFT JOIN `attachments` AS `SiteLogo` ON (`SiteLogo`.`foreign_id` = `Setting`.`id` AND `SiteLogo`.`class` = 'SiteLogo') WHERE 1 = 1

213

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Setting	ALL					213	100.00
1	SIMPLE	SettingCategory	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.Setting.setting_category_id	1	100.00	Using index condition
1	SIMPLE	SiteLogo	ref	foreign_id,class	foreign_id	8	cuponclu_playpen120111.Setting.id	1	100.00	Using where

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`Setting`.`id` AS `id`,`cuponclu_playpen120111`.`Setting`.`setting_category_id` AS `setting_category_id`,`cuponclu_playpen120111`.`Setting`.`name` AS `name`,`cuponclu_playpen120111`.`Setting`.`value` AS `value`,`cuponclu_playpen120111`.`Setting`.`description` AS `description`,`cuponclu_playpen120111`.`Setting`.`type` AS `type`,`cuponclu_playpen120111`.`Setting`.`options` AS `options`,`cuponclu_playpen120111`.`Setting`.`label` AS `label`,`cuponclu_playpen120111`.`Setting`.`order` AS `order`,`cuponclu_playpen120111`.`SettingCategory`.`id` AS `id`,`cuponclu_playpen120111`.`SettingCategory`.`created` AS `created`,`cuponclu_playpen120111`.`SettingCategory`.`modified` AS `modified`,`cuponclu_playpen120111`.`SettingCategory`.`name` AS `name`,`cuponclu_playpen120111`.`SettingCategory`.`description` AS `description`,`cuponclu_playpen120111`.`SiteLogo`.`id` AS `id`,`cuponclu_playpen120111`.`SiteLogo`.`created` AS `created`,`cuponclu_playpen120111`.`SiteLogo`.`modified` AS `modified`,`cuponclu_playpen120111`.`SiteLogo`.`class` AS `class`,`cuponclu_playpen120111`.`SiteLogo`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`SiteLogo`.`filename` AS `filename`,`cuponclu_playpen120111`.`SiteLogo`.`dir` AS `dir`,`cuponclu_playpen120111`.`SiteLogo`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`SiteLogo`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`SiteLogo`.`height` AS `height`,`cuponclu_playpen120111`.`SiteLogo`.`width` AS `width`,`cuponclu_playpen120111`.`SiteLogo`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`SiteLogo`.`description` AS `description` from `cuponclu_playpen120111`.`settings` `Setting` left join `cuponclu_playpen120111`.`setting_categories` `SettingCategory` on((`cuponclu_playpen120111`.`Setting`.`setting_category_id` = `cuponclu_playpen120111`.`SettingCategory`.`id`)) left join `cuponclu_playpen120111`.`attachments` `SiteLogo` on(((`cuponclu_playpen120111`.`SiteLogo`.`foreign_id` = `cuponclu_playpen120111`.`Setting`.`id`) and (`cuponclu_playpen120111`.`SiteLogo`.`class` = 'SiteLogo'))) where true

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'f83686cdddf7594d9415ce8c111708db'

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	cake_sessions		const	PRIMARY	PRIMARY	767	const	1	100.00

Level	Code	Message
Note	1003	/* select#1 */ select 'Config\|a:4:{s:9:"userAgent";s:32:"ba15070f06aa4c878a6794410449d967";s:4:"time";i:1792627217;s:4:"rand";i:1912221228;s:7:"timeout";i:10;}city_attachment\|s:0:"";_Token\|s:179:"a:5:{s:3:"key";s:40:"0fcdc4d2ac8b2834f7a8677ba1e106d30fbfe369";s:7:"expires";i:1792621217;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` from `cuponclu_playpen120111`.`cake_sessions` where true

SELECT `City`.`id`, `City`.`created`, `City`.`modified`, `City`.`country_id`, `City`.`state_id`, `City`.`language_id`, `City`.`name`, `City`.`slug`, `City`.`latitude`, `City`.`longitude`, `City`.`dma_id`, `City`.`county`, `City`.`code`, `City`.`deal_count`, `City`.`active_deal_count`, `City`.`is_approved`, `City`.`fb_user_id`, `City`.`fb_access_token`, `City`.`twitter_username`, `City`.`twitter_password`, `City`.`twitter_access_token`, `City`.`twitter_access_key`, `City`.`twitter_url`, `City`.`facebook_url`, `Attachment`.`id`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`class`, `Attachment`.`foreign_id`, `Attachment`.`filename`, `Attachment`.`dir`, `Attachment`.`mimetype`, `Attachment`.`filesize`, `Attachment`.`height`, `Attachment`.`width`, `Attachment`.`thumb`, `Attachment`.`description` FROM `cities` AS `City` LEFT JOIN `attachments` AS `Attachment` ON (`Attachment`.`foreign_id` = `City`.`id` AND `Attachment`.`class` = 'City') WHERE `City`.`slug` = 'San-salvador' AND `City`.`is_approved` = 1 LIMIT 1

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	City		ref	slug	slug	137	const	1	10.00	Using where
1	SIMPLE	Attachment		ref	foreign_id,class	foreign_id	8	cuponclu_playpen120111.City.id	1	100.00	Using where

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`City`.`id` AS `id`,`cuponclu_playpen120111`.`City`.`created` AS `created`,`cuponclu_playpen120111`.`City`.`modified` AS `modified`,`cuponclu_playpen120111`.`City`.`country_id` AS `country_id`,`cuponclu_playpen120111`.`City`.`state_id` AS `state_id`,`cuponclu_playpen120111`.`City`.`language_id` AS `language_id`,`cuponclu_playpen120111`.`City`.`name` AS `name`,`cuponclu_playpen120111`.`City`.`slug` AS `slug`,`cuponclu_playpen120111`.`City`.`latitude` AS `latitude`,`cuponclu_playpen120111`.`City`.`longitude` AS `longitude`,`cuponclu_playpen120111`.`City`.`dma_id` AS `dma_id`,`cuponclu_playpen120111`.`City`.`county` AS `county`,`cuponclu_playpen120111`.`City`.`code` AS `code`,`cuponclu_playpen120111`.`City`.`deal_count` AS `deal_count`,`cuponclu_playpen120111`.`City`.`active_deal_count` AS `active_deal_count`,`cuponclu_playpen120111`.`City`.`is_approved` AS `is_approved`,`cuponclu_playpen120111`.`City`.`fb_user_id` AS `fb_user_id`,`cuponclu_playpen120111`.`City`.`fb_access_token` AS `fb_access_token`,`cuponclu_playpen120111`.`City`.`twitter_username` AS `twitter_username`,`cuponclu_playpen120111`.`City`.`twitter_password` AS `twitter_password`,`cuponclu_playpen120111`.`City`.`twitter_access_token` AS `twitter_access_token`,`cuponclu_playpen120111`.`City`.`twitter_access_key` AS `twitter_access_key`,`cuponclu_playpen120111`.`City`.`twitter_url` AS `twitter_url`,`cuponclu_playpen120111`.`City`.`facebook_url` AS `facebook_url`,`cuponclu_playpen120111`.`Attachment`.`id` AS `id`,`cuponclu_playpen120111`.`Attachment`.`created` AS `created`,`cuponclu_playpen120111`.`Attachment`.`modified` AS `modified`,`cuponclu_playpen120111`.`Attachment`.`class` AS `class`,`cuponclu_playpen120111`.`Attachment`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`Attachment`.`filename` AS `filename`,`cuponclu_playpen120111`.`Attachment`.`dir` AS `dir`,`cuponclu_playpen120111`.`Attachment`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`Attachment`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`Attachment`.`height` AS `height`,`cuponclu_playpen120111`.`Attachment`.`width` AS `width`,`cuponclu_playpen120111`.`Attachment`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`Attachment`.`description` AS `description` from `cuponclu_playpen120111`.`cities` `City` left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = `cuponclu_playpen120111`.`City`.`id`) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'City'))) where ((`cuponclu_playpen120111`.`City`.`is_approved` = 1) and (`cuponclu_playpen120111`.`City`.`slug` = 'San-salvador')) limit 1

SELECT `BannedIp`.`id`, `BannedIp`.`created`, `BannedIp`.`modified`, `BannedIp`.`address`, `BannedIp`.`range`, `BannedIp`.`referer_url`, `BannedIp`.`reason`, `BannedIp`.`redirect`, `BannedIp`.`thetime`, `BannedIp`.`timespan` FROM `banned_ips` AS `BannedIp` WHERE ((`BannedIp`.`address` = '3628718375') OR (`BannedIp`.`range` = '3628718375') OR (((`BannedIp`.`address` >= '3628718375') AND (`BannedIp`.`range` <= '3628718375'))) OR (((`BannedIp`.`address` <= '3628718375') AND (`BannedIp`.`range` >= '3628718375')))) LIMIT 1

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	BannedIp		ALL	address,range				2	85.94	Using where

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`BannedIp`.`id` AS `id`,`cuponclu_playpen120111`.`BannedIp`.`created` AS `created`,`cuponclu_playpen120111`.`BannedIp`.`modified` AS `modified`,`cuponclu_playpen120111`.`BannedIp`.`address` AS `address`,`cuponclu_playpen120111`.`BannedIp`.`range` AS `range`,`cuponclu_playpen120111`.`BannedIp`.`referer_url` AS `referer_url`,`cuponclu_playpen120111`.`BannedIp`.`reason` AS `reason`,`cuponclu_playpen120111`.`BannedIp`.`redirect` AS `redirect`,`cuponclu_playpen120111`.`BannedIp`.`thetime` AS `thetime`,`cuponclu_playpen120111`.`BannedIp`.`timespan` AS `timespan` from `cuponclu_playpen120111`.`banned_ips` `BannedIp` where ((`cuponclu_playpen120111`.`BannedIp`.`address` = '3628718375') or (`cuponclu_playpen120111`.`BannedIp`.`range` = '3628718375') or ((`cuponclu_playpen120111`.`BannedIp`.`address` >= '3628718375') and (`cuponclu_playpen120111`.`BannedIp`.`range` <= '3628718375')) or ((`cuponclu_playpen120111`.`BannedIp`.`address` <= '3628718375') and (`cuponclu_playpen120111`.`BannedIp`.`range` >= '3628718375'))) limit 1

SELECT `Topic`.`name` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 147 LIMIT 1

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Topic		const	PRIMARY	PRIMARY	8	const	1	100.00

Level	Code	Message
Note	1003	/* select#1 */ select 'Pagas y consumes en Burger Boss!' AS `name` from `cuponclu_playpen120111`.`topics` `Topic` where true limit 1

SELECT `Topic`.`id`, `Topic`.`created`, `Topic`.`modified`, `Topic`.`topic_type_id`, `Topic`.`user_id`, `Topic`.`city_id`, `Topic`.`deal_id`, `Topic`.`name`, `Topic`.`slug`, `Topic`.`content`, `Topic`.`topic_discussion_count`, `Topic`.`last_replied_user_id`, `Topic`.`last_replied_time`, `Deal`.`id`, `Deal`.`created`, `Deal`.`modified`, `Deal`.`user_id`, `Deal`.`name`, `Deal`.`short_name`, `Deal`.`coupon_name`, `Deal`.`display_neighborhoodname`, `Deal`.`slug`, `Deal`.`bitly_short_url`, `Deal`.`description`, `Deal`.`private_note`, `Deal`.`original_price`, `Deal`.`discounted_price`, `Deal`.`start_date`, `Deal`.`end_date`, `Deal`.`sort_order`, `Deal`.`discount_percentage`, `Deal`.`discount_amount`, `Deal`.`savings`, `Deal`.`min_limit`, `Deal`.`max_limit`, `Deal`.`city_id`, `Deal`.`display_city_id`, `Deal`.`company_id`, `Deal`.`review`, `Deal`.`deal_user_count`, `Deal`.`payment_failed_count`, `Deal`.`buy_min_quantity_per_user`, `Deal`.`buy_max_quantity_per_user`, `Deal`.`deal_tipped_time`, `Deal`.`coupon_expiry_date`, `Deal`.`coupon_condition`, `Deal`.`coupon_highlights`, `Deal`.`comment`, `Deal`.`is_coupon_mail_sent`, `Deal`.`is_subscription_mail_sent`, `Deal`.`is_side_deal`, `Deal`.`deal_status_id`, `Deal`.`bonus_amount`, `Deal`.`commission_percentage`, `Deal`.`commission_percent_unused`, `Deal`.`vat_percent`, `Deal`.`payment1_amt`, `Deal`.`payment1_date`, `Deal`.`payment1_check_no`, `Deal`.`payment1_bank`, `Deal`.`payment1_comm`, `Deal`.`payment1_vat`, `Deal`.`payment1_info`, `Deal`.`payment1_comments`, `Deal`.`payment2_amt`, `Deal`.`payment2_date`, `Deal`.`payment2_check_no`, `Deal`.`payment2_bank`, `Deal`.`payment2_comm`, `Deal`.`payment2_vat`, `Deal`.`payment2_info`, `Deal`.`payment2_comments`, `Deal`.`payment3_amt`, `Deal`.`payment3_date`, `Deal`.`payment3_check_no`, `Deal`.`payment3_bank`, `Deal`.`payment3_comm`, `Deal`.`payment3_vat`, `Deal`.`payment3_info`, `Deal`.`payment3_comments`, `Deal`.`payment4_amt`, `Deal`.`payment4_date`, `Deal`.`payment4_check_no`, `Deal`.`payment4_bank`, `Deal`.`payment4_comm`, `Deal`.`payment4_vat`, `Deal`.`payment4_info`, `Deal`.`payment4_comments`, `Deal`.`first_payment_percent`, `Deal`.`added_coupons`, `Deal`.`total_commission_amount`, `Deal`.`total_purchased_amount`, `Deal`.`net_profit`, `Deal`.`meta_keywords`, `Deal`.`meta_description`, `Deal`.`bitly_short_url_subdomain`, `Deal`.`bitly_short_url_prefix`, `Deal`.`certainly`, `Deal`.`probably`, `Deal`.`unlikely_satisfied`, `Deal`.`unlikely_unsatisfied`, `Deal`.`survey_happy`, `Deal`.`survey_fair`, `Deal`.`survey_sad`, `Deal`.`salesman`, `Deal`.`zone`, `Deal`.`industry`, `Deal`.`category_id`, `Deal`.`sub_category_id`, `Deal`.`gender`, `Deal`.`neighborhood_id`, `Deal`.`sales_projection`, `Deal`.`facebook_description`, `Deal`.`facebook_title` FROM `topics` AS `Topic` LEFT JOIN `deals` AS `Deal` ON (`Topic`.`deal_id` = `Deal`.`id`) WHERE `Topic`.`id` = 147 LIMIT 1

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Topic		const	PRIMARY	PRIMARY	8	const	1	100.00
1	SIMPLE	Deal		const	PRIMARY	PRIMARY	8	const	0	0.00	unique row not found

Level

Code

Message

Note

1003

/* select#1 */ select '147' AS `id`,'2011-06-06 14:18:08' AS `created`,'2011-06-06 14:18:08' AS `modified`,'1' AS `topic_type_id`,'1' AS `user_id`,'42553' AS `city_id`,'138' AS `deal_id`,'Pagas y consumes en Burger Boss!' AS `name`,'pagas--y-consumes--en-burger-boss!' AS `slug`,'

Mientras, tu “boss” te exige cualquier tipo de cosas irrazonables como que llegues a trabajar a tiempo, y que no uses pijamas en la oficina, el Burger Boss solo te pide que sostengas tu hamburguesa de tal manera que evites tirar montos excesivos de guacamole y Ketchup chipotle al piso. Ven a la oficina del Burger Boss con la oferta de hoy: Pagas y consumes en Burger Boss!

El Burger Boss no subió al nivel de CEO de hamburguesas por meramente ponerle carne molida a un pan. Mientras otros siguen a la mara como si fueran ovejas, El Burger Boss crea recetas innovadoras de hamburguesas constantemente. El Burger Boss no es una oveja, y tampoco lo son sus hamburguesas, que, de hecho, son hechas de vacas. Aquí están algunas de nuestras preferidas:

The Pancho Burger

The Pancho Burger le da a tu boca un agradable golpe uno-dos, alternando jalapeños ardientes con calmante guacamole. Agrega el queso fundido y las cebollas salteadas y tienes una combinación de sabores tan espectacular que tus papilas gustativas literalmente te mandarán una nota de agradecimiento escrita a mano.

La Gaucha

Si andas buscando el sabor de de Argentina, prueba La Gaucha, ché. Esta delicia de las pampas consiste en una torta de carne de res molida y chorizo argentino montada por chimichurri hecho en casa y cebollas moradas. No te sorprendas si te encuentras bailando tango, hablando con un acento raro y creyéndote dueño de la copa mundial.

El Guanaco

Este chorizo masivo viene cubierto de guacamole, frijol y queso. Fue nombrada por el salvaje primo de la alpaca común porque es tan grande que después de comerlo te sientes como si hubiera comido un guanaco entero.

Además de estes tres ejemplares de la innovación y vanguardismo gastromico que lo define, Burger Boss te ofrece una variedad de hotdogs, entradas y hasta ensaladas. Cada plato viene con tu elección de papas fritas –o las rectas o las torcidas- o wedges.

Si tu boss no te alimenta, Burger Boss SI lo hará, y con gran estilo!!

' AS `content`,'8' AS `topic_discussion_count`,'3190' AS `last_replied_user_id`,'2011-07-15 18:04:55' AS `last_replied_time`,NULL AS `id`,NULL AS `created`,NULL AS `modified`,NULL AS `user_id`,NULL AS `name`,NULL AS `short_name`,NULL AS `coupon_name`,NULL AS `display_neighborhoodname`,NULL AS `slug`,NULL AS `bitly_short_url`,NULL AS `description`,NULL AS `private_note`,NULL AS `original_price`,NULL AS `discounted_price`,NULL AS `start_date`,NULL AS `end_date`,NULL AS `sort_order`,NULL AS `discount_percentage`,NULL AS `discount_amount`,NULL AS `savings`,NULL AS `min_limit`,NULL AS `max_limit`,NULL AS `city_id`,NULL AS `display_city_id`,NULL AS `company_id`,NULL AS `review`,NULL AS `deal_user_count`,NULL AS `payment_failed_count`,NULL AS `buy_min_quantity_per_user`,NULL AS `buy_max_quantity_per_user`,NULL AS `deal_tipped_time`,NULL AS `coupon_expiry_date`,NULL AS `coupon_condition`,NULL AS `coupon_highlights`,NULL AS `comment`,NULL AS `is_coupon_mail_sent`,NULL AS `is_subscription_mail_sent`,NULL AS `is_side_deal`,NULL AS `deal_status_id`,NULL AS `bonus_amount`,NULL AS `commission_percentage`,NULL AS `commission_percent_unused`,NULL AS `vat_percent`,NULL AS `payment1_amt`,NULL AS `payment1_date`,NULL AS `payment1_check_no`,NULL AS `payment1_bank`,NULL AS `payment1_comm`,NULL AS `payment1_vat`,NULL AS `payment1_info`,NULL AS `payment1_comments`,NULL AS `payment2_amt`,NULL AS `payment2_date`,NULL AS `payment2_check_no`,NULL AS `payment2_bank`,NULL AS `payment2_comm`,NULL AS `payment2_vat`,NULL AS `payment2_info`,NULL AS `payment2_comments`,NULL AS `payment3_amt`,NULL AS `payment3_date`,NULL AS `payment3_check_no`,NULL AS `payment3_bank`,NULL AS `payment3_comm`,NULL AS `payment3_vat`,NULL AS `payment3_info`,NULL AS `payment3_comments`,NULL AS `payment4_amt`,NULL AS `payment4_date`,NULL AS `payment4_check_no`,NULL AS `payment4_bank`,NULL AS `payment4_comm`,NULL AS `payment4_vat`,NULL AS `payment4_info`,NULL AS `payment4_comments`,NULL AS `first_payment_percent`,NULL AS `added_coupons`,NULL AS `total_commission_amount`,NULL AS `total_purchased_amount`,NULL AS `net_profit`,NULL AS `meta_keywords`,NULL AS `meta_description`,NULL AS `bitly_short_url_subdomain`,NULL AS `bitly_short_url_prefix`,NULL AS `certainly`,NULL AS `probably`,NULL AS `unlikely_satisfied`,NULL AS `unlikely_unsatisfied`,NULL AS `survey_happy`,NULL AS `survey_fair`,NULL AS `survey_sad`,NULL AS `salesman`,NULL AS `zone`,NULL AS `industry`,NULL AS `category_id`,NULL AS `sub_category_id`,NULL AS `gender`,NULL AS `neighborhood_id`,NULL AS `sales_projection`,NULL AS `facebook_description`,NULL AS `facebook_title` from `cuponclu_playpen120111`.`topics` `Topic` left join `cuponclu_playpen120111`.`deals` `Deal` on(multiple equal('138', NULL)) where true limit 1

SELECT `Deal`.`id`, `Deal`.`created`, `Deal`.`modified`, `Deal`.`user_id`, `Deal`.`name`, `Deal`.`short_name`, `Deal`.`coupon_name`, `Deal`.`display_neighborhoodname`, `Deal`.`slug`, `Deal`.`bitly_short_url`, `Deal`.`description`, `Deal`.`private_note`, `Deal`.`original_price`, `Deal`.`discounted_price`, `Deal`.`start_date`, `Deal`.`end_date`, `Deal`.`sort_order`, `Deal`.`discount_percentage`, `Deal`.`discount_amount`, `Deal`.`savings`, `Deal`.`min_limit`, `Deal`.`max_limit`, `Deal`.`city_id`, `Deal`.`display_city_id`, `Deal`.`company_id`, `Deal`.`review`, `Deal`.`deal_user_count`, `Deal`.`payment_failed_count`, `Deal`.`buy_min_quantity_per_user`, `Deal`.`buy_max_quantity_per_user`, `Deal`.`deal_tipped_time`, `Deal`.`coupon_expiry_date`, `Deal`.`coupon_condition`, `Deal`.`coupon_highlights`, `Deal`.`comment`, `Deal`.`is_coupon_mail_sent`, `Deal`.`is_subscription_mail_sent`, `Deal`.`is_side_deal`, `Deal`.`deal_status_id`, `Deal`.`bonus_amount`, `Deal`.`commission_percentage`, `Deal`.`commission_percent_unused`, `Deal`.`vat_percent`, `Deal`.`payment1_amt`, `Deal`.`payment1_date`, `Deal`.`payment1_check_no`, `Deal`.`payment1_bank`, `Deal`.`payment1_comm`, `Deal`.`payment1_vat`, `Deal`.`payment1_info`, `Deal`.`payment1_comments`, `Deal`.`payment2_amt`, `Deal`.`payment2_date`, `Deal`.`payment2_check_no`, `Deal`.`payment2_bank`, `Deal`.`payment2_comm`, `Deal`.`payment2_vat`, `Deal`.`payment2_info`, `Deal`.`payment2_comments`, `Deal`.`payment3_amt`, `Deal`.`payment3_date`, `Deal`.`payment3_check_no`, `Deal`.`payment3_bank`, `Deal`.`payment3_comm`, `Deal`.`payment3_vat`, `Deal`.`payment3_info`, `Deal`.`payment3_comments`, `Deal`.`payment4_amt`, `Deal`.`payment4_date`, `Deal`.`payment4_check_no`, `Deal`.`payment4_bank`, `Deal`.`payment4_comm`, `Deal`.`payment4_vat`, `Deal`.`payment4_info`, `Deal`.`payment4_comments`, `Deal`.`first_payment_percent`, `Deal`.`added_coupons`, `Deal`.`total_commission_amount`, `Deal`.`total_purchased_amount`, `Deal`.`net_profit`, `Deal`.`meta_keywords`, `Deal`.`meta_description`, `Deal`.`bitly_short_url_subdomain`, `Deal`.`bitly_short_url_prefix`, `Deal`.`certainly`, `Deal`.`probably`, `Deal`.`unlikely_satisfied`, `Deal`.`unlikely_unsatisfied`, `Deal`.`survey_happy`, `Deal`.`survey_fair`, `Deal`.`survey_sad`, `Deal`.`salesman`, `Deal`.`zone`, `Deal`.`industry`, `Deal`.`category_id`, `Deal`.`sub_category_id`, `Deal`.`gender`, `Deal`.`neighborhood_id`, `Deal`.`sales_projection`, `Deal`.`facebook_description`, `Deal`.`facebook_title` FROM `deals` AS `Deal` WHERE `Deal`.`id` = 138

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE										no matching row in const table

Level	Code	Message
Note	1003	/* select#1 */ select NULL AS `id`,NULL AS `created`,NULL AS `modified`,NULL AS `user_id`,NULL AS `name`,NULL AS `short_name`,NULL AS `coupon_name`,NULL AS `display_neighborhoodname`,NULL AS `slug`,NULL AS `bitly_short_url`,NULL AS `description`,NULL AS `private_note`,NULL AS `original_price`,NULL AS `discounted_price`,NULL AS `start_date`,NULL AS `end_date`,NULL AS `sort_order`,NULL AS `discount_percentage`,NULL AS `discount_amount`,NULL AS `savings`,NULL AS `min_limit`,NULL AS `max_limit`,NULL AS `city_id`,NULL AS `display_city_id`,NULL AS `company_id`,NULL AS `review`,NULL AS `deal_user_count`,NULL AS `payment_failed_count`,NULL AS `buy_min_quantity_per_user`,NULL AS `buy_max_quantity_per_user`,NULL AS `deal_tipped_time`,NULL AS `coupon_expiry_date`,NULL AS `coupon_condition`,NULL AS `coupon_highlights`,NULL AS `comment`,NULL AS `is_coupon_mail_sent`,NULL AS `is_subscription_mail_sent`,NULL AS `is_side_deal`,NULL AS `deal_status_id`,NULL AS `bonus_amount`,NULL AS `commission_percentage`,NULL AS `commission_percent_unused`,NULL AS `vat_percent`,NULL AS `payment1_amt`,NULL AS `payment1_date`,NULL AS `payment1_check_no`,NULL AS `payment1_bank`,NULL AS `payment1_comm`,NULL AS `payment1_vat`,NULL AS `payment1_info`,NULL AS `payment1_comments`,NULL AS `payment2_amt`,NULL AS `payment2_date`,NULL AS `payment2_check_no`,NULL AS `payment2_bank`,NULL AS `payment2_comm`,NULL AS `payment2_vat`,NULL AS `payment2_info`,NULL AS `payment2_comments`,NULL AS `payment3_amt`,NULL AS `payment3_date`,NULL AS `payment3_check_no`,NULL AS `payment3_bank`,NULL AS `payment3_comm`,NULL AS `payment3_vat`,NULL AS `payment3_info`,NULL AS `payment3_comments`,NULL AS `payment4_amt`,NULL AS `payment4_date`,NULL AS `payment4_check_no`,NULL AS `payment4_bank`,NULL AS `payment4_comm`,NULL AS `payment4_vat`,NULL AS `payment4_info`,NULL AS `payment4_comments`,NULL AS `first_payment_percent`,NULL AS `added_coupons`,NULL AS `total_commission_amount`,NULL AS `total_purchased_amount`,NULL AS `net_profit`,NULL AS `meta_keywords`,NULL AS `meta_description`,NULL AS `bitly_short_url_subdomain`,NULL AS `bitly_short_url_prefix`,NULL AS `certainly`,NULL AS `probably`,NULL AS `unlikely_satisfied`,NULL AS `unlikely_unsatisfied`,NULL AS `survey_happy`,NULL AS `survey_fair`,NULL AS `survey_sad`,NULL AS `salesman`,NULL AS `zone`,NULL AS `industry`,NULL AS `category_id`,NULL AS `sub_category_id`,NULL AS `gender`,NULL AS `neighborhood_id`,NULL AS `sales_projection`,NULL AS `facebook_description`,NULL AS `facebook_title` from `cuponclu_playpen120111`.`deals` `Deal` where multiple equal(138, NULL)

SELECT `TopicsUser`.`id`, `TopicsUser`.`user_id`, `TopicsUser`.`topic_id` FROM `topics_users` AS `TopicsUser` WHERE `TopicsUser`.`topic_id` = 147 AND `TopicsUser`.`user_id` IS NULL LIMIT 1

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE										Impossible WHERE

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`TopicsUser`.`id` AS `id`,`cuponclu_playpen120111`.`TopicsUser`.`user_id` AS `user_id`,`cuponclu_playpen120111`.`TopicsUser`.`topic_id` AS `topic_id` from `cuponclu_playpen120111`.`topics_users` `TopicsUser` where false limit 1

SELECT `User`.`id`, `User`.`created`, `User`.`modified`, `User`.`user_type_id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`referred_by_user_id`, `User`.`referral_agent_id`, `User`.`first_buy_discount_given`, `User`.`gift_user_id`, `User`.`fb_user_id`, `User`.`user_login_count`, `User`.`user_view_count`, `User`.`cookie_hash`, `User`.`cookie_time_modified`, `User`.`is_agree_terms_conditions`, `User`.`is_active`, `User`.`is_email_confirmed`, `User`.`signup_ip`, `User`.`last_login_ip`, `User`.`last_logged_in_time`, `User`.`available_balance_amount`, `User`.`wallet_currency`, `User`.`bonus_points`, `User`.`city`, `User`.`deal_notify_city_slug`, `User`.`blocked_amount`, `User`.`user_openid_count`, `User`.`is_openid_register`, `User`.`twitter_access_token`, `User`.`twitter_user_id`, `User`.`twitter_access_key`, `User`.`api_key`, `User`.`api_token`, `User`.`fb_access_token`, `User`.`dns`, `User`.`cim_profile_id`, `User`.`fraud_status`, `UserAvatar`.`id`, `UserAvatar`.`created`, `UserAvatar`.`modified`, `UserAvatar`.`class`, `UserAvatar`.`foreign_id`, `UserAvatar`.`filename`, `UserAvatar`.`dir`, `UserAvatar`.`mimetype`, `UserAvatar`.`filesize`, `UserAvatar`.`height`, `UserAvatar`.`width`, `UserAvatar`.`thumb`, `UserAvatar`.`description`, `Company`.`id`, `Company`.`created`, `Company`.`modified`, `Company`.`name`, `Company`.`slug`, `Company`.`address1`, `Company`.`address2`, `Company`.`user_id`, `Company`.`city_id`, `Company`.`state_id`, `Company`.`country_id`, `Company`.`phone`, `Company`.`zip`, `Company`.`url`, `Company`.`deal_count`, `Company`.`is_online_account`, `Company`.`is_company_profile_enabled`, `Company`.`company_profile`, `Company`.`latitude`, `Company`.`longitude`, `Company`.`map_zoom_level`, `Company`.`survey_average`, `Company`.`survey_responses`, `Company`.`half_stars`, `Company`.`percent_to_return` FROM `users` AS `User` LEFT JOIN `attachments` AS `UserAvatar` ON (`UserAvatar`.`foreign_id` = `User`.`id` AND `UserAvatar`.`class` = 'UserAvatar') LEFT JOIN `companies` AS `Company` ON (`Company`.`user_id` = `User`.`id`) WHERE `User`.`id` IS NULL LIMIT 1

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE										Impossible WHERE

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`User`.`id` AS `id`,`cuponclu_playpen120111`.`User`.`created` AS `created`,`cuponclu_playpen120111`.`User`.`modified` AS `modified`,`cuponclu_playpen120111`.`User`.`user_type_id` AS `user_type_id`,`cuponclu_playpen120111`.`User`.`username` AS `username`,`cuponclu_playpen120111`.`User`.`email` AS `email`,`cuponclu_playpen120111`.`User`.`password` AS `password`,`cuponclu_playpen120111`.`User`.`referred_by_user_id` AS `referred_by_user_id`,`cuponclu_playpen120111`.`User`.`referral_agent_id` AS `referral_agent_id`,`cuponclu_playpen120111`.`User`.`first_buy_discount_given` AS `first_buy_discount_given`,`cuponclu_playpen120111`.`User`.`gift_user_id` AS `gift_user_id`,`cuponclu_playpen120111`.`User`.`fb_user_id` AS `fb_user_id`,`cuponclu_playpen120111`.`User`.`user_login_count` AS `user_login_count`,`cuponclu_playpen120111`.`User`.`user_view_count` AS `user_view_count`,`cuponclu_playpen120111`.`User`.`cookie_hash` AS `cookie_hash`,`cuponclu_playpen120111`.`User`.`cookie_time_modified` AS `cookie_time_modified`,`cuponclu_playpen120111`.`User`.`is_agree_terms_conditions` AS `is_agree_terms_conditions`,`cuponclu_playpen120111`.`User`.`is_active` AS `is_active`,`cuponclu_playpen120111`.`User`.`is_email_confirmed` AS `is_email_confirmed`,`cuponclu_playpen120111`.`User`.`signup_ip` AS `signup_ip`,`cuponclu_playpen120111`.`User`.`last_login_ip` AS `last_login_ip`,`cuponclu_playpen120111`.`User`.`last_logged_in_time` AS `last_logged_in_time`,`cuponclu_playpen120111`.`User`.`available_balance_amount` AS `available_balance_amount`,`cuponclu_playpen120111`.`User`.`wallet_currency` AS `wallet_currency`,`cuponclu_playpen120111`.`User`.`bonus_points` AS `bonus_points`,`cuponclu_playpen120111`.`User`.`city` AS `city`,`cuponclu_playpen120111`.`User`.`deal_notify_city_slug` AS `deal_notify_city_slug`,`cuponclu_playpen120111`.`User`.`blocked_amount` AS `blocked_amount`,`cuponclu_playpen120111`.`User`.`user_openid_count` AS `user_openid_count`,`cuponclu_playpen120111`.`User`.`is_openid_register` AS `is_openid_register`,`cuponclu_playpen120111`.`User`.`twitter_access_token` AS `twitter_access_token`,`cuponclu_playpen120111`.`User`.`twitter_user_id` AS `twitter_user_id`,`cuponclu_playpen120111`.`User`.`twitter_access_key` AS `twitter_access_key`,`cuponclu_playpen120111`.`User`.`api_key` AS `api_key`,`cuponclu_playpen120111`.`User`.`api_token` AS `api_token`,`cuponclu_playpen120111`.`User`.`fb_access_token` AS `fb_access_token`,`cuponclu_playpen120111`.`User`.`dns` AS `dns`,`cuponclu_playpen120111`.`User`.`cim_profile_id` AS `cim_profile_id`,`cuponclu_playpen120111`.`User`.`fraud_status` AS `fraud_status`,`cuponclu_playpen120111`.`UserAvatar`.`id` AS `id`,`cuponclu_playpen120111`.`UserAvatar`.`created` AS `created`,`cuponclu_playpen120111`.`UserAvatar`.`modified` AS `modified`,`cuponclu_playpen120111`.`UserAvatar`.`class` AS `class`,`cuponclu_playpen120111`.`UserAvatar`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`UserAvatar`.`filename` AS `filename`,`cuponclu_playpen120111`.`UserAvatar`.`dir` AS `dir`,`cuponclu_playpen120111`.`UserAvatar`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`UserAvatar`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`UserAvatar`.`height` AS `height`,`cuponclu_playpen120111`.`UserAvatar`.`width` AS `width`,`cuponclu_playpen120111`.`UserAvatar`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`UserAvatar`.`description` AS `description`,`cuponclu_playpen120111`.`Company`.`id` AS `id`,`cuponclu_playpen120111`.`Company`.`created` AS `created`,`cuponclu_playpen120111`.`Company`.`modified` AS `modified`,`cuponclu_playpen120111`.`Company`.`name` AS `name`,`cuponclu_playpen120111`.`Company`.`slug` AS `slug`,`cuponclu_playpen120111`.`Company`.`address1` AS `address1`,`cuponclu_playpen120111`.`Company`.`address2` AS `address2`,`cuponclu_playpen120111`.`Company`.`user_id` AS `user_id`,`cuponclu_playpen120111`.`Company`.`city_id` AS `city_id`,`cuponclu_playpen120111`.`Company`.`state_id` AS `state_id`,`cuponclu_playpen120111`.`Company`.`country_id` AS `country_id`,`cuponclu_playpen120111`.`Company`.`phone` AS `phone`,`cuponclu_playpen120111`.`Company`.`zip` AS `zip`,`cuponclu_playpen120111`.`Company`.`url` AS `url`,`cuponclu_playpen120111`.`Company`.`deal_count` AS `deal_count`,`cuponclu_playpen120111`.`Company`.`is_online_account` AS `is_online_account`,`cuponclu_playpen120111`.`Company`.`is_company_profile_enabled` AS `is_company_profile_enabled`,`cuponclu_playpen120111`.`Company`.`company_profile` AS `company_profile`,`cuponclu_playpen120111`.`Company`.`latitude` AS `latitude`,`cuponclu_playpen120111`.`Company`.`longitude` AS `longitude`,`cuponclu_playpen120111`.`Company`.`map_zoom_level` AS `map_zoom_level`,`cuponclu_playpen120111`.`Company`.`survey_average` AS `survey_average`,`cuponclu_playpen120111`.`Company`.`survey_responses` AS `survey_responses`,`cuponclu_playpen120111`.`Company`.`half_stars` AS `half_stars`,`cuponclu_playpen120111`.`Company`.`percent_to_return` AS `percent_to_return` from `cuponclu_playpen120111`.`users` `User` left join `cuponclu_playpen120111`.`attachments` `UserAvatar` on(((`cuponclu_playpen120111`.`UserAvatar`.`class` = 'UserAvatar') and multiple equal(`cuponclu_playpen120111`.`UserAvatar`.`foreign_id`, `cuponclu_playpen120111`.`User`.`id`))) left join `cuponclu_playpen120111`.`companies` `Company` on((`cuponclu_playpen120111`.`Company`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) where false limit 1

SELECT COUNT(*) AS `count` FROM `topic_discussions` AS `TopicDiscussion` LEFT JOIN `topics` AS `Topic` ON (`TopicDiscussion`.`topic_id` = `Topic`.`id`) LEFT JOIN `users` AS `User` ON (`TopicDiscussion`.`user_id` = `User`.`id`) WHERE `TopicDiscussion`.`topic_id` = 147

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	TopicDiscussion	ref	topic_id	topic_id	8	const	7	100.00
1	SIMPLE	Topic	const	PRIMARY	PRIMARY	8	const	1	100.00	Using index
1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.TopicDiscussion.user_id	1	100.00	Using index

Level	Code	Message
Note	1003	/* select#1 */ select count(0) AS `count` from `cuponclu_playpen120111`.`topic_discussions` `TopicDiscussion` left join `cuponclu_playpen120111`.`topics` `Topic` on((`cuponclu_playpen120111`.`Topic`.`id` = 147)) left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`User`.`id` = `cuponclu_playpen120111`.`TopicDiscussion`.`user_id`)) where (`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` = 147)

SELECT `TopicDiscussion`.`id`, `TopicDiscussion`.`created`, `TopicDiscussion`.`modified`, `TopicDiscussion`.`topic_id`, `TopicDiscussion`.`user_id`, `TopicDiscussion`.`comment`, `TopicDiscussion`.`ip`, `TopicDiscussion`.`dns`, `Topic`.`name`, `User`.`user_type_id`, `User`.`username`, `User`.`id` FROM `topic_discussions` AS `TopicDiscussion` LEFT JOIN `topics` AS `Topic` ON (`TopicDiscussion`.`topic_id` = `Topic`.`id`) LEFT JOIN `users` AS `User` ON (`TopicDiscussion`.`user_id` = `User`.`id`) WHERE `TopicDiscussion`.`topic_id` = 147 ORDER BY `TopicDiscussion`.`id` asc LIMIT 20

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	TopicDiscussion	ref	topic_id	topic_id	8	const	7	100.00	Using filesort
1	SIMPLE	Topic	const	PRIMARY	PRIMARY	8	const	1	100.00
1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.TopicDiscussion.user_id	1	100.00

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`TopicDiscussion`.`id` AS `id`,`cuponclu_playpen120111`.`TopicDiscussion`.`created` AS `created`,`cuponclu_playpen120111`.`TopicDiscussion`.`modified` AS `modified`,`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` AS `topic_id`,`cuponclu_playpen120111`.`TopicDiscussion`.`user_id` AS `user_id`,`cuponclu_playpen120111`.`TopicDiscussion`.`comment` AS `comment`,`cuponclu_playpen120111`.`TopicDiscussion`.`ip` AS `ip`,`cuponclu_playpen120111`.`TopicDiscussion`.`dns` AS `dns`,`cuponclu_playpen120111`.`Topic`.`name` AS `name`,`cuponclu_playpen120111`.`User`.`user_type_id` AS `user_type_id`,`cuponclu_playpen120111`.`User`.`username` AS `username`,`cuponclu_playpen120111`.`User`.`id` AS `id` from `cuponclu_playpen120111`.`topic_discussions` `TopicDiscussion` left join `cuponclu_playpen120111`.`topics` `Topic` on((`cuponclu_playpen120111`.`Topic`.`id` = 147)) left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`User`.`id` = `cuponclu_playpen120111`.`TopicDiscussion`.`user_id`)) where (`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` = 147) order by `cuponclu_playpen120111`.`TopicDiscussion`.`id` limit 20