M2 Pets

INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, v_pricing.price as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND (xcart_pricing.variantid = 0 OR (xcart_variants.variantid = xcart_pricing.variantid)) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/m2pets.com/httpdocs/xcart/include/func.php on line 102
M2 Pets

With every birth or adoption, a new pet becomes a real member of the family—and, because you give the best of yourself to your pets, they in return, treat you to unconditional love, loyalty, adoration, and... a few life lessons you're surprised a pet has the power to teach you. At M2Pets, we understand that uncanny relationship between pets and their people—we design all of our products to enhance that relationship.

ARCTICK is a FDA registered non-toxic spray that instantly kills all ticks on contact. Prevents the transmission of fluids between the tick and your pet. Designed to help prevent the spread of infectious disease which may occur during the removal of the tick. Environmentally friendly, economical, safe, and proven to be 100% effective in laboratory testing!

Kills ticks instantly to help prevent the transmission of on-board diseases
Safe alternative to Spot-On pesticides
100% Safe for your pets
100% Deadly for ticks




Community Links: www.aspca.org, www.adopt-a-greyhound.org, www.pets911.com

Click here to view/print the PetJet Instruction Manual

Click here for our Privacy Policy.
M2Pets is a Division of M2Products. , M2Products, LLC.
Web site development by Wildwood Interactive