Daily Deals / Miscellaneous
One monster of a deal per day!
1
0
MONDAY: El Centurion Test Flight only $69.98!
$ 69.98
Deal Sold Out
Price Comparison
Sorry, we were not able to find a comparison chart for this product. You might want to try searching our partner pages to compare prices.
Details
Bedecked in an evocative, old-world-style band that enhance the rich color of their Nicaraguan Habano wrappers, El Centurion cigars present a truly stunning and marvelously complex blend from Don Pepin Garcia. A full-flavored, sensual treat, this sampler with 6 cigars is well worth your appraisal.
Leave a Comment
change monster
Name
Subject
R U Human?
change image
Prove It!
Comment
Our Sponsors
Top Ques / Daily Deals / Miscellaneous
1
que(s)
Cigars International Man O' Wa...
The original Man O’ War is so lovely that you might hesitate to snip the cap for fear of disruptin......
1
que(s)
Summers Estate Wines 2007 Andr...
Regular Retail Price: $26.00 The Wine Spies One Day Price: $20.00 ......
1
que(s)
Graveyard Mall Good Morning! -...
Good Morning!Women's Branded Sunglasses: 9 Pair Compare at: $179.99Our price: $9.99Men's Branded Sun......
1
que(s)
QVC Carolyn Pollack Sterling M...
Some people keep journals to remember their road trips. But, to commemorate her Summer Across Americ......
1
que(s)
Collections Etc. Singing Bird ...
Audubon wall/tabletop clock at the top of each hour, lets out with that bird's song. Requires 3 "AA"......
Advertisment
(default) 57 queries took 636 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `deals`17171
2DESCRIBE `merchants`13131
3DESCRIBE `verify_imgs`331
4DESCRIBE `comments`10101
5DESCRIBE `ratings`551
6DESCRIBE `user_comments`881
7DESCRIBE `users`11111
8DESCRIBE `report_deals`771
9DESCRIBE `report_comments`881
10DESCRIBE `categories`331
11SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
12SELECT name,id,temp_cat,website FROM merchants WHERE id ="12"110
13SELECT category,sub_category FROM user_deals where uid = 12 AND start_date='2010-02-08 17^02^10'000
14DESCRIBE `sponsored_deals`441
15DESCRIBE `reviews`991
16DESCRIBE `user_reviews`771
17SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
18UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519992;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283519992 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'10
19SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
20 ( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description,uid as ID, link,rating as ratingOrdered, que_count as rating, user_deals.img,monsters.img as logo, username as name,0 as shipping, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND sub_category='Miscellaneous' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description,merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, logo, name,shipping, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND sub_category='Miscellaneous' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 555614
21SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
22UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519992;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283519993 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'10
23SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
24 (SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "109" AND comments.start_date = "2010-09-03 07:09:10") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "109" AND user_comments.start_date = "2010-09-03 07:09:10" )220
25SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "109" AND date = "2010-09-03 07:09:10" AND TIMEDIFF("2010-09-03 08:09:53", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"001
26SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
27UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519993;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283519993 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'10
28SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
29 (SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "60" AND comments.start_date = "2010-09-03 07:09:04") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "60" AND user_comments.start_date = "2010-09-03 07:09:04" )220
30SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "60" AND date = "2010-09-03 07:09:04" AND TIMEDIFF("2010-09-03 08:09:53", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"001
31SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
32UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519993;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283519993 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'00
33SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
34 (SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "112" AND comments.start_date = "2010-09-03 06:09:21") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "112" AND user_comments.start_date = "2010-09-03 06:09:21" )220
35SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "112" AND date = "2010-09-03 06:09:21" AND TIMEDIFF("2010-09-03 08:09:53", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"002
36SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
37UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519993;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283519993 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'00
38SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
39 (SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "92" AND comments.start_date = "2010-09-03 06:09:15") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "92" AND user_comments.start_date = "2010-09-03 06:09:15" )220
40SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "92" AND date = "2010-09-03 06:09:15" AND TIMEDIFF("2010-09-03 08:09:53", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"002
41SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
42UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519993;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283519993 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'00
43SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
44 (SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "83" AND comments.start_date = "2010-09-03 06:09:12") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "83" AND user_comments.start_date = "2010-09-03 06:09:12" )220
45SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "83" AND date = "2010-09-03 06:09:12" AND TIMEDIFF("2010-09-03 08:09:53", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"000
46SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "12" and deals.start_date="2010-02-08 17:02:10"110
47SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '12' and start_date = '2010-02-08 17:02:10'110
48SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "12" AND date = "2010-02-08 17^02^10" AND TIMEDIFF("2010-09-03 08:09:53", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"001
49 (SELECT comments.name as name, comments.subject as subject, comments.body as body, comments.posted_on as posted_on, "anon" as user_type, comments.id as ident_id, monsters.img as img FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "12" AND comments.start_date = "2010-02-08 17^02^10") UNION ALL ( SELECT users.username as name, user_comments.subject as subject, user_comments.body as body, user_comments.posted_on as posted_on, user_comments.user_id as user_type, user_comments.posted_on as ident_id, monsters.img as img FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "12" AND user_comments.start_date = "2010-02-08 17^02^10" ) ORDER BY posted_on desc002
50SELECT img,code from verify_imgs13130
51SELECT * from monsters where is_live ="true" and rights = "public"770
52SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="12"110
53SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
54UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519993;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283519993 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'00
55SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
56SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'110
57UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283519993;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283519993 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'00