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 vigentes hasta el 31 de julio. Si la situación entonces lo requiere, extenderemos la vigencia de nuevo.

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

Clic aquí para suscribirte a recibir nuestras ofertas

Cupón Club

Guatemala

Más Ciudades

Para comprar en línea:

¿Necesitas ayuda? L-V 9:00 AM - 5:00 PM

5632-4924

Llena el formulario y completa la orden.

¿Quieres regalar este cupón? Clic aquí.

Descripción	Cantidad	Precio	Total
PRUEBA-NO COMPRAR¡Paga Q295 en vez de Q590 por Estadía para 2 Adultos y 2 Niños en Habitación Doble en Agua Azul Hotel y Restaurante en el Puerto de San José!		Q295.00	Q295.00
Total del Carrito			Q295.00

¿No tienes una cuenta?

Regístrate

Puedes crear una cuenta con un formulario.

Centro Comercio Unicentro (Zona 10)

Ubicación: Tercer Nivel, área de restaurantes a mano izquierda de las gradas eléctricas
Lunes a Viernes de 8:30 am a 8:00 pm y fin de semana de 10:00 am a 7:00 pm.

Las Plazas Majadas (Zona 11)

Ubicación: Entrada Principal Kiosco 7

Lunes a Viernes de 10:00 am a 8:00 pm y fin de semana de 10:00 am a 7:00 pm.

Nuestro trabajo es darte experiencias increíbles. Cada cupón cuenta con nuestro respaldo. Haz clic para leer nuestra fuerte garantia.

Session
Session
- Config
  - userAgentba15070f06aa4c878a6794410449d967
  - time1792623518
  - rand609888483
  - timeout10
- city_attachment(empty)
- _Tokena:5:{s:3:"key";s:40:"74d226401d43f639e3069779ab3a6122a822850b";s:7:"expires";i:1792617518;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:35:{i:0;s:10:"Attachment";i:1;s:7:"Picture";i:2;s:9:"Fbpicture";i:3;s:25:"Deal.calculator_min_limit";i:4;s:32:"Deal.calculator_discounted_price";i:5;s:28:"Deal.calculator_bonus_amount";i:6;s:37:"Deal.calculator_commission_percentage";i:7;s:28:"Deal.calculator_bonus_amount";i:8;s:37:"Deal.calculator_commission_percentage";i:9;s:15:"Deal.start_date";i:10;s:13:"Deal.end_date";i:11;s:23:"Deal.coupon_expiry_date";i:12;s:13:"DealStatus.id";i:13;s:15:"DealStatus.name";i:14;s:19:"Deal.original_price";i:15;s:12:"Deal.savings";i:16;s:7:"Deal.id";i:17;s:18:"Deal.save_as_draft";i:18;s:18:"Deal.send_to_admin";i:19;s:15:"Deal.gift_email";i:20;s:14:"Deal.gift_from";i:21;s:12:"Deal.gift_to";i:22;s:12:"Deal.message";i:23;s:13:"Deal.quantity";i:24;s:12:"Deal.message";i:25;s:16:"Deal.deal_amount";i:26;s:12:"Deal.deal_id";i:27;s:12:"Deal.is_gift";i:28;s:21:"User.confirm_password";i:29;s:10:"User.email";i:30;s:11:"User.passwd";i:31;s:13:"User.username";i:32;s:27:"Deal.user_available_balance";i:33;s:12:"Deal.gift_to";i:34;s:13:"Deal.salesman";}}
- Auth
  - redirectUrlguatemala-city/deals/checkout/6801
Request
Request

Cake Params
- pass
  - 06801
- named
  - cityguatemala-city
- controllerdeals
- actioncheckout
- plugin(null)
- url
  - exthtml
  - urlguatemala-city/deals/checkout/6801
- form(empty)
- isAjax(false)
- _Token
  - key74d226401d43f639e3069779ab3a6122a822850b
  - expires1792617518
  - allowedControllers(empty)
  - allowedActions(empty)
  - disabledFields
    - 0Attachment
    - 1Picture
    - 2Fbpicture
    - 3Deal.calculator_min_limit
    - 4Deal.calculator_discounted_price
    - 5Deal.calculator_bonus_amount
    - 6Deal.calculator_commission_percentage
    - 7Deal.calculator_bonus_amount
    - 8Deal.calculator_commission_percentage
    - 9Deal.start_date
    - 10Deal.end_date
    - 11Deal.coupon_expiry_date
    - 12DealStatus.id
    - 13DealStatus.name
    - 14Deal.original_price
    - 15Deal.savings
    - 16Deal.id
    - 17Deal.save_as_draft
    - 18Deal.send_to_admin
    - 19Deal.gift_email
    - 20Deal.gift_from
    - 21Deal.gift_to
    - 22Deal.message
    - 23Deal.quantity
    - 24Deal.message
    - 25Deal.deal_amount
    - 26Deal.deal_id
    - 27Deal.is_gift
    - 28User.confirm_password
    - 29User.email
    - 30User.passwd
    - 31User.username
    - 32Deal.user_available_balance
    - 33Deal.gift_to
    - 34Deal.salesman
$_GET
- urlguatemala-city/deals/checkout/6801
Cookie
- Box
  - category
    - 52
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

17 queries took 3 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 `City`.`language_id`, `Language`.`iso2`, `Language`.`id` FROM `cities` AS `City` LEFT JOIN `languages` AS `Language` ON (`City`.`language_id` = `Language`.`id`) WHERE `City`.`slug` = 'guatemala-city' 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	Language		eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.City.language_id	1	100.00

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`City`.`language_id` AS `language_id`,`cuponclu_playpen120111`.`Language`.`iso2` AS `iso2`,`cuponclu_playpen120111`.`Language`.`id` AS `id` from `cuponclu_playpen120111`.`cities` `City` left join `cuponclu_playpen120111`.`languages` `Language` on((`cuponclu_playpen120111`.`Language`.`id` = `cuponclu_playpen120111`.`City`.`language_id`)) where ((`cuponclu_playpen120111`.`City`.`is_approved` = 1) and (`cuponclu_playpen120111`.`City`.`slug` = 'guatemala-city')) limit 1

DESCRIBE `email_templates`

DESCRIBE `survey_questions`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '311f2e2e8267897aadb17b0135f12685'

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 `data` from `cuponclu_playpen120111`.`cake_sessions` where (NULL = '311f2e2e8267897aadb17b0135f12685')

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` = 'guatemala-city' 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` = 'guatemala-city')) 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 `Deal`.`id`, `Deal`.`created`, `Deal`.`name`, `Deal`.`short_name`, `Deal`.`slug`, `Deal`.`original_price`, `Deal`.`discount_amount`, `Deal`.`description`, `Deal`.`discount_percentage`, `Deal`.`min_limit`, `Deal`.`max_limit`, `Deal`.`deal_user_count`, `Deal`.`discounted_price`, `Deal`.`buy_min_quantity_per_user`, `Deal`.`buy_max_quantity_per_user`, `Deal`.`city_id`, `Deal`.`start_date`, `Deal`.`end_date` FROM `deals` AS `Deal` LEFT JOIN `attachments` AS `Attachment` ON (`Attachment`.`foreign_id` = `Deal`.`id` AND `Attachment`.`class` = 'Deal') LEFT JOIN `fbpictures` AS `Fbpicture` ON (`Fbpicture`.`foreign_id` = `Deal`.`id` AND `Fbpicture`.`class` = 'Deal') WHERE `Deal`.`id` = 6801 AND `Deal`.`deal_status_id` IN (2, 5) LIMIT 1

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Deal	const	PRIMARY,deal_status_id	PRIMARY	8	const	1	100.00
1	SIMPLE	Attachment	ref	foreign_id,class	foreign_id	8	const	1	100.00	Using where
1	SIMPLE	Fbpicture	ref	foreign_id,class	foreign_id	8	const	1	100.00	Using where

Level

Code

Message

Note

1003

/* select#1 */ select '6801' AS `id`,'2018-09-04 15:29:17' AS `created`,'PRUEBA-NO COMPRAR¡Paga Q295 en vez de Q590 por Estadía para 2 Adultos y 2 Niños en Habitación Doble en Agua Azul Hotel y Restaurante en el Puerto de San José!' AS `name`,'Estadía para 2 Adultos y 2 Niños en el Puerto, 4 Piscinas, Juegos y Más.' AS `short_name`,'¡paga-q295-en-vez-de-q590-por' AS `slug`,'590.00' AS `original_price`,'295.00' AS `discount_amount`,'

¿Por qué lo necesitas?

Una invitación a la playa no es tentadora… ¡es irresistible! Y con la oferta de hoy no será necesario esperar las siguientes vacaciones para volver a vivir un rico y merecido paseo. ¡Regálate YA un tiempo para ti y tu familia refrescándote en las piscinas y disfrutando del calorcito del puerto!

¿Qué es?

¿Hace cuánto no escapas con tu familia a un excitante día de piscinas? Esta oferta es la indicada para hacerlo. Empaca tus maletas, flotadores y bloqueador para disfrutar con tu pareja y 2 niños menores de 10 años.

La habitación está conveniente equipada con aire acondicionado, televisión con cable, internet inalámbrico y baño privado. ¿Estás listo para disfrutar?

¿Por qué recomendamos a Agua Azul Hotel y Restaurante?

Agua Azul Hotel y Restaurante ofrece, desde 1980, un excelente servicio hotelero en puerto San José. El hotel fue construido para la satisfacción de los clientes más selectos por lo que sus instalaciones y la amabilidad de los trabajadores van a sorprenderte. Encuentra un área de recepción con amplio parqueo privado, restaurante, 4 piscinas grandes, 14 habitaciones y 8 bungalows, extensas áreas verdes con jardín y juegos infantiles, hamacas y ranchitos.

¿Cómo llegar?

El Hotel y Restaurante Agua Azul se encuentra en el Km 106.5 Puerto de San José, Chulamar.

' AS `description`,'50' AS `discount_percentage`,'1' AS `min_limit`,'10' AS `max_limit`,'2' AS `deal_user_count`,'295.00' AS `discounted_price`,'1' AS `buy_min_quantity_per_user`,'10' AS `buy_max_quantity_per_user`,'42563' AS `city_id`,'2018-09-04 17:00:00' AS `start_date`,'2025-01-02 00:00:00' AS `end_date` from `cuponclu_playpen120111`.`deals` `Deal` left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = 6801) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 6801) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where (('5' in (2,5))) limit 1

SELECT `Setting`.`id`, `Setting`.`setting_category_id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`options`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE `Setting`.`setting_category_id` = 27 AND `Setting`.`name` = 'date_invoice_generation' LIMIT 1

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Setting		ref	setting_category_id,name	name	767	const	1	34.27	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` from `cuponclu_playpen120111`.`settings` `Setting` where ((`cuponclu_playpen120111`.`Setting`.`setting_category_id` = 27) and (`cuponclu_playpen120111`.`Setting`.`name` = 'date_invoice_generation')) limit 1

SELECT `User`.`id`, `User`.`fb_user_id`, `User`.`email`, `User`.`wallet_currency`, `User`.`referral_agent_id`, `User`.`bonus_points` FROM `users` AS `User` 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`.`fb_user_id` AS `fb_user_id`,`cuponclu_playpen120111`.`User`.`email` AS `email`,`cuponclu_playpen120111`.`User`.`wallet_currency` AS `wallet_currency`,`cuponclu_playpen120111`.`User`.`referral_agent_id` AS `referral_agent_id`,`cuponclu_playpen120111`.`User`.`bonus_points` AS `bonus_points` from `cuponclu_playpen120111`.`users` `User` where false limit 1

SELECT `PaymentGateway`.`id`, `PaymentGateway`.`created`, `PaymentGateway`.`modified`, `PaymentGateway`.`name`, `PaymentGateway`.`display_name`, `PaymentGateway`.`description`, `PaymentGateway`.`gateway_fees`, `PaymentGateway`.`transaction_count`, `PaymentGateway`.`payment_gateway_setting_count`, `PaymentGateway`.`is_test_mode`, `PaymentGateway`.`is_active` FROM `payment_gateways` AS `PaymentGateway` WHERE `PaymentGateway`.`id` = 7 AND `PaymentGateway`.`is_active` = 1 LIMIT 1

EXPLAIN

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

Level	Code	Message
Note	1003	/* select#1 */ select '7' AS `id`,'2019-11-12 00:00:00' AS `created`,'2026-10-07 00:44:14' AS `modified`,'Cybersource' AS `name`,'Visa o MasterCard' AS `display_name`,'Credit card using Cybersource in Guatemala or El Salvador.' AS `description`,'0.00' AS `gateway_fees`,'0' AS `transaction_count`,'0' AS `payment_gateway_setting_count`,'0' AS `is_test_mode`,'1' AS `is_active` from `cuponclu_playpen120111`.`payment_gateways` `PaymentGateway` where true limit 1

SELECT `PaymentGatewaySetting`.`key`, `PaymentGatewaySetting`.`test_mode_value`, `PaymentGatewaySetting`.`live_mode_value`, `PaymentGatewaySetting`.`payment_gateway_id` FROM `payment_gateway_settings` AS `PaymentGatewaySetting` WHERE `PaymentGatewaySetting`.`payment_gateway_id` = (7)

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	PaymentGatewaySetting		ALL					46	10.00	Using where

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`PaymentGatewaySetting`.`key` AS `key`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`test_mode_value` AS `test_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`live_mode_value` AS `live_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` AS `payment_gateway_id` from `cuponclu_playpen120111`.`payment_gateway_settings` `PaymentGatewaySetting` where (`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` = 7)

SELECT `PaymentGateway`.`id`, `PaymentGateway`.`created`, `PaymentGateway`.`modified`, `PaymentGateway`.`name`, `PaymentGateway`.`display_name`, `PaymentGateway`.`description`, `PaymentGateway`.`gateway_fees`, `PaymentGateway`.`transaction_count`, `PaymentGateway`.`payment_gateway_setting_count`, `PaymentGateway`.`is_test_mode`, `PaymentGateway`.`is_active` FROM `payment_gateways` AS `PaymentGateway` WHERE `PaymentGateway`.`is_active` = 1 ORDER BY `PaymentGateway`.`display_name` asc

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	PaymentGateway		ALL					7	14.29	Using where; Using filesort

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`PaymentGateway`.`id` AS `id`,`cuponclu_playpen120111`.`PaymentGateway`.`created` AS `created`,`cuponclu_playpen120111`.`PaymentGateway`.`modified` AS `modified`,`cuponclu_playpen120111`.`PaymentGateway`.`name` AS `name`,`cuponclu_playpen120111`.`PaymentGateway`.`display_name` AS `display_name`,`cuponclu_playpen120111`.`PaymentGateway`.`description` AS `description`,`cuponclu_playpen120111`.`PaymentGateway`.`gateway_fees` AS `gateway_fees`,`cuponclu_playpen120111`.`PaymentGateway`.`transaction_count` AS `transaction_count`,`cuponclu_playpen120111`.`PaymentGateway`.`payment_gateway_setting_count` AS `payment_gateway_setting_count`,`cuponclu_playpen120111`.`PaymentGateway`.`is_test_mode` AS `is_test_mode`,`cuponclu_playpen120111`.`PaymentGateway`.`is_active` AS `is_active` from `cuponclu_playpen120111`.`payment_gateways` `PaymentGateway` where (`cuponclu_playpen120111`.`PaymentGateway`.`is_active` = 1) order by `cuponclu_playpen120111`.`PaymentGateway`.`display_name`

SELECT `PaymentGatewaySetting`.`id`, `PaymentGatewaySetting`.`created`, `PaymentGatewaySetting`.`modified`, `PaymentGatewaySetting`.`payment_gateway_id`, `PaymentGatewaySetting`.`key`, `PaymentGatewaySetting`.`type`, `PaymentGatewaySetting`.`options`, `PaymentGatewaySetting`.`test_mode_value`, `PaymentGatewaySetting`.`live_mode_value`, `PaymentGatewaySetting`.`description` FROM `payment_gateway_settings` AS `PaymentGatewaySetting` WHERE `PaymentGatewaySetting`.`key` IN ('is_enable_for_buy_a_deal', 'is_enable_wallet') AND `PaymentGatewaySetting`.`test_mode_value` = '1' AND `PaymentGatewaySetting`.`payment_gateway_id` IN (4, 5, 6, 3, 7, 1)

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	PaymentGatewaySetting		ALL					46	2.17	Using where

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`PaymentGatewaySetting`.`id` AS `id`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`created` AS `created`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`modified` AS `modified`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` AS `payment_gateway_id`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`key` AS `key`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`type` AS `type`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`options` AS `options`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`test_mode_value` AS `test_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`live_mode_value` AS `live_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`description` AS `description` from `cuponclu_playpen120111`.`payment_gateway_settings` `PaymentGatewaySetting` where ((`cuponclu_playpen120111`.`PaymentGatewaySetting`.`key` in ('is_enable_for_buy_a_deal','is_enable_wallet')) and (`cuponclu_playpen120111`.`PaymentGatewaySetting`.`test_mode_value` = '1') and (`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` in (4,5,6,3,7,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`, `Company`.`name`, `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`, `Fbpicture`.`id`, `Fbpicture`.`created`, `Fbpicture`.`modified`, `Fbpicture`.`class`, `Fbpicture`.`foreign_id`, `Fbpicture`.`filename`, `Fbpicture`.`dir`, `Fbpicture`.`mimetype`, `Fbpicture`.`filesize`, `Fbpicture`.`height`, `Fbpicture`.`width`, `Fbpicture`.`thumb`, `Fbpicture`.`description` FROM `deals` AS `Deal` LEFT JOIN `companies` AS `Company` ON (`Deal`.`company_id` = `Company`.`id`) LEFT JOIN `attachments` AS `Attachment` ON (`Attachment`.`foreign_id` = `Deal`.`id` AND `Attachment`.`class` = 'Deal') LEFT JOIN `fbpictures` AS `Fbpicture` ON (`Fbpicture`.`foreign_id` = `Deal`.`id` AND `Fbpicture`.`class` = 'Deal') WHERE `Deal`.`id` = 6801

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Deal	const	PRIMARY	PRIMARY	8	const	1	100.00
1	SIMPLE	Company	const	PRIMARY	PRIMARY	8	const	1	100.00
1	SIMPLE	Attachment	ref	foreign_id,class	foreign_id	8	const	1	100.00	Using where
1	SIMPLE	Fbpicture	ref	foreign_id,class	foreign_id	8	const	1	100.00	Using where

Level

Code

Message

Note

1003

/* select#1 */ select '6801' AS `id`,'2018-09-04 15:29:17' AS `created`,'2019-11-27 22:56:34' AS `modified`,'2827' AS `user_id`,'PRUEBA-NO COMPRAR¡Paga Q295 en vez de Q590 por Estadía para 2 Adultos y 2 Niños en Habitación Doble en Agua Azul Hotel y Restaurante en el Puerto de San José!' AS `name`,'Estadía para 2 Adultos y 2 Niños en el Puerto, 4 Piscinas, Juegos y Más.' AS `short_name`,'Estadía para 2 Adultos y 2 Niños en Habitación Doble en Agua Azul Hotel y Restaurante en el Puerto de San José en Hotel y Restaurante Agua Azul' AS `coupon_name`,'Escuintla123' AS `display_neighborhoodname`,'¡paga-q295-en-vez-de-q590-por' AS `slug`,NULL AS `bitly_short_url`,'

¿Por qué lo necesitas?

¿Qué es?

La habitación está conveniente equipada con aire acondicionado, televisión con cable, internet inalámbrico y baño privado. ¿Estás listo para disfrutar?

¿Por qué recomendamos a Agua Azul Hotel y Restaurante?

¿Cómo llegar?

El Hotel y Restaurante Agua Azul se encuentra en el Km 106.5 Puerto de San José, Chulamar.

' AS `description`,'' AS `private_note`,'590.00' AS `original_price`,'295.00' AS `discounted_price`,'2018-09-04 17:00:00' AS `start_date`,'2025-01-02 00:00:00' AS `end_date`,'11' AS `sort_order`,'50' AS `discount_percentage`,'295.00' AS `discount_amount`,'295.00' AS `savings`,'1' AS `min_limit`,'10' AS `max_limit`,'42563' AS `city_id`,'0' AS `display_city_id`,'1030' AS `company_id`,'' AS `review`,'2' AS `deal_user_count`,'0' AS `payment_failed_count`,'1' AS `buy_min_quantity_per_user`,'10' AS `buy_max_quantity_per_user`,'2020-01-30 14:56:23' AS `deal_tipped_time`,'2024-12-31 00:00:00' AS `coupon_expiry_date`,'

¡Ve a pasear con tu familia al puerto! Un par de detalles: Como siempre, el cupón no es combinable con otras ofertas ni promociones. Te pedimos realizar la reservación llamando al teléfono: 2471-4769 o 7881-1310. Tarifa válida de domingo a jueves. Recargo de Q99 por reservaciones viernes y sábados. Tarifa no incluye alimentación. Ocupación máxima en habitación doble de 2 adultos y 2 niños menores de 10 años. Aplica para habitación doble con A/C. No aplica para estadía en días festivos ni feriados. ¡Qué disfrutes!

' AS `coupon_condition`,'

Despreocúpate de la rutina y descansa con tu familia en una cómoda habitación equipada con cama, baño privado, aire acondicionado, TV con cable e internet, dentro de las agradables instalaciones de Agua Azul… (ya es hora de una escapada en familia y aprovechar a pasar momentos agradables con tus seres queridos)

Refréscate nadando en cualquiera de sus 4 piscinas o relájate caminando por sus lindos y amplios jardines.

Agua Azul Hotel y Restaurante cuenta con más de 35 años de excelencia en el servicio hotelero— en sus instalaciones recién remodeladas encontrarás todas las comodidades y entretenimientos para que disfrutes de hermosos e inolvidables momentos.

' AS `coupon_highlights`,'' AS `comment`,'1' AS `is_coupon_mail_sent`,'0' AS `is_subscription_mail_sent`,'0' AS `is_side_deal`,'5' AS `deal_status_id`,'0.00' AS `bonus_amount`,'37.00' AS `commission_percentage`,'100.00' AS `commission_percent_unused`,NULL AS `vat_percent`,NULL AS `payment1_amt`,'' AS `payment1_date`,'' AS `payment1_check_no`,'' AS `payment1_bank`,NULL AS `payment1_comm`,NULL AS `payment1_vat`,'' AS `payment1_info`,'' AS `payment1_comments`,NULL AS `payment2_amt`,'' AS `payment2_date`,'' AS `payment2_check_no`,'' AS `payment2_bank`,NULL AS `payment2_comm`,NULL AS `payment2_vat`,'' AS `payment2_info`,'' AS `payment2_comments`,NULL AS `payment3_amt`,'' AS `payment3_date`,'' AS `payment3_check_no`,'' AS `payment3_bank`,NULL AS `payment3_comm`,NULL AS `payment3_vat`,'' AS `payment3_info`,'' AS `payment3_comments`,NULL AS `payment4_amt`,'' AS `payment4_date`,'' AS `payment4_check_no`,'' AS `payment4_bank`,NULL AS `payment4_comm`,NULL AS `payment4_vat`,'' AS `payment4_info`,'' AS `payment4_comments`,'0.00' AS `first_payment_percent`,'0' AS `added_coupons`,'0.00' AS `total_commission_amount`,'0.00' AS `total_purchased_amount`,'0.00' AS `net_profit`,'' AS `meta_keywords`,'' AS `meta_description`,'http://bit.ly/2Ui5IOa' AS `bitly_short_url_subdomain`,'http://bit.ly/2Ui5JSe' AS `bitly_short_url_prefix`,'0' AS `certainly`,'0' AS `probably`,'0' AS `unlikely_satisfied`,'0' AS `unlikely_unsatisfied`,'0' AS `survey_happy`,'0' AS `survey_fair`,'0' AS `survey_sad`,'' AS `salesman`,NULL AS `zone`,NULL AS `industry`,'5' AS `category_id`,'1' AS `sub_category_id`,'unisex' AS `gender`,'2' AS `neighborhood_id`,'0.00' AS `sales_projection`,'' AS `facebook_description`,'' AS `facebook_title`,'Hotel y Restaurante Agua Azul' AS `name`,`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`,`cuponclu_playpen120111`.`Fbpicture`.`id` AS `id`,`cuponclu_playpen120111`.`Fbpicture`.`created` AS `created`,`cuponclu_playpen120111`.`Fbpicture`.`modified` AS `modified`,`cuponclu_playpen120111`.`Fbpicture`.`class` AS `class`,`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`Fbpicture`.`filename` AS `filename`,`cuponclu_playpen120111`.`Fbpicture`.`dir` AS `dir`,`cuponclu_playpen120111`.`Fbpicture`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`Fbpicture`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`Fbpicture`.`height` AS `height`,`cuponclu_playpen120111`.`Fbpicture`.`width` AS `width`,`cuponclu_playpen120111`.`Fbpicture`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`Fbpicture`.`description` AS `description` from `cuponclu_playpen120111`.`deals` `Deal` left join `cuponclu_playpen120111`.`companies` `Company` on(multiple equal('1030', '1030')) left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = 6801) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 6801) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where true

SELECT `DealCategory`.`id`, `DealCategory`.`name` FROM `deal_categories` AS `DealCategory` WHERE 1 = 1

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	DealCategory		ALL					22	100.00

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`DealCategory`.`id` AS `id`,`cuponclu_playpen120111`.`DealCategory`.`name` AS `name` from `cuponclu_playpen120111`.`deal_categories` `DealCategory`

SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `neighborhoods` AS `Neighborhood` WHERE 1 = 1

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Neighborhood		ALL					10	100.00

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`Neighborhood`.`id` AS `id`,`cuponclu_playpen120111`.`Neighborhood`.`name` AS `name` from `cuponclu_playpen120111`.`neighborhoods` `Neighborhood`

Timer

Timers

Total Request Time: 0.253133m (seconds)

Message	time in seconds
Component initialization and startup	0.00183
Controller Action	0.00044
Render Controller Action	0.00179
Rendering View	0.00167
Rendering APP/views/deals/checkout.ctp	0.02484
Rendering APP/views/elements/users-login.ctp	0.02199
Rendering APP/views/users/login.ctp	0.00177
Rendering APP/views/layouts/default.ctp	0.025
Rendering APP/views/elements/site_tracker.ctp	1.0E-5
Rendering APP/views/elements/cities-index-static.ctp	0.00024
Rendering APP/views/elements/deal-faq.ctp	0.02252
Rendering APP/views/pages/view.ctp	0.00048

Log

Logs

error.log

Time	Message
2026-10-21 16:35:51	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:35:58	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:36:11	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:36:45	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:37:42	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:37:50	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:37:56	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:01	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:02	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:02	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:16	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:16	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:17	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:17	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_core_paths) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_object_map) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_companies) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deals) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_statuses) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_topic_types) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_coupons) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_categories) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_transactions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_cybersource_tokens) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_views) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_openids) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_friends) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_logins) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_paypal_transaction_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_payment_gateway_settings) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_bonus_point_transactions) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_cash_withdrawals) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_withdrawal_statuses) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_city_suggestions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_paypal_mobile_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_credomatic_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_banned_duis) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fraud_ids) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_cybersource_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_friend_statuses) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 16:56:43	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_email_templates) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_survey_questions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_default_en_us) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 16:56:43	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 16:56:43	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_core_paths) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_object_map) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_cuponclu_playpen120111_list) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_setting_categories) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_languages) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_subscriptions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_cake_sessions) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_companies) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_transactions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_company_addresses) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_views) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_comments) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_openids) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_blocked_users) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_users) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_paypal_docapture_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_payment_gateway_settings) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_gift_users) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_invoices) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_cash_withdrawals) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_credomatic_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_topic_discussions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_topics_users) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_categories) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_sub_categories) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 17:27:40	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_email_templates) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_survey_questions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_default_en_us) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 17:27:40	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 17:27:40	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 18:06:56	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_bp_transaction_types) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 18:06:56	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_topics_users) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 18:06:56	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_sub_categories) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 18:06:56	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 18:06:56	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 19:30:19	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_credomatic_logs) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 19:30:19	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_user_coupons) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 19:30:19	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_sub_categories) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 19:30:19	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 19:30:19	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 19:30:19	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 19:30:19	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]

debug.log

Time	Message
2026-10-21 16:30:14	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:30:15	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:01	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:02	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:04	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:16	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:16	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:17	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:34:50	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:34:55	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:35:37	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:35:49	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:35:49	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:35:57	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:47:58	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:48:17	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:48:18	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:48:19	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:49:08	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:49:39	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:52:22	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:52:22	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:52:23	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:01:23	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:01:24	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:01:25	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:02:05	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:02:25	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:24:42	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:24:42	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:24:43	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:30:29	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:30:29	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:30:30	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:35:10	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:35:10	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:35:12	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:37:30	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:37:30	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:37:31	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]

Memory

Memory

Current Memory Use 4.47 MB

Peak Memory Use 9.19 MB
Variables
View Variables
- is_klaviyo_enabled
- city_id42563
- city_nameGuatemala
- city_slugguatemala-city
- city_attachment
  - id(null)
  - created(null)
  - modified(null)
  - class(null)
  - foreign_id(null)
  - filename(null)
  - dir(null)
  - mimetype(null)
  - filesize(null)
  - height(null)
  - width(null)
  - thumb(null)
  - description(null)
- payment_failed(null)
- deal_id6801
- cybersourceFingerprintUrlhttps://h.online-metrix.net/fp/tags.js?org_id=k8vif92e&session_id=visanetgt_cuponclub123456789
- showcaptcha(false)
- validation_errors(empty)
- gateway_options
  - paymentGateways
    - 7Visa o MasterCard
    - 5American Express
  - creditCardTypes
    - VisaVisa
    - MasterCardMasterCard
  - creditCardTypesAuthnet
    - AmexAmex
    - DiscoverOtros
- deals
  - 6801
    - Deal
      id6801
      created2018-09-04 15:29:17
      namePRUEBA-NO COMPRAR¡Paga Q295 en vez de Q590 por Estadía para 2 Adultos y 2 Niños en Habitación Doble en Agua Azul Hotel y Restaurante en el Puerto de San José!
      short_nameEstadía para 2 Adultos y 2 Niños en el Puerto, 4 Piscinas, Juegos y Más.
      slug¡paga-q295-en-vez-de-q590-por
      original_price590.00
      discount_amount295.00
      description
      ¿Por qué lo necesitas?
      
      Una invitación a la playa no es tentadora… ¡es irresistible! Y con la oferta de hoy no será necesario esperar las siguientes vacaciones para volver a vivir un rico y merecido paseo. ¡Regálate YA un tiempo para ti y tu familia refrescándote en las piscinas y disfrutando del calorcito del puerto!
      
      ¿Qué es?
      
      ¿Hace cuánto no escapas con tu familia a un excitante día de piscinas? Esta oferta es la indicada para hacerlo. Empaca tus maletas, flotadores y bloqueador para disfrutar con tu pareja y 2 niños menores de 10 años.
      
      La habitación está conveniente equipada con aire acondicionado, televisión con cable, internet inalámbrico y baño privado. ¿Estás listo para disfrutar?
      
      ¿Por qué recomendamos a Agua Azul Hotel y Restaurante?
      
      Agua Azul Hotel y Restaurante ofrece, desde 1980, un excelente servicio hotelero en puerto San José. El hotel fue construido para la satisfacción de los clientes más selectos por lo que sus instalaciones y la amabilidad de los trabajadores van a sorprenderte. Encuentra un área de recepción con amplio parqueo privado, restaurante, 4 piscinas grandes, 14 habitaciones y 8 bungalows, extensas áreas verdes con jardín y juegos infantiles, hamacas y ranchitos.
      
      ¿Cómo llegar?
      
      El Hotel y Restaurante Agua Azul se encuentra en el Km 106.5 Puerto de San José, Chulamar.
      discount_percentage50
      min_limit1
      max_limit10
      deal_user_count2
      discounted_price295.00
      buy_min_quantity_per_user1
      buy_max_quantity_per_user10
      city_id42563
      start_date2018-09-04 17:00:00
      end_date2025-01-02 00:00:00
      user_quantity
- date_invoice_generation2023-08-16
- deals_forgoogleanalyricsecommerce
  - 0
    - Deal
      id6801
      created2018-09-04 15:29:17
      modified2019-11-27 22:56:34
      user_id2827
      namePRUEBA-NO COMPRAR¡Paga Q295 en vez de Q590 por Estadía para 2 Adultos y 2 Niños en Habitación Doble en Agua Azul Hotel y Restaurante en el Puerto de San José!
      short_nameEstadía para 2 Adultos y 2 Niños en el Puerto, 4 Piscinas, Juegos y Más.
      coupon_nameEstadía para 2 Adultos y 2 Niños en Habitación Doble en Agua Azul Hotel y Restaurante en el Puerto de San José en Hotel y Restaurante Agua Azul
      display_neighborhoodnameEscuintla123
      slug¡paga-q295-en-vez-de-q590-por
      bitly_short_url(null)
      description
      ¿Por qué lo necesitas?
      
      Una invitación a la playa no es tentadora… ¡es irresistible! Y con la oferta de hoy no será necesario esperar las siguientes vacaciones para volver a vivir un rico y merecido paseo. ¡Regálate YA un tiempo para ti y tu familia refrescándote en las piscinas y disfrutando del calorcito del puerto!
      
      ¿Qué es?
      
      ¿Hace cuánto no escapas con tu familia a un excitante día de piscinas? Esta oferta es la indicada para hacerlo. Empaca tus maletas, flotadores y bloqueador para disfrutar con tu pareja y 2 niños menores de 10 años.
      
      La habitación está conveniente equipada con aire acondicionado, televisión con cable, internet inalámbrico y baño privado. ¿Estás listo para disfrutar?
      
      ¿Por qué recomendamos a Agua Azul Hotel y Restaurante?
      
      Agua Azul Hotel y Restaurante ofrece, desde 1980, un excelente servicio hotelero en puerto San José. El hotel fue construido para la satisfacción de los clientes más selectos por lo que sus instalaciones y la amabilidad de los trabajadores van a sorprenderte. Encuentra un área de recepción con amplio parqueo privado, restaurante, 4 piscinas grandes, 14 habitaciones y 8 bungalows, extensas áreas verdes con jardín y juegos infantiles, hamacas y ranchitos.
      
      ¿Cómo llegar?
      
      El Hotel y Restaurante Agua Azul se encuentra en el Km 106.5 Puerto de San José, Chulamar.
      private_note(empty)
      original_price590.00
      discounted_price295.00
      start_date2018-09-04 17:00:00
      end_date2025-01-02 00:00:00
      sort_order11
      discount_percentage50
      discount_amount295.00
      savings295.00
      min_limit1
      max_limit10
      city_id42563
      display_city_id
      company_id1030
      review(empty)
      deal_user_count2
      payment_failed_count
      buy_min_quantity_per_user1
      buy_max_quantity_per_user10
      deal_tipped_time2020-01-30 14:56:23
      coupon_expiry_date2024-12-31 00:00:00
      coupon_condition
      ¡Ve a pasear con tu familia al puerto! Un par de detalles: Como siempre, el cupón no es combinable con otras ofertas ni promociones. Te pedimos realizar la reservación llamando al teléfono: 2471-4769 o 7881-1310. Tarifa válida de domingo a jueves. Recargo de Q99 por reservaciones viernes y sábados. Tarifa no incluye alimentación. Ocupación máxima en habitación doble de 2 adultos y 2 niños menores de 10 años. Aplica para habitación doble con A/C. No aplica para estadía en días festivos ni feriados. ¡Qué disfrutes!
      coupon_highlights
      Despreocúpate de la rutina y descansa con tu familia en una cómoda habitación equipada con cama, baño privado, aire acondicionado, TV con cable e internet, dentro de las agradables instalaciones de Agua Azul… (ya es hora de una escapada en familia y aprovechar a pasar momentos agradables con tus seres queridos)
      
      Refréscate nadando en cualquiera de sus 4 piscinas o relájate caminando por sus lindos y amplios jardines.
      
      Agua Azul Hotel y Restaurante cuenta con más de 35 años de excelencia en el servicio hotelero— en sus instalaciones recién remodeladas encontrarás todas las comodidades y entretenimientos para que disfrutes de hermosos e inolvidables momentos.
      comment(empty)
      is_coupon_mail_sent1
      is_subscription_mail_sent
      is_side_deal
      deal_status_id5
      bonus_amount0.00
      commission_percentage37.00
      commission_percent_unused100.00
      vat_percent(null)
      payment1_amt(null)
      payment1_date(empty)
      payment1_check_no(empty)
      payment1_bank(empty)
      payment1_comm(null)
      payment1_vat(null)
      payment1_info(empty)
      payment1_comments(empty)
      payment2_amt(null)
      payment2_date(empty)
      payment2_check_no(empty)
      payment2_bank(empty)
      payment2_comm(null)
      payment2_vat(null)
      payment2_info(empty)
      payment2_comments(empty)
      payment3_amt(null)
      payment3_date(empty)
      payment3_check_no(empty)
      payment3_bank(empty)
      payment3_comm(null)
      payment3_vat(null)
      payment3_info(empty)
      payment3_comments(empty)
      payment4_amt(null)
      payment4_date(empty)
      payment4_check_no(empty)
      payment4_bank(empty)
      payment4_comm(null)
      payment4_vat(null)
      payment4_info(empty)
      payment4_comments(empty)
      first_payment_percent0.00
      added_coupons
      total_commission_amount0.00
      total_purchased_amount0.00
      net_profit0.00
      meta_keywords(empty)
      meta_description(empty)
      bitly_short_url_subdomainhttp://bit.ly/2Ui5IOa
      bitly_short_url_prefixhttp://bit.ly/2Ui5JSe
      certainly
      probably
      unlikely_satisfied
      unlikely_unsatisfied
      survey_happy
      survey_fair
      survey_sad
      salesman(empty)
      zone(null)
      industry(null)
      category_id5
      sub_category_id1
      genderunisex
      neighborhood_id2
      sales_projection0.00
      facebook_description(empty)
      facebook_title(empty)
    - Company
      nameHotel y Restaurante Agua Azul
    - Attachment
      id1313
      created2018-09-05 00:52:12
      modified2018-09-05 00:52:12
      classDeal
      foreign_id6801
      filename127558619ecfa5e5b630e89f193f880d90364.jpg
      dirDeal/6801
      mimetypeimage/png
      filesize389068
      height327
      width579
      thumb(null)
      descriptionProduct Image
    - Fbpicture
      id(null)
      created(null)
      modified(null)
      class(null)
      foreign_id(null)
      filename(null)
      dir(null)
      mimetype(null)
      filesize(null)
      height(null)
      width(null)
      thumb(null)
      description(null)
- categories
  - 3Mecanicos & Carros
  - 2Floristas
  - 1Relaxation and Spas
  - 4Salones de belleza
  - 5Restaurantes
  - 6Dental - Sin Blanquimientos
  - 7Medicina Estetica - Incluyendo Blanquimientos
  - 8Mascotas
  - 9Hoteles
  - 10Reductivos, incluyendo Celulitis
  - 11Electronicos
  - 12Ropa y Zapatos
  - 13Otros Productos
  - 14Deportes Extremos
  - 15Medicina, Doctores, y otras cosas medicas
  - 16Clases y cursos
  - 17Conciertos
  - 18Gimnasios, Baile, Yoga, etc
  - 19Fotografia
  - 20Lentes
  - 21Clases de manejo
  - 22Otro
- neighborhoods
  - 0Generales para El Salvador
  - 2Generales para Guatemala
  - 3Santa Tecla y Merliot
  - 4Metrocentro y Colonia Médica
  - 5Plaza Mundo y Soyapango
  - 6Chalatenango
  - 7San Benito y Escalón
  - 8Mixco
  - 9Antigua Guatemala
  - 10Zona Metropolitana
- user(false)
- user_available_balance
- meta_for_layout
  - keywordsCupón Club | Enormes descuentos
  - descriptionEnormes descuentos en los mejores servicios de San Salvador! Spas, salones, restaurantes, deportes extremos y más.
- js_vars_for_layout
  - cfg
    - lang
      Are you sure you want to ¿Está seguro que desea
      Please select atleast one record!Por favor, seleccione al menos un récord!
      Are you sure you want to do this action?¿Estás seguro que quieres hacer esta acción?
      Please enter valid original price.Por favor, introduzca precio original válido.
      Discount percentage should be less than 100.porcentaje de descuento debe ser inferior a 100.
      Discount amount should be less than original price.importe del descuento debe ser menor que el precio original.
      Are you sure do you want to change the status? Once the status is changed you cannot undo the status.El comerciante mantiene una lista de los cupones utilizados. Usted puede marcar esta tal como se utiliza para sus propios archivos si lo desea. No se como se usa la marca no le permitirá volver a utilizarlo
      By clicking this button you are confirming your purchase. Once you confirmed amount will be deducted from your wallet and you can not undo this process. Are you sure you want to confirm this purchase?Al hacer clic en este botón estas confirmando tu compra. Una vez confirmada la cantidad se deducirá de su saldo y no se puede deshacer este proceso. ¿Estas seguro que desea confirmar esta compra?
      Google map could not find your location, please enter known location to googlemapa de Google no pudo encontrar su ubicación, por favor escribe ubicación conocida de google
      Invalid extension, Only csv, txt are allowedextensión no válido, sólo se permiten csv, txt
      StateDepartamento
      departmentDepartamento
      YearsAños
      MonthsMeses
      WeeksSemanas
      Days Días
    - icm
    - path_relative/
    - path_absolutehttps://www.playpen.cuponclub.net/
    - date_formatM d, Y
    - today_date2026-10-21
    - site_namecupon_club

Guatemala

Para comprar en línea:

¿No tienes una cuenta?

¿Ya tienes una cuenta?

Ingresar

Para comprar con efectivo:

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Timers

Logs

error.log

debug.log

Memory

View Variables