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

Largest Selection Of Wholesale Licensed Toys

Wholesale Trick ‘r Treat Sam Sour Orange Candy in Collectible Tin | 17673

Item Number : 17673

UPC : 611508176731

Character Type : Holiday Candy & Drinks

Manufacturer : Boston America Candy

Embrace the Halloween Spirit with Every Sour Bite!

Add a spooky twist to your candy selection with Trick ‘r Treat Sam Sour Orange Candy in a Collectible Tin! Perfect for Halloween, these sour orange treats come in a fun, themed tin featuring Sam from the iconic horror film. Ideal for fans and candy lovers alike, this 1.5-ounce tin is both a tasty treat and a collector's item. Stock up with this eye-catching display of 12 tins to keep customers coming back for more!

Key Features:

  • SPOOKY COLLECTIBLE TIN: Features Sam from the popular Halloween movie "Trick ‘r Treat."
  • SOUR ORANGE FLAVOR: 1.5 ounces of sour orange sack heads that pack a tangy punch.
  • PERFECT FOR HALLOWEEN: A great addition to your seasonal candy selection.
  • EYE-CATCHING DISPLAY: Comes in a display pack of 12, ready to attract attention on your shelves.
  • IDEAL FOR FANS AND COLLECTORS: A must-have for horror enthusiasts and Trick ‘r Treat fans.

Boost your Halloween sales with this unique candy that combines flavor and fright!

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 <> 6402' 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:44 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 <> 6402' 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)