Showing 0 results
Query Template: C:\home\coolgifts.nz\wwwroot\system\dataobjects\products.cfc Execution Time: 0.862 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 '2023-10-03 16:34:08'} and product.prod_saleflagfinish >= {ts '2023-10-03 16:34:08'} 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 | |||||||||||||||||||||||||||
productid | prod_menutitle | prod_handle | pth | currency_code | prod_image1 | prod_image2 | prod_image3 | prod_image4 | prod_htmltext | prod_shortdesc | prod_shortdesctext | typeofproductid | prod_saleflag | prod_newflag | prod_saleflagstart | prod_newflagstart | prod_saleflagfinish | prod_newflagfinish | var_price | prod_reviewaverage | prod_reviewcount | prod_featuredproduct | prod_hotflag | prod_hotflagstart | prod_hotflagfinish |