ElderDepot - eldercare and assisted living products for caregivers

INVALID SQL: 1064 : You have an error in your SQL syntax near 'group by xcart_products.productid order by sales_stats DESC, views_stats DESC li' at line 1
SQL QUERY FAILURE:SELECT xcart_products.*, xcart_categories.category, MIN(xcart_pricing.price) AS price FROM xcart_products, xcart_pricing, xcart_categories WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_products.categoryid=xcart_categories.categoryid AND (xcart_categories.membership='' OR xcart_categories.membership='') AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND ( xcart_products.forsale='Y' and xcart_products.avail>0 and xcart_products.views_stats>0 and xcart_products.sales_stats > 0 group by xcart_products.productid order by sales_stats DESC, views_stats DESC limit 5

ElderDepot - eldercare and assisted living products for caregivers

My Account	Contact Us	Shopping Cart
Welcome to Elder Depot!

Shipping & Returns:

Track Your Order
Shipping Policy
Return Policy

Help Section:

Set up your own free
personalized shopping
aisle so you can
simply grab n' go!

Take our Quick Survey
Let us know what you think!

Comments or Suggestions? CLICK HERE

Our Company:

About Us
Policies
Affiliate Program

SALE ITEMS! Check out the November 2008 Special Promotions!

Your Cart :

View cart

	Cart is empty

Delete Cart Contents

Log-In:

Copyright © 2001-2008 by Elder Depot, Inc. All Rights Reserved.
Any use of this site is subject to the terms of use and policies that govern this site.
Copying or reproducing any of the content of this site without written permission from Elder Depot, Inc. is prohibited.