MORE WAYS TO SHOP

REFINE YOUR SEARCH

We do not have products available in this category for the selected option(s)

If you would like to view ALL items in this category click "Ok"

Otherwise, click "Cancel" to return to the selected option(s).

View ALL Cancel

Bulbs Count

Besa Lighting Copa

Besa Lighting 1TT-4930VM-BR Besa Copa Stem Pendant
More
options
Bronze or Satin Nickel
  • Bronze
  • Satin Nickel

Besa Lighting 1TT-4930VM-BR Besa Copa Stem Pendant

IN-STOCK
$305.00
Model No: 1TT-4930VM-BR
Besa Lighting
Dimensions:
3.1"W
9.9"H
10.0"L
Free Shipping!
Please Wait
Besa Lighting 1SW-440307-SN Besa Copa 3 Mini Sconce
More
options
Bronze or Satin Nickel
  • Bronze
  • Satin Nickel

Besa Lighting 1SW-440307-SN Besa Copa 3 Mini Sconce

IN-STOCK
$235.00
Model No: 1SW-440307-SN
Besa Lighting
Dimensions:
5.0"W
10.0"H
Please Wait
Besa Lighting 1TT-493018-BR Besa Copa Stem Pendant
More
options
Bronze or Satin Nickel
  • Bronze
  • Satin Nickel

Besa Lighting 1TT-493018-BR Besa Copa Stem Pendant

IN-STOCK
$305.00
Model No: 1TT-493018-BR
Besa Lighting
Dimensions:
3.1"W
9.9"H
10.0"L
Free Shipping!
Please Wait
Besa Lighting 1TT-493019-BR Besa Copa Stem Pendant
More
options
Bronze or Satin Nickel
  • Bronze
  • Satin Nickel

Besa Lighting 1TT-493019-BR Besa Copa Stem Pendant

IN-STOCK
$305.00
Model No: 1TT-493019-BR
Besa Lighting
Dimensions:
3.1"W
9.9"H
10.0"L
Free Shipping!
Please Wait
Lucee 5.2.7.62 Error (database)
Message column [ISUSONLY] not found in query, columns are [ID,CODE,CONTENT,TITLE,SORT,TEMPLATE,MAIN_ID]
SQL SELECT
p.id, p.sku, p.name_short, p.discontinued, p.manufacturer_id,
p.id as product_id,
Round(p.price_discount_original, 2) AS price_discount_original,

Round(p.price_discount, 2) AS price,
Round(p.price_discount, 2) AS price_discount,
'USD' AS CurrencyCode,
IsNull(inv_us.quantity, 0) AS quantity, inv_us.update_date,

p.finish_1, p.finish_1_facet,
p.family,

p.image_exist,
p.price_regular,
p.trackQuantity,

p.productType,
p.CountryOfOrigin,
p.ParentSKU, p.IsClearance, p.ConditionType,
p.upccode, p.UOM, p.UMQT, p.minOrder_qty, p.minOrderQuantity_limit,
IsNull(ps.isusonly, 1) AS isusonly, IsNull(ps.IsFreeGroundShipping, 0) AS IsFreeGroundShipping, IsNull(ps.ProductFreightShipment, 0) AS ProductFreightShipment
FROM products p WITH (NOLOCK)
LEFT JOIN products_ShippingOptions ps WITH (NOLOCK) ON p.id=ps.product_id


LEFT JOIN inventory_store inv_us WITH (NOLOCK) ON inv_us.product_id = p.id AND inv_us.distributor_id = p.distributor_id

WHERE p.id = 519697
Stacktrace The Error Occurred in
/components../site/public/products/qry_product_detail_search.cfm: line 40
called from /components../site/public/products/get_searchProduct.cfm: line 1
called from /components../site/public/products/dsp_index.cfm: line 245
called from /components../site/public/dsp_index.cfm: line 19
called from E:\Production\EliteFixtures\Site\components\ViewController.cfc: line 72
called from /cache_content.cfc: line 312
called from E:\Production\EliteFixtures\Site\layouts\EFNewdefault\Site\Public\products\inc_search_3x4.cfm: line 49
called from E:\Production\EliteFixtures\Site\layouts\EFNewdefault\Site\Public\products\dsp_search_results.cfm: line 71
called from E:\Production\EliteFixtures\Site\site\public\products\dsp_search_results.cfm: line 11
called from E:\Production\EliteFixtures\Site\layouts\EFNewdefault\Site\Public\manufacturers\dsp_view.cfm: line 77
called from E:\Production\EliteFixtures\Site\site\public\manufacturers\dsp_view.cfm: line 14
called from E:\Production\EliteFixtures\Site\index_PageController.cfm: line 129
called from E:\Production\EliteFixtures\Site\index.cfm: line 116
called from E:\Production\EliteFixtures\Site\application.cfc: line 96
Java Stacktrace lucee.runtime.exp.DatabaseException: column [ISUSONLY] not found in query, columns are [ID,CODE,CONTENT,TITLE,SORT,TEMPLATE,MAIN_ID]
  at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:920)
  at lucee.runtime.type.QueryImpl.get(QueryImpl.java:1876)
  at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:263)
  at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1516)
  at __138.site._public.products.qry_product_detail_search_cfm$cf.call(/components../site/public/products/qry_product_detail_search.cfm:40)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at __138.site._public.products.get_searchproduct_cfm$cf.call(/components../site/public/products/get_searchProduct.cfm:1)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at __138.site._public.products.dsp_index_cfm$cf.call(/components../site/public/products/dsp_index.cfm:245)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at __138.site._public.dsp_index_cfm$cf.call(/components../site/public/dsp_index.cfm:19)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at viewcontroller_cfc$cf.udfCall(/components/ViewController.cfc:72)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:653)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:567)
  at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2005)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:833)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1737)
  at cache_content_cfc$cf.udfCall1(/cache_content.cfc:312)
  at cache_content_cfc$cf.udfCall(/cache_content.cfc)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:653)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:567)
  at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2005)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:833)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1737)
  at layouts.efnewdefault.site.public.products.inc_search_3x4_cfm$cf.call(/layouts/EFNewDefault/Site/Public/products/inc_search_3x4.cfm:49)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at layouts.efnewdefault.site.public.products.dsp_search_results_cfm$cf.call(/layouts/EFNewDefault/Site/Public/products/dsp_search_results.cfm:71)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at site._public.products.dsp_search_results_cfm$cf.call(/site/public/products/dsp_search_results.cfm:11)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at layouts.efnewdefault.site.public.manufacturers.dsp_view_cfm$cf.call(/layouts/EFNewDefault/Site/Public/manufacturers/dsp_view.cfm:77)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at site._public.manufacturers.dsp_view_cfm$cf.call(/site/public/manufacturers/dsp_view.cfm:14)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at index_pagecontroller_cfm$cf.call(/index_PageController.cfm:129)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at index_cfm$cf.call(/index.cfm:116)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at application_cfc$cf.udfCall(/application.cfc:96)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:651)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:567)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1988)
  at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:424)
  at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2464)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2454)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2427)
  at lucee.runtime.engine.Request.exe(Request.java:44)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1091)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1039)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:764)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:801)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
  at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
  at sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
  at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
  at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:486)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Thread.java:748)
 
Timestamp 3/30/20 9:34:01 PM CDT