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/MYYMMTA7' (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 > '1709299796' ) OR ( xcart_products.mark_as_new = 'S' AND xcart_products.show_as_new_from <= 1743859796 AND xcart_products.show_as_new_to >= 1743859796 ) OR ( xcart_products.mark_as_new = 'A' AND xcart_products.show_as_new_from <= 1743859796 AND IF (4320000 = 0, 1, (xcart_products.show_as_new_from + 4320000) >= 1743859796) ) ) ORDER BY xcart_products.show_as_new_from DESC, xcart_products.add_date DESC LIMIT 0,360
Product reviews: St. Mark Tiny Saint Charm

St. Mark Tiny Saint Charm

 
(4 reviews)  

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


Product feedback

4 Results Found
Displaying Results 1 - 4
Tiny Saint Fan
Oct 14, 2015
This customer purchased the item at our site.
I love these Tiny Saints. They really are great gifts! Kids love them, teens love them, and even a lot of adults as well. Also it's nice to have the saint bio on the back of the card. I hope they keep making more saints.
Rylan C.
May 22, 2018
This customer purchased the item at our site.
5 stars
Anonymous
May 22, 2018
This customer purchased the item at our site.
St. Mark Tiny Saint Charm
Anonymous
Mar 26, 2020
This customer purchased the item at our site.
St. Mark Tiny Saint Charm


Recently Viewed

Newsletter

Join our mailing list

And receive a 13% Off Coupon!