dwh_categories_bonuses

CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `dwh_categories_bonuses` AS select `cb`.`categories_bonuses_id` AS `categories_bonuses_id`,`cb`.`categories_bonuses_type` AS `type`,`cb`.`categories_bonuses_amount` AS `amount`,`cb`.`categories_bonuses_credits` AS `credits`,`cb`.`categories_bonuses_credits_lifetime` AS `redits_lifetime`,`cb`.`categories_id` AS `categories_id`,`cb`.`is_deleted` AS `is_deleted`,cast(date_format(`cb`.`date_added`,'%Y%m%d') as signed) AS `date_added_id` from (`categories_bonuses` `cb` join `dwh_upload_config` `duc` on(`duc`.`component` = 'dwh_categories_bonuses')) where (`duc`.`date_from_use` = 0 or `cb`.`date_added` >= `duc`.`date_from`) and (`duc`.`date_to_use` = 0 or `cb`.`date_added` <= `duc`.`date_to`) and (`duc`.`id_from_use` = 0 or `cb`.`categories_bonuses_id` >= `duc`.`id_from`) and (`duc`.`id_to_use` = 0 or `cb`.`categories_bonuses_id` <= `duc`.`id_to`);