KYOTANGO ACCOMMODATIONS
SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') GROUP BY yado.nYadoNo, yado.sYadoName ) AS query ORDER BY FIELD (nYadoNo,)' at line 1SELECT * FROM (SELECT yado.nYadoNo, yado.sYadoName,yado_EX.sYadoExValue AS YadoImg FROM tYado_EN AS yado INNER JOIN tYadoEx_EN AS yado_EX ON yado.nYadoNo = yado_EX.nYadoNo AND yado_EX.nAgentNo = 2 AND yado_EX.sYadoExKey = 'YadoImg_Main' INNER JOIN tPlan_EN AS plan ON yado.nYadoNo = plan.nYadoNo INNER JOIN tPlanSale_EN AS plansale ON yado.nYadoNo = plansale.nYadoNo AND plan.nPlanNo = plansale.nPlanNo AND plansale.nAgentNo = 2 AND plansale.bPlanSleep = 0 AND plansale.dPlanSaleSDate <= CURRENT_DATE() AND plansale.dPlanSDate <= CURRENT_DATE() AND plansale.dPlanEDate >= CURRENT_DATE() INNER JOIN (SELECT nYadoNo,nStockNo FROM tStockTbl WHERE (nStockInputNum - nStockResvNum) >= 1 AND dStockDate >= CURRENT_DATE() GROUP BY nYadoNo,nStockNo HAVING COUNT(*) >= 1 ) AS stocktbl ON stocktbl.nYadoNo = plansale.nYadoNo AND stocktbl.nStockNo = plansale.nStockNo INNER JOIN (SELECT nYadoNo,nPlanNo,nStockNo,SUM(nPlanRate) AS Rate FROM tPlanRateTbl_EN WHERE bPlanExclude = 0 AND dPlanDate >= CURRENT_DATE() AND nPlanRate > 0 AND nAgentNo = 2 GROUP BY nYadoNo,nPlanNo,nStockNo HAVING COUNT(*) >= 1 ) AS ratetbl ON ratetbl.nYadoNo = plansale.nYadoNo AND ratetbl.nPlanNo = plansale.nPlanNo AND ratetbl.nStockNo = plansale.nStockNo WHERE yado.bYadoSleep = 0 AND yado.nYadoNo IN () GROUP BY yado.nYadoNo, yado.sYadoName ) AS query ORDER BY FIELD (nYadoNo,) 
Kyotango is the northern most part of Kyoto Prefecture and borders along the Sea of Japan. Here you will find an expanse of beautiful scenery where an eternal natural history still remain. Geological formations command the horizon and some are designated as important heritage sites and are scientifically valuable. The area is packed with history and romanticism that has cultivated the culture of Kyotango.