diff --git a/includes/alerts.inc.php b/includes/alerts.inc.php
index 3ed59d28b..28de74d6c 100644
--- a/includes/alerts.inc.php
+++ b/includes/alerts.inc.php
@@ -894,12 +894,12 @@ function ExtTransports($obj)
 function IsParentDown($device)
 {
     $parent_count = dbFetchCell("SELECT count(`parent_device_id`) from `device_relationships` WHERE `child_device_id` = ?", array($device));
-    if (!$parent_id || $parent_id == null || $parent_id == 0) {
+    if (!$parent_count || $parent_count == null || $parent_count == 0) {
         return false;
     }
 
 
-    $down_parent_count = dbFetchCell("SELECT count(1) from devices as LEFT JOIN devices_attribs as a USING (device_id) LEFT JOIN device_relationships as r ON d.device_id=r.parent_device_id WHERE d.status=0 AND d.ignore=0 AND d.disabled=0 AND r.child_device_id=? AND (d.status_reason='icmp' OR (a.attrib_type='override_icmp_disable' AND a.attrib_value=true))", array($device));
+    $down_parent_count = dbFetchCell("SELECT count(1) from devices as d LEFT JOIN devices_attribs as a ON d.device_id=a.device_id LEFT JOIN device_relationships as r ON d.device_id=r.parent_device_id WHERE d.status=0 AND d.ignore=0 AND d.disabled=0 AND r.child_device_id=? AND (d.status_reason='icmp' OR (a.attrib_type='override_icmp_disable' AND a.attrib_value=true))", array($device));
     if ($down_parent_count == $parent_count) {
         return true;
     }