💀👻 Cute, Creepy, Collectible — Summerween Stock Shipping Now! Shop Now

Largest Selection Of Wholesale Licensed Toys
License-2-Play Largest Selection Of Wholesale Licensed Toys

Wholesale Deddy Bears® 'Zombear' Awake Your Soul Citrus Chiller Energy Drink - 12 oz | 17689

Item Number : 17689

UPC : 611508176892

Character Type : Deddy Bears

Manufacturer : Boston America Candy

Login

Awaken Your Inner Beast with Zombear's Citrus Chiller!

Get ready to awaken your soul with the Deddy Bears 'Zombear' Citrus Chiller Energy Drink! Packed with a burst of refreshing citrus flavor, this 12 oz. energy drink is designed to give you the boost you need to power through your day or night. Featuring the fun and quirky Zombear character, this drink is perfect for those who crave a tasty and energizing pick-me-up with a spooky twist. Stock up and let your customers experience the revitalizing energy of Deddy Bears!

Key Features:

  • REFRESHING CITRUS FLAVOR: A zesty and invigorating citrus chiller that energizes and refreshes.
  • UNIQUE ZOMBEAR DESIGN: Eye-catching can design featuring the playful and spooky Zombear character, perfect for fans of fun and fright.
  • ENERGY BOOST: Formulated to provide a quick and sustained energy lift to keep you going.
  • 12 OZ. CONVENIENCE: Perfect single-serve size for on-the-go refreshment and energy.
  • IDEAL FOR RETAILERS: A must-have addition to your beverage lineup, perfect for attracting customers looking for a unique energy drink experience.

Energize your customers with the quirky, fun, and fiercely flavorful Deddy Bears 'Zombear' Citrus Chiller Energy Drink!

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND D_ITEM_ID <> 6410' at line 5
 
The error occurred in C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm: line 435
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm: line 84
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm: line 1
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/controller.cfm: line 45
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm: line 435
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm: line 84
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm: line 1
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/controller.cfm: line 45
 
433 : 			 WHERE FIND_IN_SET(#val(qryItem.d_related_subcategory)#, d_subcateg) > 0
434 : 	  	</cfquery>--->
435 : 		<cfquery name="getSubcatItem" datasource="#request.dsn#">
436 : 				SELECT *
437 : 				FROM tbl_item_category
SQLSTATE   42000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   lic2
VENDORERRORCODE   1064
SQL   SELECT * FROM tbl_item_category WHERE AND D_ITEM_ID <> (param 1)
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   216.73.216.223
Referrer  
Date/Time   19-Jun-25 10:43 PM
Stack Trace
at cfproduct2ddetail2ecfm709161964._factor7(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm:435) at cfproduct2ddetail2ecfm709161964._factor8(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm:84) at cfproduct2ddetail2ecfm709161964.runPage(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm:1) at cfcontroller2ecfm1692613691.runPage(C:/inetpub/wwwroot/license-2-play/wholesale-toys/controller.cfm:45) at cfproduct2ddetail2ecfm709161964._factor7(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm:435) at cfproduct2ddetail2ecfm709161964._factor8(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm:84) at cfproduct2ddetail2ecfm709161964.runPage(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-detail.cfm:1) at cfcontroller2ecfm1692613691.runPage(C:/inetpub/wwwroot/license-2-play/wholesale-toys/controller.cfm:45) 

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND D_ITEM_ID <> 6410' at line 5
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1658)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cfproduct2ddetail2ecfm709161964._factor7(C:\inetpub\wwwroot\license-2-play\wholesale-toys\product-detail.cfm:435)
	at cfproduct2ddetail2ecfm709161964._factor8(C:\inetpub\wwwroot\license-2-play\wholesale-toys\product-detail.cfm:84)
	at cfproduct2ddetail2ecfm709161964.runPage(C:\inetpub\wwwroot\license-2-play\wholesale-toys\product-detail.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfcontroller2ecfm1692613691.runPage(C:\inetpub\wwwroot\license-2-play\wholesale-toys\controller.cfm:45)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:833)