INVALID SQL: 1054 : Unknown column 'c.membership' in 'where clause' SQL QUERY FAILURE:SELECT DISTINCT p.productid FROM xcart_products AS p, xcart_categories AS c, xcart_products_categories AS pc WHERE pc.productid = p.productid AND pc.categoryid = c.categoryid AND p.forsale = 'Y' AND c.avail = 'Y' AND p.avail > 0 AND (c.membership = '' OR c.membership = '') AND p.add_date >= '1282761847' ORDER BY add_date DESC
|
|