INVALID SQL: 1231 : Variable 'sql_mode' can't be set to the value of 'MYSQL40' SQL QUERY FAILURE:SET sql_mode = 'MYSQL40' INVALID SQL: 1055 : Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'sprayequ_sprayequip1.xcart_products_categories.orderby' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL QUERY FAILURE:SELECT COUNT(xcart_products.productid) FROM xcart_pricing, xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_categories.avail = 'Y' AND (xcart_products.forsale = 'Y' OR xcart_products.forsale = '') AND (IFNULL(xcart_variants.avail, xcart_products.avail) > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_products_categories.orderby DESC, xcart_products.product ASC Spray Equipment Packages :: Search results