Table 'cloud_sasang_1402__.balancetable' doesn't exist
SELECT sum(if(BalanceTableCodePatternID=7,Number,0)) as irn_room,sum(if(BalanceTableCodePatternID=8,Number,0)) as for_room, sum(if(BalanceTableCodePatternID=9,Number,0)) as irn_bed,sum(if(BalanceTableCodePatternID=10,Number,0)) as for_bed, IranianDate as _day,concat(substring(IranianDate,7,4),'/',substring(IranianDate,4,2),'/',substring(IranianDate,1,2)) as rvs_day from cloud_sasang_1402__.balancetable where IranianDate = '12/11/1403' group by _day order by rvs_day