The Ottawa Tennis & Lawn Bowling Club

Club Sign-up Calendar

View All Club Social Events Let's Play Round Robins

Fun and totally social activities.

Club Social Events - December, 2022

Calendar Sign-Ups

Sunday Monday Tuesday Wednesday Thursday Friday Saturday

2024-05-11 02:09:31 344 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(security,char),convert(status,char),convert(roles,char) from dform_module where name = 'home'

2024-05-11 02:09:31 344 [info] (com.smarteform.spring.mvc.interceptor.SecurityInterceptor) - id=479

2024-05-11 02:09:31 361 [info] (com.smarteform.hibernate.LookUpDAO) - sql: Select categoryname from dform_rscategories where recordid=case '50' when '' then '' else '50' end union select 'View All' from dform_rscategories where '50' = ''

2024-05-11 02:09:31 362 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),0) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),1) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),2) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),3) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),4) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),5) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),6) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),7) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),8) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),9) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),10) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),11) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),12) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),13) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),14) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),15) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),16) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),17) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),18) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),19) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),20) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),21) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),22) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),23) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),24) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),25) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),26) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),27) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),28) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),29) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),30) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),31) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),32) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),33) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),34) and date_format(str_to_date('20221201','%Y%m%d'),'%m')=date_format(c1.dt,'%m') and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),35) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),36) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),37) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),38) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),39) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),40) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),41) and date_format(str_to_date('20221201','%Y%m%d'),'%m')=date_format(c1.dt,'%m') and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d')

2024-05-11 02:09:31 445 [info] (com.smarteform.hibernate.LookUpDAO) - sql: Select date_format(20221201,'%M, %Y')

2024-05-11 02:09:31 445 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select date_format((str_to_date('20221201','%Y%m%d') + interval 1 month),'%Y%m%d')

2024-05-11 02:09:31 446 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select '50'

2024-05-11 02:09:31 446 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select date_format((str_to_date('20221201','%Y%m%d') - interval 1 month),'%Y%m%d')

2024-05-11 02:09:31 446 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select * from ( select '','View All',case when '50' = '' and '' = '' then 'calbluebtnactivenew' else 'calbluebtnactive' end,'' as nnn,'' as weight, 0 as recordid,case when '50' = '' and '' = '' then 'ccc' else '' end as color,'' as recordid2 union select recordid, categoryname, case when recordid='50' then 'calbluebtnactivenew' else 'calbluebtnactive' end, '' as nnn,weight,recordid,Color,'' as recordid2 from dform_rscategories where status = 'Active' and RegisterOnline='Yes' union select '',name, case when recordid='' then 'calbluebtnactivenew' else 'calbluebtnactive' end, '' as nnn,weight,0 as recordid,color,recordid as recordid2 from dform_plprogram_categories where status = 'Active' and calendar='Yes' ) aaa order by aaa.weight,aaa.recordid

2024-05-11 02:09:31 447 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select '20221201'

2024-05-11 02:09:31 447 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select waiver from dform_rscategories where recordid = case '50' when '' then 0 else '50' end

2024-05-11 02:09:31 447 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select date_format(str_to_date('20221201','%Y%m%d'),'%m')

2024-05-11 02:09:31 448 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select year(str_to_date('20221201','%Y%m%d'))

2024-05-11 02:09:31 448 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select '01','January',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '01' then 'selected' else '' end,getfrenchmonth('January') union select '02','February',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '02' then 'selected' else '' end,getfrenchmonth('February') union select '03','March',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '03' then 'selected' else '' end,getfrenchmonth('March') union select '04','April',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '04' then 'selected' else '' end,getfrenchmonth('April') union select '05','May',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '05' then 'selected' else '' end,getfrenchmonth('May') union select '06','June',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '06' then 'selected' else '' end,getfrenchmonth('June') union select '07','July',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '07' then 'selected' else '' end,getfrenchmonth('July') union select '08','August',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '08' then 'selected' else '' end,getfrenchmonth('August') union select '09','September',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '09' then 'selected' else '' end,getfrenchmonth('September') union select '10','October',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '10' then 'selected' else '' end,getfrenchmonth('October') union select '11','November',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '11' then 'selected' else '' end,getfrenchmonth('November') union select '12','December',case when date_format(str_to_date('20221201','%Y%m%d'),'%m') = '12' then 'selected' else '' end,getfrenchmonth('December')

2024-05-11 02:09:31 449 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select distinct y, case when date_format(str_to_date('20221201','%Y%m%d'),'%Y') = y then 'selected' else '' end from dform_rscalendar_table

2024-05-11 02:09:31 453 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT 1 FROM dform_privatelessonmapping m left join dform_user_transactions t on (m.usertransactionid collate latin1_swedish_ci) = (t.transaction_id) where m.recordowner=-1 and m.status='Registration Pending' union SELECT 1 FROM dform_plprogrammapping m,dform_plprograms p, dform_plprogram_categories c where m.camp=p.recordid and p.camptype=c.recordid and c.calendar='Yes' and m.recordowner=-1 and m.status='Registration Pending'

2024-05-11 02:09:31 454 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select concat((select count(*) from dform_programmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_productmapping where recordowner=-1 and status='Order Pending') + (select count(*) from dform_childrencampmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_childrenlessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_privatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_thirdweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_secondweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_fourthweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_plprogrammapping where recordowner=-1 and status='Registration Pending'),' ',case when (select count(*) from dform_programmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_productmapping where recordowner=-1 and status='Order Pending') + (select count(*) from dform_childrencampmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_childrenlessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_privatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_thirdweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_secondweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_fourthweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_plprogrammapping where recordowner=-1 and status='Registration Pending') > 1 then 'Items' else 'Item' end)

2024-05-11 02:09:31 455 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select ''

2024-05-11 02:09:31 455 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select * from ( select '','Voir tout',case when '50' = '' and '' = '' then 'calbluebtnactivenew' else 'calbluebtnactive' end,'' as nnn,'' as weight, 0 as recordid,case when '50' = '' and '' = '' then 'ccc' else '' end as color,'' as recordid2 union select recordid, categorynamefrench, case when recordid='50' then 'calbluebtnactivenew' else 'calbluebtnactive' end, '' as nnn,weight,recordid,Color,'' as recordid2 from dform_rscategories where status = 'Active' and RegisterOnline='Yes' union select '',NameFrench, case when recordid='' then 'calbluebtnactivenew' else 'calbluebtnactive' end, '' as nnn,weight,0 as recordid,color,recordid as recordid2 from dform_plprogram_categories where status = 'Active' and calendar='Yes' ) aaa order by aaa.weight,aaa.recordid

2024-05-11 02:09:31 456 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select concat((select count(*) from dform_programmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_productmapping where recordowner=-1 and status='Order Pending') + (select count(*) from dform_childrencampmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_childrenlessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_privatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_thirdweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_secondweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_fourthweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_plprogrammapping where recordowner=-1 and status='Registration Pending'),' ',case when (select count(*) from dform_programmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_productmapping where recordowner=-1 and status='Order Pending') + (select count(*) from dform_childrencampmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_childrenlessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_privatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_thirdweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_secondweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_fourthweeklyprivatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_plprogrammapping where recordowner=-1 and status='Registration Pending') > 1 then 'Articles' else 'Article' end)

2024-05-11 02:09:31 457 [info] (com.smarteform.hibernate.LookUpDAO) - sql: Select categorynamefrench from dform_rscategories where recordid=case '50' when '' then '' else '50' end union select 'Voir tout' from dform_rscategories where '50' = ''

2024-05-11 02:09:31 457 [info] (com.smarteform.hibernate.LookUpDAO) - sql: Select getfrenchdatenoday('20221201')

2024-05-11 02:09:31 457 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select waiverfrench from dform_rscategories where recordid = case '50' when '' then (select min(recordid) from dform_rscategories where status='Active') else '50' end

2024-05-11 02:09:31 458 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select getfrenchmonth(c1.monthname) as m ,case c1.d when 1 then '1er' else c1.d end, getfrenchmonth(c2.monthname) as m ,case c2.d when 1 then '1er' else c2.d end,getfrenchmonth(c3.monthname) as m ,case c3.d when 1 then '1er' else c3.d end,getfrenchmonth(c4.monthname) as m, case c4.d when 1 then '1er' else c4.d end,getfrenchmonth(c5.monthname) as m ,case c5.d when 1 then '1er' else c5.d end,getfrenchmonth(c6.monthname) as m ,case c6.d when 1 then '1er' else c6.d end,getfrenchmonth(c7.monthname) as m ,case c7.d when 1 then '1er' else c7.d end , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendarFrench(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),0) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),1) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),2) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),3) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),4) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),5) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),6) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select getfrenchmonth(c1.monthname) as m ,case c1.d when 1 then '1er' else c1.d end, getfrenchmonth(c2.monthname) as m ,case c2.d when 1 then '1er' else c2.d end,getfrenchmonth(c3.monthname) as m ,case c3.d when 1 then '1er' else c3.d end,getfrenchmonth(c4.monthname) as m, case c4.d when 1 then '1er' else c4.d end,getfrenchmonth(c5.monthname) as m ,case c5.d when 1 then '1er' else c5.d end,getfrenchmonth(c6.monthname) as m ,case c6.d when 1 then '1er' else c6.d end,getfrenchmonth(c7.monthname) as m ,case c7.d when 1 then '1er' else c7.d end , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendarFrench(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),7) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),8) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),9) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),10) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),11) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),12) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),13) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select getfrenchmonth(c1.monthname) as m ,case c1.d when 1 then '1er' else c1.d end, getfrenchmonth(c2.monthname) as m ,case c2.d when 1 then '1er' else c2.d end,getfrenchmonth(c3.monthname) as m ,case c3.d when 1 then '1er' else c3.d end,getfrenchmonth(c4.monthname) as m, case c4.d when 1 then '1er' else c4.d end,getfrenchmonth(c5.monthname) as m ,case c5.d when 1 then '1er' else c5.d end,getfrenchmonth(c6.monthname) as m ,case c6.d when 1 then '1er' else c6.d end,getfrenchmonth(c7.monthname) as m ,case c7.d when 1 then '1er' else c7.d end , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendarFrench(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),14) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),15) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),16) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),17) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),18) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),19) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),20) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select getfrenchmonth(c1.monthname) as m ,case c1.d when 1 then '1er' else c1.d end, getfrenchmonth(c2.monthname) as m ,case c2.d when 1 then '1er' else c2.d end,getfrenchmonth(c3.monthname) as m ,case c3.d when 1 then '1er' else c3.d end,getfrenchmonth(c4.monthname) as m, case c4.d when 1 then '1er' else c4.d end,getfrenchmonth(c5.monthname) as m ,case c5.d when 1 then '1er' else c5.d end,getfrenchmonth(c6.monthname) as m ,case c6.d when 1 then '1er' else c6.d end,getfrenchmonth(c7.monthname) as m ,case c7.d when 1 then '1er' else c7.d end , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendarFrench(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),21) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),22) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),23) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),24) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),25) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),26) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),27) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select getfrenchmonth(c1.monthname) as m ,case c1.d when 1 then '1er' else c1.d end, getfrenchmonth(c2.monthname) as m ,case c2.d when 1 then '1er' else c2.d end,getfrenchmonth(c3.monthname) as m ,case c3.d when 1 then '1er' else c3.d end,getfrenchmonth(c4.monthname) as m, case c4.d when 1 then '1er' else c4.d end,getfrenchmonth(c5.monthname) as m ,case c5.d when 1 then '1er' else c5.d end,getfrenchmonth(c6.monthname) as m ,case c6.d when 1 then '1er' else c6.d end,getfrenchmonth(c7.monthname) as m ,case c7.d when 1 then '1er' else c7.d end , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendarFrench(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),28) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),29) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),30) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),31) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),32) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),33) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),34) and date_format(str_to_date('20221201','%Y%m%d'),'%m')=date_format(c1.dt,'%m') and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select getfrenchmonth(c1.monthname) as m ,case c1.d when 1 then '1er' else c1.d end, getfrenchmonth(c2.monthname) as m ,case c2.d when 1 then '1er' else c2.d end,getfrenchmonth(c3.monthname) as m ,case c3.d when 1 then '1er' else c3.d end,getfrenchmonth(c4.monthname) as m, case c4.d when 1 then '1er' else c4.d end,getfrenchmonth(c5.monthname) as m ,case c5.d when 1 then '1er' else c5.d end,getfrenchmonth(c6.monthname) as m ,case c6.d when 1 then '1er' else c6.d end,getfrenchmonth(c7.monthname) as m ,case c7.d when 1 then '1er' else c7.d end , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendarFrench(-1,c1.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c2.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c3.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c4.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c5.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c6.dt, '50',''), checkPrivateLessonAvailNewCalendarFrench(-1,c7.dt, '50',''), if(date(getJegyTime())=date(c1.dt),' today',''), if(date(getJegyTime())=date(c2.dt),' today',''), if(date(getJegyTime())=date(c3.dt),' today',''), if(date(getJegyTime())=date(c4.dt),' today',''), if(date(getJegyTime())=date(c5.dt),' today',''), if(date(getJegyTime())=date(c6.dt),' today',''), if(date(getJegyTime())=date(c7.dt),' today','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),35) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),36) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),37) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),38) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),39) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),40) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20221201','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),41) and date_format(str_to_date('20221201','%Y%m%d'),'%m')=date_format(c1.dt,'%m') and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d')

2024-05-11 02:09:31 524 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2024-05-11 02:09:31 525 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2024-05-11 02:09:31 525 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2024-05-11 02:09:31 525 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2024-05-11 02:09:31 526 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2024-05-11 02:09:31 526 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2024-05-11 02:09:31 526 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2024-05-11 02:09:31 526 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2024-05-11 02:09:31 527 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(javascript,char),convert(css,char),convert(header,char) from dform_sitethemes where type='website'

2024-05-11 02:09:31 527 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2024-05-11 02:09:31 528 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2024-05-11 02:09:31 528 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2024-05-11 02:09:31 528 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2024-05-11 02:09:31 543 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select LeftColor from dform_otlbcheadcolor where recordid=1

2024-05-11 02:09:31 543 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select RightColor from dform_otlbcheadcolor where recordid=1

2024-05-11 02:09:31 556 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select m.title, case m.contenturl when '' then case when m.page='None' then '#' else concat('/otlbc/home/',m.Page) end else concat('/otlbc/home/',m.ContentURL,'.do?id=',substring_index(m.contentid,'<',1)) end,n.title, case n.contenturl when '' then concat('',n.title,'') else concat('',n.title,'') end,case when n.title is null then '' else '' end,case when n.title is null then '' else '' end,case when n.title is null then '' else '