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 hasta $12 de deliciosos (y saludables) yogurts congelados y smoothies en TCBY!

Sigue este tema

Page 1 de 1

aliciamelendez comentó on 27/4/11
Y cuando se termina la promo del IPAD??, porque prefiero esperar a que termine y que por referir a alguien me den $10 y no 5 como ha vuelto ahorita!!! me esperare igual que mi familia
jorgeregalado comentó on 27/4/11
Pero podes comprar el cupon y participar por el Ipad. Y referir y ganar los $5. Yo aproveche ayer y referí, me quedaron los $10. pero yo igual esperaria por los $10.
jorgeregalado comentó on 27/4/11
. Cada cupón que compras entre el 27 de abril y el 31 de mayo, automáticamente participas en la rifa. Es hasta el 31 de Mayo, viendo eso me quedaria con los $5...
comentó on 27/4/11
Hola Alicia y Jorge, gracias por tus comentarios pero no tenemos planes de volver a ofrecer $10 de saldo, aun después de la promo de iPad. Recomendamos que se aprovechen para un chance de tener un iPad2 nuevecito.
aliciamelendez comentó on 28/4/11
Ok comprare pero ayer lo tenian a $5.00 ahora a $5.04 porque si se puede saber???
aliciamelendez comentó on 28/4/11
Ok comprare pero ayer lo tenian a $5.00 ahora a $5.04 porque si se puede saber???
comentó on 28/4/11
Es un problema molestoso con la calculadora en el codigo de la pagina. Cada vez que nos metemos en el panel de control de la oferta, si el porcentaje de descuento es algo como 65.35, cambia automaticamente a 65%. Si se nos olvida cambiarlo, aparece en la pagina.

« Anterior Siguiente »

Session
Session
- Config
  - userAgentba15070f06aa4c878a6794410449d967
  - time1792625993
  - rand355396565
  - timeout10
- city_attachment(empty)
- _Tokena:5:{s:3:"key";s:40:"a89b1212931fab97912f0f0431b5789907d418ce";s:7:"expires";i:1792619993;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}
Request
Request

Cake Params
- pass
  - 0118
- named
  - citySan-salvador
- controllertopic_discussions
- actionindex
- plugin(null)
- url
  - exthtml
  - urlSan-salvador/topic_discussions/index/118
- form(empty)
- isAjax(false)
- _Token
  - keya89b1212931fab97912f0f0431b5789907d418ce
  - expires1792619993
  - allowedControllers(empty)
  - allowedActions(empty)
  - disabledFields(empty)
- paging
  - TopicDiscussion
    - page1
    - current7
    - count7
    - prevPage(false)
    - nextPage(false)
    - pageCount1
    - defaults
      limit20
      step1
      conditions
      0
      TopicDiscussion.topic_id118
      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_id118
      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/118
Cookie
- 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

30 queries took 2 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` = '04155c8342e17cbb0b1f2d14101bb6e6'

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:1792625993;s:4:"rand";i:355396565;s:7:"timeout";i:10;}city_attachment\|s:0:"";_Token\|s:179:"a:5:{s:3:"key";s:40:"a89b1212931fab97912f0f0431b5789907d418ce";s:7:"expires";i:1792619993;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` = 118 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 hasta de deliciosos (y saludables) yogurts congelados y smoothies en TCBY!' 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` = 118 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 '118' AS `id`,'2011-04-26 14:00:05' AS `created`,'2011-04-26 14:00:05' AS `modified`,'1' AS `topic_type_id`,'1' AS `user_id`,'42553' AS `city_id`,'112' AS `deal_id`,'Pagas y consumes hasta de deliciosos (y saludables) yogurts congelados y smoothies en TCBY!' AS `name`,'pagas--y-consumes-hasta--de-deliciosos-(y-saludables)-yogurts-congelados-y-smoothies-en-tcby!' AS `slug`,'

¿Quien dice que el postre engorda? ¿Quién dice que deberíamos de considerar la palabra “dulce” un sinónimo de “culpable”? La oferta de hoy dice que no tiene que ser asi: Pagas y consumes hasta de deliciosos (y saludables) yogurts congelados y smoothies en TCBY!

El yogurt congelado estilo “soft serve” te trae una opción para el postre 96% libre de grasa y 96% llena de “mmmm…” Ademas, cultivos bacteriales amigables naturalmente presentes en el yogurt te ayudarán con la digestión! Prueba todos los sabores desde los clásicos (Golden vanilla, fresa) hasta los más exóticos (White Chocolate Mousse!). Aderezos como M&Ms, chocolate chips y chispas de colores agregan un poquito de “crunch” agradable que contraste bien con la cremosa suavidad del yogurt. O si prefieres algo mas liquido, échate uno de los sabrosos smoothies de frutas refrescantes que también están disponibles en varios sabores tentadores.

¿Que esperas? Compra tu cupón y disfruta de los postres deliciosos (y saludables) sin remordimiento.

' AS `content`,'7' AS `topic_discussion_count`,'1' AS `last_replied_user_id`,'2011-04-29 01:28:44' 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('112', 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` = 112

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(112, NULL)

SELECT `TopicsUser`.`id`, `TopicsUser`.`user_id`, `TopicsUser`.`topic_id` FROM `topics_users` AS `TopicsUser` WHERE `TopicsUser`.`topic_id` = 118 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` = 118

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` = 118)) left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`User`.`id` = `cuponclu_playpen120111`.`TopicDiscussion`.`user_id`)) where (`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` = 118)

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` = 118 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` = 118)) left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`User`.`id` = `cuponclu_playpen120111`.`TopicDiscussion`.`user_id`)) where (`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` = 118) order by `cuponclu_playpen120111`.`TopicDiscussion`.`id` limit 20