INVALID SQL: 1176 : Key 'am' doesn't exist in table 'xcart_categories'
SQL QUERY FAILURE:SELECT xcart_categories.categoryid,xcart_categories.parentid,xcart_categories.categoryid_path,xcart_categories.category,xcart_categories.avail,xcart_categories.order_by, IF(xcart_categories_lng.categoryid IS NOT NULL AND xcart_categories_lng.category != '', xcart_categories_lng.category, xcart_categories.category) as category,xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count, IF(xcart_images_C.id IS NOT NULL, 'Y', '') as is_icon, xcart_images_C.image_path FROM xcart_categories USE INDEX (am) LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='US' AND xcart_categories_lng.categoryid=xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = xcart_categories.categoryid AND xcart_categories_subcount.membershipid = '' LEFT JOIN xcart_images_C ON xcart_categories.categoryid = xcart_images_C.id WHERE xcart_categories.parentid IN ('0','0') AND xcart_categories.avail='Y' AND (xcart_category_memberships.membershipid IS NULL OR xcart_category_memberships.membershipid = '') GROUP BY xcart_categories.categoryid ORDER BY xcart_categories.order_by, xcart_categories.category
Bacon Books :: Help zone


	Home


	Shopping Cart


	Contact Us

Tel :+44-20 7278 9490

Special

Manufacturers
Gift certificates

Help

Bacon Books :: Help zone

Help zone

Help zone, gives you access to the information which will help you to understand our site capabilities, the conditions of using our site and you will get a lot of other useful information there.

Help zone

Recover password

Contact us

FAQ (Frequently Asked Questions)

Privacy statement

Terms & Conditions

About our site

Your cart

	Cart is empty

View cart
Checkout
Wish list
Orders history

Authentication

Users online: 7 unregistered customer(s)