INVALID SQL: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (xcart_category_memberships.membershipid = '' OR xcart_category_members...' at line 1
SQL QUERY FAILURE:SELECT *, xcart_products_lng_en.product, xcart_products.productid, xcart_products.provider, xcart_products.productcode, xcart_products.avail, xcart_products.min_amount, xcart_products.list_price, xcart_products.distribution, xcart_pricing.price, xcart_quick_prices.variantid, xcart_variants.avail AS avail, xcart_variants.weight AS weight, xcart_variants.productcode AS productcode, IF( xcart_variants.is_product_row = 1 ,'','Y') as is_variant , IF(xcart_classes.classid IS NULL,'','Y') as is_product_options, xcart_images_T.image_path, xcart_images_T.imageid, xcart_images_T.id AS Tid, xcart_images_T.image_x AS Timage_x, xcart_images_T.image_y AS Timage_y, xcart_product_taxes.taxid, xcart_products.on_sale FROM xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_pricing.quantity = '1' INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid 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 LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid 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_products.productid IN() AND (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_products.forsale='Y' AND (xcart_variants.variantid = xcart_pricing.variantid ) GROUP BY xcart_products.productid ORDER BY price LIMIT 12
Istok Church Supplies - Orthodox online store
Home - Products On Sale at Istok Church Supplies Corp.

There are currently no sales.

Church supplies categories

Bestsellers

New Arrivals

Manufacturers

Special

Help

Your cart

Cart is empty

Authentication

Testimonials

  • The items we received from Istok are stunning and I will be placing additional orders in the future.

    Rev. Economos Apostolos Hill, Dean, Holy Trinity Greek Orthodox Cathedral

  • Dear to Christ, Thank all the Istok group. I received the vestments today. Vestments are...

    Fr. Isaac Farha

  • I really like Istok vestments, and I make sure to tell people every time they comment about mine...

    Fr. John Chagnon MDiv

  • Thank you so much for your service to me.

    Bishop Mark Hagan

  • I just received the package ! the stikharion is wonderful. Thank you very much for your superfast...

    Lionel Amerio

Your Quotes




News

Jan 26, 2024

We're happy to inform you that we've added some new excellent products to our store:

  • 1 blessing cross;
  • 7 souvenir bells;
  • 2 jewellery censers;
  • 4 brass church banners;
  • 24 Byzantine canonical icons;
  • 1 church wall lamp;
  • 4 jewellery pectoral crosses;
  • 12 Bishop panagias;
  • 7 vigil lamps and corbels for them;
  • 6 processional altar sets (icon + cross).

You can conveniently see them on the What's New page.

You may also be interested in our Special Offers, which you can conveniently find on the Products on Sale page. Please note that this Sale will expire on Feb. 1/14, 2024.

Notes: We do ship our orders worldwide.



All news   

Affiliates

Become a provider