U bent hier:

Home » Poker Sets » Pokerset 500 » Caesar Poker Club Poker Set 500

Caesar Poker Club Poker Set 500

4 beoordelingen | Schrijf een beoordeling

Beschikbaarheid: Niet in stock: levertermijn ongeveer twee weken.

Product ID: SET-CAES-500

€109,95

Beschrijving

Een prachtige, luxueuze poker set van 500 "Caesar Poker Club" poker chips.

De "Caesar Poker Club" reeks is een reeks kwalitatieve, 14g clay composite poker chips met een uniek Romeins design. De complete serie bestaat uit de waarden 1, 5, 25, 100, 500, 1000 en 5000, waardoor ze voor allerlei verschillende pokergames te gebruiken zijn: van medium tot high stakes cash games en uiteraard ook voor reguliere pokertornooien of sit&go tornooitjes. Door hun knappe design zijn deze chips op elke pokertafel een echte eye-catcher.

Specificaties:

Hoeveelheid: 500
Materiaal: 13,5 gram hoogwaardige clay composite
Verpakking: 500 chips in aluminium pokerkoffer
Extra: 1 Standaard Dealerbutton, 5 dobbelstenen, 2 decks kartonnen pokerkaarten.

De standaardindeling van de pokerset:

Waarde 1 Wit: 100 stuks
Waarde 5 Rood: 150 stuks
Waarde 25 Groen: 150 stuks
Waarde 100 Zwart: 75 stuks
Waarde 500 Geel: 25 stuks

Je kan deze pokerset ook naar eigen wensen indelen uit alle waardes die we hebben tegen een kleine vergoeding van €5. Klik bovenaan op de groene knop 'Personaliseren' en kies daar de gewenste samenstelling van de chips en kies eventuele upgrades voor de pokerkaarten, de dealer button en de pokerkoffer.

Beoordelingen

Foets Steven

27-01-2014

Deze Chips zijn Geweldig,ze nodigen uit om ermee te spelen.Ze voelen Super leuk aan,net The Real Thing. zoals hierboven al vermeld is, "a must have " item voor de beginnende pokerspelers die net iets meer willen.
Het echte casino gevoel komt zeker boven als je deze Chips in handen hebt.

Een echte aanrader...

Wim

21-06-2013

Deze Chips hebben een super look 'n' feel, al mijn poker buddy's vinden het zalig spelen met deze chips . Is zeker "a must have " idem voor de pokerspelers die net iets meer willen
Deze set van 500 chips zal in de toekomst zeker uitgebreid worden naar 800 chips want van deze prachtige chips kunnen er niet genoeg op tafel liggen

thnx aan het "pokerhandel "team voor een weeral super correcte service

Franky

26-06-2012

Superknap design op echt supermooie, zware poker chips. Wij spelen zowel cash game als sit & go met deze chips en ze zijn perfect voor een volle tafel van 10 spelers. Vooral de chips van 5 en 25 (wij spelen ze als 5 cent en 25 cent) zijn bij ons veel in gebruik, en ze zien er geweldig goed uit.

Filip Van Langendonck

03-12-2014

Snelle levering, goede communicatie, betrouwbare leverancier ! top!

Schrijf hieronder een review van dit product, en help zo anderen een weloverwogen keuze maken tijdens het winkelen!

Er klopt iets niet met de gekozen hoeveelheid. U koos items en u moet er in totaal kiezen

Verander hier de samenstelling van deze set

€0,00 extra

Wijzig samenstelling

Product	Aantal
Caesar Poker Club Poker Chips 1
Caesar Poker Club Poker Chips 5
Caesar Poker Club Poker Chips 25
Caesar Poker Club Poker Chips 100
Caesar Poker Club Poker Chips 500
Caesar Poker Club Poker Chips 1000
Caesar Poker Club Poker Chips 5000

Je aangepaste prijs €109,95

Annuleren

Volgende delen van deze set zijn aanpasbaar

Kartonnen speelkaarten BASIC Dual Deck
Wissel Bekijk alternatieven Annuleren
Copag 100% Plastic Dual Deck Poker Size
€12,95 extra
Wissel Bekijk alternatieven Annuleren
Modiano Golden Trophy Jumbo Index Dual Deck
€9,95 extra
Wissel Bekijk alternatieven Annuleren
Modiano Platinum 100% Acetate Jumbo Index Dual Deck
€19,95 extra
Wissel Bekijk alternatieven Annuleren
WPT 100% Plastic Dual Deck
€18,95 extra
Wissel Bekijk alternatieven Annuleren

Message	Memory use
Component initialization	8.54 MB
Controller action start	11.13 MB
Controller render start	13.59 MB
View render complete	16.05 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	114.87
Event: Controller.initialize	56.49
Event: Controller.startup	1.46
Controller action	564.85
Event: Controller.beforeRender	27.05
» Processing toolbar data	26.21
Rendering View	118.96
» Event: View.beforeRender	0.05
» Rendering APP/View/Bundles/view.ctp	49.95
» » Rendering APP/View/Themed/Pokerhandel/Elements/bundle/detail.ctp	46.36
» » » Rendering APP/View/Elements/addthis.ctp	0.18
» » » Rendering APP/View/Elements/group/bundle-upgradables.ctp	35.86
» » » » Rendering APP/View/Elements/group/bundle-item.ctp	0.51
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp	0.42
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #2	0.25
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #2	0.43
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #3	0.25
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #3	0.39
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #4	0.29
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #4	0.37
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #5	0.25
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #5	0.50
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp	0.92
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #6	0.39
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #2	1.14
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #7	0.62
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #3	0.82
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #8	0.35
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #4	0.82
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #9	0.35
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #5	0.85
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #10	0.41
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #6	0.29
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #11	0.36
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #7	0.39
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #12	0.36
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #8	0.25
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #13	0.36
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #9	0.25
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #14	0.37
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #10	0.24
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #15	0.59
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #6	0.96
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #16	0.43
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #7	1.21
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #17	0.55
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #8	1.23
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #18	0.59
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #9	1.25
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #19	0.56
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #10	1.01
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #20	0.42
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #11	0.23
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #21	0.42
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #12	0.25
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #22	0.46
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #13	0.29
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #23	0.38
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #14	0.25
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #24	0.39
» » » » Rendering APP/View/Elements/group/bundle-item.ctp #15	0.25
» » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #25	0.38
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #11	0.97
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #26	0.43
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #12	0.92
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #27	0.44
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #13	1.09
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #28	0.41
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #14	0.97
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #29	0.42
» » » » Rendering APP/View/Elements/group/bundle-upgrade.ctp #15	0.94
» » » » » Rendering APP/View/Elements/group/bundle-buttons.ctp #30	0.38
» Event: View.afterRender	0.04
» Event: View.beforeLayout	0.05
» Rendering APP/View/Layouts/default.ctp	24.06
» » Rendering APP/View/Elements/layout/facebook-jssdk.ctp	0.18
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp	8.38
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp	1.00
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp	2.22
» » Rendering APP/View/Elements/layout/top-notice.ctp	0.31
» » Rendering APP/View/Elements/layout/content.ctp	1.69
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp	1.31
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp	0.59
» » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2	1.67
» » » Rendering APP/View/Elements/layout/footer-hours.ctp	0.37
» » » Rendering APP/View/Elements/layout/footer-contact.ctp	0.16
Event: View.afterLayout	0.00

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_id` = 365 AND `Image`.`group_model` = 'Productgroup'	1	1	2	maybe slow
SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (417)	0	0	1	maybe slow
SELECT `Product`.`id`, `Product`.`SKU`, `Product`.`ehale`, `Product`.`price`, `Product`.`promoprice`, `Product`.`purchaseprice`, `Product`.`wholesaleprice`, `Product`.`stock`, `Product`.`criticalstock`, `Product`.`dropship`, `Product`.`outofstock`, `Product`.`green`, `Product`.`weight`, `Product`.`width`, `Product`.`height`, `Product`.`depth`, `Product`.`productgroup_id`, `Product`.`created`, `Product`.`modified`, `Product`.`sorting`, `Product`.`available`, `Product`.`endoflife`, `Product`.`warehouse_location`, `Product`.`sellable`, `Product`.`exported`, `Product`.`expires`, `Product`.`status`, `Product`.`barcode`, `Product`.`contains_nicotine` FROM `tbiback_tbshops`.`products` AS `Product` WHERE `Product`.`id` = 360	1	1	0
SELECT `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` WHERE `Productgroup`.`id` = 307	1	1	0
SELECT `Brand`.`name` FROM `tbiback_tbshops`.`brands` AS `Brand` WHERE `Brand`.`id` = 0	0	0	0
SELECT `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` FROM `tbiback_tbshops`.`descriptions` AS `Description` WHERE `Description`.`group_id` = 307 AND `Description`.`group_model` = 'Productgroup'	1	1	3	maybe slow
SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_id` = 307 AND `Image`.`group_model` = 'Productgroup'	2	2	2
SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (360)	0	0	1	maybe slow
SELECT `Product`.`id`, `Product`.`SKU`, `Product`.`ehale`, `Product`.`price`, `Product`.`promoprice`, `Product`.`purchaseprice`, `Product`.`wholesaleprice`, `Product`.`stock`, `Product`.`criticalstock`, `Product`.`dropship`, `Product`.`outofstock`, `Product`.`green`, `Product`.`weight`, `Product`.`width`, `Product`.`height`, `Product`.`depth`, `Product`.`productgroup_id`, `Product`.`created`, `Product`.`modified`, `Product`.`sorting`, `Product`.`available`, `Product`.`endoflife`, `Product`.`warehouse_location`, `Product`.`sellable`, `Product`.`exported`, `Product`.`expires`, `Product`.`status`, `Product`.`barcode`, `Product`.`contains_nicotine` FROM `tbiback_tbshops`.`products` AS `Product` WHERE `Product`.`id` = 361	1	1	0
SELECT `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` WHERE `Productgroup`.`id` = 308	1	1	0
SELECT `Brand`.`name` FROM `tbiback_tbshops`.`brands` AS `Brand` WHERE `Brand`.`id` = 0	0	0	0
SELECT `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` FROM `tbiback_tbshops`.`descriptions` AS `Description` WHERE `Description`.`group_id` = 308 AND `Description`.`group_model` = 'Productgroup'	1	1	2	maybe slow
SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_id` = 308 AND `Image`.`group_model` = 'Productgroup'	2	2	2
SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (361)	0	0	1	maybe slow
SELECT `BundlesUpgrade`.`id`, `BundlesUpgrade`.`product_id`, `BundlesUpgrade`.`bundle_id`, `BundlesUpgrade`.`bundles_product_id`, `BundlesUpgrade`.`price` FROM `tbiback_tbshops`.`bundles_upgrades` AS `BundlesUpgrade` WHERE `BundlesUpgrade`.`bundles_product_id` IN (286, 287, 288, 289, 290, 291, 292, 293, 352, 600, 601)	12	12	0
SELECT `Product`.`id`, `Product`.`SKU`, `Product`.`ehale`, `Product`.`price`, `Product`.`promoprice`, `Product`.`purchaseprice`, `Product`.`wholesaleprice`, `Product`.`stock`, `Product`.`criticalstock`, `Product`.`dropship`, `Product`.`outofstock`, `Product`.`green`, `Product`.`weight`, `Product`.`width`, `Product`.`height`, `Product`.`depth`, `Product`.`productgroup_id`, `Product`.`created`, `Product`.`modified`, `Product`.`sorting`, `Product`.`available`, `Product`.`endoflife`, `Product`.`warehouse_location`, `Product`.`sellable`, `Product`.`exported`, `Product`.`expires`, `Product`.`status`, `Product`.`barcode`, `Product`.`contains_nicotine` FROM `tbiback_tbshops`.`products` AS `Product` WHERE `Product`.`id` = 460	1	1	0
SELECT `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` WHERE `Productgroup`.`id` = 405	1	1	0
SELECT `Brand`.`name` FROM `tbiback_tbshops`.`brands` AS `Brand` WHERE `Brand`.`id` = 0	0	0	0
SELECT `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` FROM `tbiback_tbshops`.`descriptions` AS `Description` WHERE `Description`.`group_id` = 405 AND `Description`.`group_model` = 'Productgroup'	1	1	2	maybe slow
SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_id` = 405 AND `Image`.`group_model` = 'Productgroup'	1	1	2	maybe slow
SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (460)	0	0	1	maybe slow
SELECT `Product`.`id`, `Product`.`SKU`, `Product`.`ehale`, `Product`.`price`, `Product`.`promoprice`, `Product`.`purchaseprice`, `Product`.`wholesaleprice`, `Product`.`stock`, `Product`.`criticalstock`, `Product`.`dropship`, `Product`.`outofstock`, `Product`.`green`, `Product`.`weight`, `Product`.`width`, `Product`.`height`, `Product`.`depth`, `Product`.`productgroup_id`, `Product`.`created`, `Product`.`modified`, `Product`.`sorting`, `Product`.`available`, `Product`.`endoflife`, `Product`.`warehouse_location`, `Product`.`sellable`, `Product`.`exported`, `Product`.`expires`, `Product`.`status`, `Product`.`barcode`, `Product`.`contains_nicotine` FROM `tbiback_tbshops`.`products` AS `Product` WHERE `Product`.`id` = 218	1	1	0
SELECT `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` WHERE `Productgroup`.`id` = 195	1	1	0
SELECT `Brand`.`name` FROM `tbiback_tbshops`.`brands` AS `Brand` WHERE `Brand`.`id` = 0	0	0	0
SELECT `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` FROM `tbiback_tbshops`.`descriptions` AS `Description` WHERE `Description`.`group_id` = 195 AND `Description`.`group_model` = 'Productgroup'	1	1	2	maybe slow
SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_id` = 195 AND `Image`.`group_model` = 'Productgroup'	1	1	2	maybe slow
SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (218)	0	0	1	maybe slow
SELECT `Product`.`id`, `Product`.`SKU`, `Product`.`ehale`, `Product`.`price`, `Product`.`promoprice`, `Product`.`purchaseprice`, `Product`.`wholesaleprice`, `Product`.`stock`, `Product`.`criticalstock`, `Product`.`dropship`, `Product`.`outofstock`, `Product`.`green`, `Product`.`weight`, `Product`.`width`, `Product`.`height`, `Product`.`depth`, `Product`.`productgroup_id`, `Product`.`created`, `Product`.`modified`, `Product`.`sorting`, `Product`.`available`, `Product`.`endoflife`, `Product`.`warehouse_location`, `Product`.`sellable`, `Product`.`exported`, `Product`.`expires`, `Product`.`status`, `Product`.`barcode`, `Product`.`contains_nicotine` FROM `tbiback_tbshops`.`products` AS `Product` WHERE `Product`.`id` = 217	1	1	0
SELECT `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` WHERE `Productgroup`.`id` = 194	1	1	0
SELECT `Brand`.`name` FROM `tbiback_tbshops`.`brands` AS `Brand` WHERE `Brand`.`id` = 0	0	0	0
SELECT `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` FROM `tbiback_tbshops`.`descriptions` AS `Description` WHERE `Description`.`group_id` = 194 AND `Description`.`group_model` = 'Productgroup'	1	1	2	maybe slow
SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_id` = 194 AND `Image`.`group_model` = 'Productgroup'	2	2	2
SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (217)	0	0	1	maybe slow
SELECT `Product`.`id`, `Product`.`SKU`, `Product`.`ehale`, `Product`.`price`, `Product`.`promoprice`, `Product`.`purchaseprice`, `Product`.`wholesaleprice`, `Product`.`stock`, `Product`.`criticalstock`, `Product`.`dropship`, `Product`.`outofstock`, `Product`.`green`, `Product`.`weight`, `Product`.`width`, `Product`.`height`, `Product`.`depth`, `Product`.`productgroup_id`, `Product`.`created`, `Product`.`modified`, `Product`.`sorting`, `Product`.`available`, `Product`.`endoflife`, `Product`.`warehouse_location`, `Product`.`sellable`, `Product`.`exported`, `Product`.`expires`, `Product`.`status`, `Product`.`barcode`, `Product`.`contains_nicotine` FROM `tbiback_tbshops`.`products` AS `Product` WHERE `Product`.`id` = 213	1	1	0
SELECT `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` WHERE `Productgroup`.`id` = 190	1	1	0
SELECT `Brand`.`name` FROM `tbiback_tbshops`.`brands` AS `Brand` WHERE `Brand`.`id` = 0	0	0	0
SELECT `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` FROM `tbiback_tbshops`.`descriptions` AS `Description` WHERE `Description`.`group_id` = 190 AND `Description`.`group_model` = 'Productgroup'	1	1	2	maybe slow
SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_id` = 190 AND `Image`.`group_model` = 'Productgroup'	1	1	2	maybe slow
SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (213)	0	0	1	maybe slow
SELECT `Product`.`id`, `Product`.`SKU`, `Product`.`ehale`, `Product`.`price`, `Product`.`promoprice`, `Product`.`purchaseprice`, `Product`.`wholesaleprice`, `Product`.`stock`, `Product`.`criticalstock`, `Product`.`dropship`, `Product`.`outofstock`, `Product`.`green`, `Product`.`weight`, `Product`.`width`, `Product`.`height`, `Product`.`depth`, `Product`.`productgroup_id`, `Product`.`created`, `Product`.`modified`, `Product`.`sorting`, `Product`.`available`, `Product`.`endoflife`, `Product`.`warehouse_location`, `Product`.`sellable`, `Product`.`exported`, `Product`.`expires`, `Product`.`status`, `Product`.`barcode`, `Product`.`contains_nicotine` FROM `tbiback_tbshops`.`products` AS `Product` WHERE `Product`.`id` = 403	1	1	0

Caesar Poker Club Poker Set 500

Specificaties:

De standaardindeling van de pokerset:

Foets Steven

Wim

Franky

Filip Van Langendonck

Verander hier de samenstelling van deze set

€0,00 extra

Je aangepaste prijs €109,95

Volgende delen van deze set zijn aanpasbaar

Kartonnen speelkaarten BASIC Dual Deck

Copag 100% Plastic Dual Deck Poker Size

€12,95 extra

Modiano Golden Trophy Jumbo Index Dual Deck

€9,95 extra

Modiano Platinum 100% Acetate Jumbo Index Dual Deck

€19,95 extra

WPT 100% Plastic Dual Deck

€18,95 extra

U kan één van de volgende kiezen

Kartonnen s...

€0,00 extra

Copag 100% ...

€12,95 extra

Modiano Gol...

€9,95 extra

Modiano Pla...

€19,95 extra

WPT 100% Pl...

€18,95 extra

Pokerkoffer 500 Aluminium/Zwart

Imitatieleder Pokerkoffer 500 Chips, leeg

€14,95 extra

Deluxe Lederen Pokerkoffer 500 (Echt leder)

€79,95 extra

Luxueuze Houten Pokerkoffer 500 Chips, Leeg

€74,95 extra

Luxueuze Houten Pokerkoffer 500 Chips "Diamond", Leeg

€74,95 extra

U kan één van de volgende kiezen

Pokerkoffer...

€0,00 extra

Imitatieled...

€14,95 extra

Deluxe Lede...

€79,95 extra

Luxueuze Ho...

€74,95 extra

Luxueuze Ho...

€74,95 extra

Basic Dealer Button Wit

Dealer Button Premium Metaal

€5,50 extra

The Ultimate Dealer Button

€18,25 extra

Duotone Dealer Button Rood/Zwart

€2,30 extra

Dealer Button XL Zwart & Wit

€7,25 extra

U kan één van de volgende kiezen

Basic Deale...

€0,00 extra

Dealer Butt...

€5,50 extra

The Ultimat...

€18,25 extra

Duotone Dea...

€2,30 extra

Dealer Butt...

€7,25 extra

Je aangepaste prijs €109,95

Request History

Sql Logs

default

Total Time: 325 ms Total Queries: 280 queries

Query Explain:

Memory

Timers

Total Time: 325 ms
Total Queries: 280 queries