CREATE
DEFINER=`root`@`localhost`
TRIGGER `hud`.`trig_sc_check_rating_level`
BEFORE INSERT ON `hud`.`na_asc_subcategory_rating`
FOR EACH ROW
BEGIN
IF (
    select count(*)
    from NEW
    inner join na_lku_rating_type rt
        on NEW.rating_type_id = rt.id
    where rt.level = 'subcategory'
    ) = 0 THEN SET NEW.rating_type_id = 1/0;
END IF;

END
$$