25% OFF Selected Items. Free Shipping over $79.

Showing 0 results

Query
Template: C:\home\coolgifts.nz\wwwroot\system\dataobjects\products.cfc
Execution Time: 1.25 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
select
product.productid,
prod_menutitle,
product.prod_handle,
defaultproducttype.producttype_handle as pth,
currencyconversion.currency_code,
product.prod_image1,
product.prod_image2,
product.prod_image3,
product.prod_image4,
product.prod_htmltext,
product.prod_shortdesc,
product.prod_shortdesctext,
product.typeofproductid,
product.prod_saleflag,
product.prod_newflag,
product.prod_saleflagstart,
product.prod_newflagstart,
product.prod_saleflagfinish,
product.prod_newflagfinish,
productvariance.var_price,
product.prod_reviewaverage,
product.prod_reviewcount,
product.prod_featuredproduct,
product.prod_hotflag,
product.prod_hotflagstart,
product.prod_hotflagfinish
from
product,
producttype as defaultproducttype,
currencyconversion,
productvariance
where
defaultproducttype.producttypeid = product.defaultproducttypeid
and
product.prod_basecurrencyid = currencyconversion.currencyid
and
product.prod_active = 1
and
product.prod_saleflag = 1
and
product.prod_saleflagstart <= {ts '2021-10-21 01:49:43'}
and
product.prod_saleflagfinish >= {ts '2021-10-21 01:49:43'}
and
product.prod_deleted is null
and
product.siteid = 1
and
product.productid = productvariance.productid
and
productvariance.var_default = 1
order by
product.prod_title
productidprod_menutitleprod_handlepthcurrency_codeprod_image1prod_image2prod_image3prod_image4prod_htmltextprod_shortdescprod_shortdesctexttypeofproductidprod_saleflagprod_newflagprod_saleflagstartprod_newflagstartprod_saleflagfinishprod_newflagfinishvar_priceprod_reviewaverageprod_reviewcountprod_featuredproductprod_hotflagprod_hotflagstartprod_hotflagfinish
Icon

FREE SHIPPING OPTIONS

Spend $79 Get Free Shipping

Icon

30 DAY RETURNS POLICY

100% Satisfaction Guarantee

Icon

PROFESSIONAL SUPPORT 24/7

info@coolgifts.nz

Icon

100% SECURE CHECKOUT

Pay Securely With Trusted End To End Encryption

Start typing and press Enter to search

See all results (0)

Subscribe And Save 10% On Your First Cool Gifts Order