CR1A-FS Commercial Series Refrigerator

CR1A-FS Commercial Series Refrigerator

Item Discontinued

  • Manufacturer: Hoshizaki
  • Manufacturer Model Number CR1A-FS
  • Our SKU: HZ-CR1A-FS
  • hosh.gif
  • Hoshizaki Benefits

Fatal error: Wrong SQL: SELECT ss_name, ss_price, ss_saleamount, ss_optionmenutext, ss_graphic, ss_filename, ss_productsid, ss_sku, ss_productfield9, ss_productfield22, ss_productfield2, ss_productfield13 FROM ss_products WHERE ss_productfield7 != '' AND ss_productfield9 != 1 AND ss_productfield22 != 1 AND (ss_productfield7 LIKE ? AND MATCH (ss_name) AGAINST (?)) LEFT JOIN ss_subproducts ON ss_subproducts.ss_childid = ss_products.ss_productsid limit 3 Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN ss_subproducts ON ss_subproducts.ss_childid = ss_products.ss_productsi' at line 1 in /home/abestkitchen/www/chemins/sort/route.php on line 48