CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `rs_bulk` AS (select `kjnt_form_2`.`NOHP` AS `NOHP`,`kjnt_form_2`.`NMSAL` AS `NMSAL`,`kjnt_form_2`.`NMRS` AS `NMRS`,`kjnt_form_2`.`TGLTRX` AS `tgltrx`,if((sum(`kjnt_form_2`.`STATUS`) > 0),1,0) AS `TOTAL` from `kjnt_form_2` where ((`kjnt_form_2`.`BULK` > 0) and (`kjnt_form_2`.`STATUS` > 0)) group by `kjnt_form_2`.`NORS`);