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/MYhtV42g' (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 > '1709275506'
) OR (
xcart_products.mark_as_new = 'S'
AND xcart_products.show_as_new_from <= 1743835506
AND xcart_products.show_as_new_to >= 1743835506
) OR (
xcart_products.mark_as_new = 'A'
AND xcart_products.show_as_new_from <= 1743835506
AND IF (4320000 = 0, 1, (xcart_products.show_as_new_from + 4320000) >= 1743835506)
)
) ORDER BY xcart_products.show_as_new_from DESC, xcart_products.add_date DESC LIMIT 0,360 Bliss :: Manufacturers :: Catholic Shop
