INVALID SQL: 1030 : Got error 28 from storage engine
SQL QUERY FAILURE:SELECT xcart_products.productid, IF(xcart_products_lng.product != '', xcart_products_lng.product, xcart_products.product) as product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) as price, xcart_products.descr, xcart_products.fulldescr, IF(xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant, xcart_product_taxes.taxid FROM xcart_pricing, xcart_products LEFT JOIN xcart_products_lng ON xcart_products.productid = xcart_products_lng.productid AND code = 'US' LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_product_taxes ON xcart_product_taxes.productid = xcart_products.productid RIGHT JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid RIGHT JOIN xcart_categories ON xcart_categories.categoryid = xcart_products_categories.categoryid AND xcart_categories.avail = 'Y' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE (xcart_category_memberships.membershipid = '0' OR xcart_category_memberships.membershipid IS NULL) AND'Y' AND (xcart_product_memberships.membershipid = '0' OR xcart_product_memberships.membershipid IS NULL) AND xcart_products.productid = xcart_products_categories.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_products.productid = xcart_pricing.productid AND xcart_pricing.quantity = '1' AND xcart_pricing.membershipid = 0 AND xcart_products.product_type <> 'C' AND <> 'B' AND (xcart_pricing.variantid = 0 OR (xcart_variants.variantid = xcart_pricing.variantid)) AND xcart_products_categories.categoryid IN ('1037','1048','1704','1928','2204','2442','922') AND xcart_products.views_stats > 0 AND xcart_products.sales_stats >= 0 AND locate('charger',xcart_products.product)=0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats * xcart_products.list_price DESC, xcart_products.views_stats DESC LIMIT 8
Pagecomm International :: CASES :: APPLE :: IPOD
  [+] Add Bookmark
  Reseller Home   |   Forms   |   Cart   |   Order History   |   UPS Tracking   |   Contact Us   |   MAP

Search Products

 New Arrivals! Open RSS Feed
 Back In Stock! Open RSS Feed

  • cellet_jelli_case_samsungs4
  • cellet_car_charger
  • cellet_35mm_adaptor
  • cellet_wallet_zipper_case
  • cellet_bluetooth_keyboard


Please authenticate using your Pagecomm Reseller credentials.

Login *
Password *
  Recover password

About California Proposition 65: California's Proposition 65 entitles California consumers to special warnings for products that contain chemicals known to the state of California to cause cancer and birth defects or other reproductive harm if those products expose consumers to such chemicals above certain threshold levels. We care about our customers' safety and hope that the information below helps with your buying decisions.

Proposition 65 WARNING: This product contains chemicals known to the State of California to cause cancer and birth defects or other reproductive harm.


Copyright © 2000-2020 Pagecomm International