Notice: Undefined index: lang_iso in /var/www/vhosts/sandyblue.com/httpdocs/scripts/php/sys_getrate.php on line 10

Notice: Undefined index: date_arr in /var/www/vhosts/sandyblue.com/httpdocs/scripts/php/sys_getrate.php on line 34

Notice: Undefined index: date_dep in /var/www/vhosts/sandyblue.com/httpdocs/scripts/php/sys_getrate.php on line 35

Notice: Undefined index: acc_id in /var/www/vhosts/sandyblue.com/httpdocs/scripts/php/sys_getrate.php on line 36

Notice: Undefined index: ls in /var/www/vhosts/sandyblue.com/httpdocs/scripts/php/sys_getrate.php on line 37

Notice: Undefined index: lang_iso in /var/www/vhosts/sandyblue.com/httpdocs/scripts/php/sys_getrate.php on line 38
{"status":"sql_err","value":[{"err_msg":"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 ') AS `val_full`,\r\n SUM(\r\n \r\n ) AS `dsc_amt`' at line 4","qry_used":"\r\n SELECT \r\n SUM(\r\n \r\n ) AS `val_full`,\r\n SUM(\r\n \r\n ) AS `dsc_amt`,\r\n SUM(\r\n \r\n ) AS `ls_val`,\r\n DATEDIFF('1970-01-01', '1970-01-01') AS `nites_num`\r\n FROM \r\n `sbctrldb`.`av_rates_full` AS `rts` \r\n LEFT JOIN\r\n `sbctrldb`.`av_rates_full_ny` AS `rts_ny` ON (`rts_ny`.`assoc_id` = ) \r\n LEFT JOIN\r\n `sbctrldb`.`rts_discounts` AS `disc` ON (`disc`.`disc_typ` = 'norm' AND `disc`.`year` = '2024' AND `disc`.`assoc_id` = )\r\n LEFT JOIN\r\n `sbctrldb`.`rts_discounts` AS `disc_ny` ON (`disc_ny`.`disc_typ` = 'norm' AND `disc_ny`.`year` = '2025' AND `disc_ny`.`assoc_id` = )\r\n WHERE \r\n `rts`.`assoc_id` = \r\n "}]}