INVALID SQL: 1030 : Got error 122 from storage engine
SQL QUERY FAILURE:SELECT node.*, IF(xcart_categories_lng.categoryid IS NOT NULL AND xcart_categories_lng.category != '', xcart_categories_lng.category, node.category) AS category, xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count, xcart_images_C.image_path, xcart_images_C.image_x, xcart_images_C.image_y, xcart_images_C.imageid FROM xcart_categories AS node LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='en' AND xcart_categories_lng.categoryid=node.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = node.categoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = node.categoryid AND xcart_categories_subcount.membershipid = '' LEFT JOIN xcart_images_C ON node.categoryid = xcart_images_C.id WHERE node.parentid = '0' AND node.avail = 'Y' AND (xcart_category_memberships.membershipid IS NULL OR xcart_category_memberships.membershipid = '') GROUP BY node.categoryid ORDER BY node.lpos, category
Tuff Products :: New Products :: Pistol Scope Mount - Designed by Ichiro Nagata

Home :: New Products :: Pistol Scope Mount - Designed by Ichiro Nagata

        
	Free Standard Shipping

	on all USA orders!

more offers

Pistol Scope Mount - Designed by Ichiro Nagata

(document, 'script', 'facebook-jssdk'));

Pistol Scope Mount - Designed by Ichiro Nagata

Fits Pistols with Pica Tinny Rail, Kimber 1911, Springfield Armory Operator, SIG 1911, SIG 220, SIG 226R, or Similar

Details

ITEM PSMR226

Our price: $139.99