|
| |
Failed to execute queryYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL:SELECT sakeproduct.prod_id, sakeproduct.ItemCode, sakeproduct.ItemName, sakeproduct.Type_id, sakeproduct.cat_id, sakeproduct.ShochuMat, sakeproduct.`Character`, sakeproduct.SakeMeter, sakeproduct.Alcohol, sakeproduct.Acidity, sakeproduct.PolishRate, sakeproduct.RiceVariety, sakeproduct.Serv_id, sakeproduct.FoodPairing, sakeproduct.CirculationTemp, sakeproduct.cont_id, sakeproduct.Packing, sakeproduct.PackSize, sakeproduct.PackWeight, sakeproduct.UPC, sakecategory.bcat_id, sakecategory.mcat_id, sakecategory.tcat_id, sakecategory.cat, sake_type.`Type`, sakeproduct.Brew_id, brewery.Brew_id, brewery.BrewName, brewery.Prefecture, brewery.Region, brewery.Lang_id FROM sakeproduct INNER JOIN brewery ON (sakeproduct.Brew_id = brewery.Brew_id) AND (sakeproduct.Lang_id = brewery.Lang_id) INNER JOIN sakecategory ON (sakeproduct.cat_id = sakecategory.cat_id) AND (sakeproduct.Lang_id = sakecategory.Lang_id) INNER JOIN sake_type ON (sakeproduct.Type_id = sake_type.Type_id) AND (sakeproduct.Lang_id = sake_type.Lang_id) WHERE ((sakeproduct.Lang_id = 1) AND (ItemCode > '00050')) AND ((sakeproduct.cat_id = 10 )) ORDER BY |
Daiginjo
