= '$prior_date', 1, 0)) as total_last FROM alert a INNER JOIN alert_type at ON at.alert_type_id = a.alert_type_id WHERE ( ( a.alert_type_id IN ( SELECT xatr.alert_type_id FROM alert_type xat INNER JOIN alert_type_roles xatr ON xatr.alert_type_id = xat.alert_type_id INNER JOIN orchadmin_user_roles xour ON xour.orchadmin_role_id = xatr.orchadmin_role_id WHERE xour.orchadmin_user_id = $logged_user_id and (xat.alert_permission = 'group' OR (xat.alert_permission = 'individual' and xour.orchadmin_role_id NOT IN (3)) ) GROUP BY xatr.alert_type_id) ) OR a.alert_id IN (SELECT xar.alert_id FROM alert_roles xar INNER JOIN orchadmin_user_roles xour ON xour.orchadmin_role_id = xar.orchadmin_role_id WHERE xour.orchadmin_user_id = $logged_user_id GROUP BY xar.alert_id) OR ( a.alert_for = 'vendor' AND a.alert_for_id IN (SELECT vendor_id FROM vendor WHERE assigned_to = $logged_user_id) ) OR ( a.alert_for = 'artist' AND a.alert_for_id IN (SELECT a.artist_id FROM artist_info a INNER JOIN vendor v ON v.vendor_id = a.vendor_id WHERE v.assigned_to = $logged_user_id) ) OR ( a.alert_for = 'release' AND a.alert_for_id IN (SELECT r.upc FROM releases r INNER JOIN artist_info a ON a.artist_id = r.artist_id INNER JOIN vendor v ON v.vendor_id = a.vendor_id WHERE r.release_status = 'in_content' AND v.assigned_to = $logged_user_id) ) ) "; if (is_file(__DIR__ . '/../images/users/' . $logged_user_id . '.jpg')) { $avatar_image = '/images/users/' . $logged_user_id . '.jpg'; } else { $avatar_image = '/images/imgAvatar.gif'; } $logoutLink = '/logout_v2.php'; ?>