INVALID SQL: 145 : Table './bwea_xcart/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE:SELECT COUNT(*) FROM xcart_products, xcart_products_categories WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products.forsale='Y' AND xcart_products.avail>'0' AND xcart_products_categories.categoryid='364'
INVALID SQL: 145 : Table './bwea_xcart/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE:SELECT COUNT(*) FROM xcart_products, xcart_products_categories WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products.forsale='Y' AND xcart_products.avail>'0' AND xcart_products_categories.categoryid='398'
INVALID SQL: 145 : Table './bwea_xcart/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE:SELECT COUNT(*) FROM xcart_products, xcart_products_categories WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products.forsale='Y' AND xcart_products.avail>'0' AND xcart_products_categories.categoryid='390'
INVALID SQL: 145 : Table './bwea_xcart/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE:SELECT COUNT(*) FROM xcart_products, xcart_products_categories WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products.forsale='Y' AND xcart_products.avail>'0' AND xcart_products_categories.categoryid='384'
INVALID SQL: 145 : Table './bwea_xcart/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE:SELECT COUNT(xcart_products.productid) FROM xcart_pricing, xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_categories.avail = 'Y' AND xcart_products_categories.categoryid='364' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale = 'Y' AND (IFNULL(xcart_variants.avail, xcart_products.avail) > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_products_categories.orderby ASC, xcart_products.product ASC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bwea/public_html/include/func/func.db.php on line 151
INVALID SQL: 145 : Table './bwea_xcart/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE:SELECT COUNT(xcart_products.productid) FROM xcart_pricing, xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid INNER JOIN xcart_featured_products ON xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='364' INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_categories.avail = 'Y' AND xcart_products.forsale = 'Y' AND (IFNULL(xcart_variants.avail, xcart_products.avail) > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_featured_products.product_order, xcart_products.product ASC
Deals :: BAP!
bap
Search:


Advanced search

  Username   
  Password   
  
  Log in 
  Register 
  Recover password

If Javascript is disabled in your browser click here


Cart is empty
 

View cart
Checkout
Wish list
Orders history





BAP! :: Deals

Deals
Big Agnes Demo Tent Sale
Big Agnes Sleeping Pad Closeouts
Big Agnes DEMO Sleeping Bags