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 $6 y consumes $15 en Wild Wings!

Sigue este tema

Page 1 de 1

Diegom90 comentó on 23/5/11
Esto aplica para llevar?
comentó on 23/5/11
Hola Diego, si aplica para llevar. Que lo disfrutes!
jorgeregalado comentó on 23/5/11
Digamos que vamos un grupo de 10 personas, podemos ocupar 4 cupones por mesa? o hay alguna restriccion?
comentó on 23/5/11
Hola Jorge, gracias por preguntar. No hay ninguna restriccion asi. Pueden ocupar 4 cupones por mesa. Que los disfruten.
comentó on 24/5/11
HOY, llamanos al 2542-2412 para pagar en efectivo.
jestrada comentó on 24/5/11
Hola tengo una pregunta mi nombre es Jaime hay alguna forma de ver el menu de wildwings?
comentó on 24/5/11
Hola Jaime, gracias por contactarnos. No hay una forma de mandarte el menu entero. Tienes preguntas especificas?
almaportillo comentó on 25/5/11
tengo un problema quiero comprar por inter y siempre me dice declinada y he probado con dos tarjetas diferentes q hago no me parace justo q tenga q pagar el domicilio porq consulten con mi banco y no hay problema q puedo hacer?
marcellazarate comentó on 25/5/11
Hola , puedo comprar dos cupones?
jorgeregalado comentó on 25/5/11
Tres amigos me han dicho que tienen el mismo problema que alma, esta declinando las transacciones con tarjetas. Marcela, yo compre dos sin ningun problema. Lo mejor es crear un cuenta paypal para comprar. Yo no he tenido ningun problema pagando con paypal.
comentó on 25/5/11
Gracias Jorge. La verdad es que aveces la seguridad de PayPal es demaciado fuerte (mejor asi que lo contrario). El consejo de Jorge en bueno...es mas facil crear una cuenta de PayPal. Disculpen la inconveniencia.
comentó on 25/5/11
Hola Marcella, si puedes comprar 2 cupones.
alvarovc comentó on 25/5/11
Hola, creo que sería bueno que en la página de la oferta del día sean un poco más específicos sobre las restricciones. El hecho que se puedan usar varios cupones por mesa me parece perfecto, pero si nadie lo hubiera preguntado entonces nadie se entera. La vez pasada me pasó con el cupón para comprar traguitos en republik, fui un sábado y el mesero me dijo que el cupón solamente se podía usar día de semana aunque en ninguna parte se mencionaba eso. Ojo que solamente es un consejo no un reclamo.
comentó on 26/5/11
Hola Alvaro muchas gracias por tus comentarios, estamos trabajando para darles el mejor servicio.
youngwicks comentó on 26/5/11
Hola tengo unas preguntas 1. venden cerveza? 2. Cual es el horario del fin de semana? 3. Se puede utilizar el coupon los fines de semana? 4. El coupon es valido sobre todo el menu? Tienen televisores con cable??

« Anterior Siguiente »

Session
Session
- Config
  - userAgentba15070f06aa4c878a6794410449d967
  - time1792625953
  - rand466078159
  - timeout10
- city_attachment(empty)
- _Tokena:5:{s:3:"key";s:40:"0ff5f4e68f1185ea19b4f87c4c92e5b29badb22e";s:7:"expires";i:1792619953;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}
Request
Request

Cake Params
- pass
  - 0138
- named
  - citySan-salvador
- controllertopic_discussions
- actionindex
- plugin(null)
- url
  - exthtml
  - urlSan-salvador/topic_discussions/index/138
- form(empty)
- isAjax(false)
- _Token
  - key0ff5f4e68f1185ea19b4f87c4c92e5b29badb22e
  - expires1792619953
  - allowedControllers(empty)
  - allowedActions(empty)
  - disabledFields(empty)
- paging
  - TopicDiscussion
    - page1
    - current15
    - count15
    - prevPage(false)
    - nextPage(false)
    - pageCount1
    - defaults
      limit20
      step1
      conditions
      0
      TopicDiscussion.topic_id138
      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_id138
      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/138
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

49 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` = '5943f858d88fe0efca0b80ac066c4585'

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:1792625953;s:4:"rand";i:466078159;s:7:"timeout";i:10;}city_attachment\|s:0:"";_Token\|s:179:"a:5:{s:3:"key";s:40:"0ff5f4e68f1185ea19b4f87c4c92e5b29badb22e";s:7:"expires";i:1792619953;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` = 138 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 Wild Wings!' 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` = 138 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 '138' AS `id`,'2011-05-23 15:00:03' AS `created`,'2011-05-23 15:00:03' AS `modified`,'1' AS `topic_type_id`,'1' AS `user_id`,'42553' AS `city_id`,'129' AS `deal_id`,'Pagas y consumes en Wild Wings!' AS `name`,'pagas--y-consumes--en-wild-wings!' AS `slug`,'

Tenedores, a pesar de haber sido considerados indispensables para auto-alimentación por casi toda la era moderna de humanidad por fin se han vuelto obsoletos con la oferta de hoy: Pagas y consumes de alitas y otros alimentos manualmente comibles en Wild Wings!

La especialidad de la casa es –si, tu lo adivinaste—alitas. Estas accesorias arreas sabrosas se pueden comer empanzadas y bañadas de una de las exquisitas salsas de la casa o desnudas, según tu preferencia. Cada quien puede escoger el nivel de picante que desea, desde “bbq” (para aquellos con bocas tiernas), hasta “hot” (solo para los muy valientes y/o aquellos con bocas a prueba de fuego). Además de las alitas, el menú innovador también incluye hamburguesas, costillas, varias acompañamientos (prueba los “potato skins,” y no te vas a arrepentir) y unos postres tentadores para balancear el “hot” con un pocito de “sweet.” Compra tu cupón y usa tu cubierto natural en Wild Wings!

' AS `content`,'15' AS `topic_discussion_count`,'3190' AS `last_replied_user_id`,'2011-05-26 16:13:24' 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('129', 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` = 129

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

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

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	TopicDiscussion	ref	topic_id	topic_id	8	const	14	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` = 138)) left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`User`.`id` = `cuponclu_playpen120111`.`TopicDiscussion`.`user_id`)) where (`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` = 138)

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