loader
 

Furniture

Query
Template: /var/www/voyagerinteriors.com.au/devel/display/page-products.cfm
Execution Time: 16.4 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
SELECT
productID,
productName,
photoList,
productIsNew
FROM dbo.voy_products
WHERE 1=1
AND prodCategories LIKE '%10008%'
AND productDisplay LIKE '%public%'
AND productIsNew NOT LIKE '%floorstock%'
AND productIsNew NOT LIKE '%inStockOnly%'
AND productIsNew NOT LIKE '%clearance%'
ORDER BY RAND(), productIsNew DESC, productName
productIDproductNamephotoListproductIsNew