INVALID SQL: 1139 : Got error 'brackets ([ ]) not balanced' from regexp
SQL QUERY FAILURE:EXPLAIN SELECT xcart_products.productid FROM xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_pricing.quantity = '1' AND xcart_products.forsale='Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_categories.categoryid = xcart_products_categories.categoryid AND xcart_categories.avail = 'Y' INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_customers as ACHECK ON xcart_products.provider=ACHECK.id AND ACHECK.activity='Y' LEFT JOIN xcart_products_lng ON xcart_products.productid = xcart_products_lng.productid AND code = 'en' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_product_features ON xcart_product_features.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 AND xcart_quick_prices.variantid = xcart_variants.variantid LEFT JOIN xcart_images_T ON xcart_images_T.id = xcart_products.productid LEFT JOIN xcart_product_taxes ON xcart_product_taxes.productid = xcart_products.productid WHERE (xcart_category_memberships.membershipid = '' OR xcart_category_memberships.membershipid IS NULL) AND (xcart_product_memberships.membershipid = '' OR xcart_product_memberships.membershipid IS NULL) AND xcart_pricing.membershipid = '0' AND (xcart_pricing.variantid = '0' OR xcart_variants.variantid = xcart_pricing.variantid) AND (IFNULL(xcart_variants.avail, xcart_products.avail) > '0' OR xcart_products.product_type NOT IN ('','N')) AND xcart_products.product REGEXP '^[]' GROUP BY xcart_products.productid ORDER BY xcart_products.product
INVALID SQL: 1139 : Got error 'brackets ([ ]) not balanced' from regexp
SQL QUERY FAILURE:SELECT xcart_products.productid FROM xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_pricing.quantity = '1' AND xcart_products.forsale='Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_categories.categoryid = xcart_products_categories.categoryid AND xcart_categories.avail = 'Y' INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_customers as ACHECK ON xcart_products.provider=ACHECK.id AND ACHECK.activity='Y' LEFT JOIN xcart_products_lng ON xcart_products.productid = xcart_products_lng.productid AND code = 'en' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_product_features ON xcart_product_features.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 AND xcart_quick_prices.variantid = xcart_variants.variantid LEFT JOIN xcart_images_T ON xcart_images_T.id = xcart_products.productid LEFT JOIN xcart_product_taxes ON xcart_product_taxes.productid = xcart_products.productid WHERE (xcart_category_memberships.membershipid = '' OR xcart_category_memberships.membershipid IS NULL) AND (xcart_product_memberships.membershipid = '' OR xcart_product_memberships.membershipid IS NULL) AND xcart_pricing.membershipid = '0' AND (xcart_pricing.variantid = '0' OR xcart_variants.variantid = xcart_pricing.variantid) AND (IFNULL(xcart_variants.avail, xcart_products.avail) > '0' OR xcart_products.product_type NOT IN ('','N')) AND xcart_products.product REGEXP '^[]' GROUP BY xcart_products.productid ORDER BY xcart_products.product
Products Map

Green Bee Designs Offers
an additional 10%
in Savings
as Bonus Points on your Purchases.
Accumulate 100 Points and redeme
them for a $10.00 Gift Certificate

 

 

Products Map

G L T


No items available