
UPDATE tblplan_features_value as pfv
LEFT JOIN tblplan_features as pf ON  pfv.plans_features_id = pf.id 
set other_data = '{"outside_message":"CompanyCam Sync is a Corporate feature. In order to sync to CompanyCam, upgrade to Corporate.","inside_message":"CompanyCam Sync is a Corporate feature. In order to sync to CompanyCam, upgrade to Corporate.","tag_color":"#eb0e0e","tag_title":"UPGRADE","link":"https:\/\/dev.my.contractorplus.app\/","count":"0"}', value = 0 
WHERE pf.codename = "companycam_sync" AND pfv.plans_id IN (9,10) ;

UPDATE tblstaff SET refresh_permissions = 1;