INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_pricing.price FROM xcart_products, xcart_pricing , xcart_products_categories LEFT JOIN xcart_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_pricing.variantid = 0 AND ((xcart_extra_field_values.value LIKE '%Other%' AND xcart_extra_fields.fieldid = '1')) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid='96' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_pricing.price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories LEFT JOIN xcart_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='96' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_pricing.variantid = 0 AND ((xcart_extra_field_values.value LIKE '%Other%' AND xcart_extra_fields.fieldid = '1')) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid
Online record and book shop, second hand records and rare books.
Education
:: Non-Fiction
:: Books
:: Elvis Shakespeare
