Warning: mysql_query(): Unable to save result set in /home/catholi2/public_html/include/func/func.db.php on line 252
INVALID SQL: 3 : Error writing file '/tmp/MYwNWl78' (Errcode: 28 - No space left on device)
SQL QUERY FAILURE:SELECT xcart_products.productid FROM xcart_products USE INDEX(sa) INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_pricing.quantity = '1' INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid AND xcart_products_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_customer_enabled_activities as ACHECK ON xcart_products.provider=ACHECK.userid INNER JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_products_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid WHERE (xcart_category_memberships.membershipid = '0' OR xcart_category_memberships.membershipid IS NULL) AND (xcart_product_memberships.membershipid = '0' OR xcart_product_memberships.membershipid IS NULL) AND ( xcart_variants.avail > 0 OR xcart_products.product_type NOT IN ('','N')) AND xcart_pricing.membershipid = '0' AND xcart_products.forsale='Y' AND xcart_products.product_type <> 'C' AND ( xcart_pricing.variantid = '0' OR xcart_variants.variantid = xcart_pricing.variantid ) AND ( ( xcart_products.mark_as_new = 'N' AND xcart_products.add_date > '1709208735' ) OR ( xcart_products.mark_as_new = 'S' AND xcart_products.show_as_new_from <= 1743768735 AND xcart_products.show_as_new_to >= 1743768735 ) OR ( xcart_products.mark_as_new = 'A' AND xcart_products.show_as_new_from <= 1743768735 AND IF (4320000 = 0, 1, (xcart_products.show_as_new_from + 4320000) >= 1743768735) ) ) ORDER BY xcart_products.show_as_new_from DESC, xcart_products.add_date DESC LIMIT 0,360
Product reviews: World's Softest Plush - Lion

World's Softest Plush - Lion

 
(3 reviews)  

5 stars
 2 review(s)
4 stars
 1 review(s)
3 stars: 
 0 review(s)
2 stars: 
 0 review(s)
1 stars: 
 0 review(s)


You are viewing 5-stars reviews (see all reviews)

Product feedback

2 Results Found
Displaying Results 1 - 2
Anonymous
Jun 24, 2016
This customer purchased the item at our site.
World's Softest Plush - Lion
M.E.P.
Aug 8, 2016
This customer purchased the item at our site.
5 Stars


Newsletter

Join our mailing list

And receive a 13% Off Coupon!