--- a/admin/linkAmendments.php
+++ b/admin/linkAmendments.php
@@ -2,12 +2,10 @@
 include_once ("../lib/common.inc.php");
 $query = 'SELECT c."CNID",c."parentCN",p."childCN" FROM contractnotice as c  LEFT OUTER JOIN contractnotice as p on c."parentCN" = p."CNID"
 WHERE
-c."parentCN" > 0 AND p."childCN" IS NULL ';
+c."parentCN" IS NOT NULL AND p."childCN" IS NULL ';
 $query = $conn->prepare($query);
 	$query->execute();
-	if (!$query) {
 		databaseError($conn->errorInfo());
-	}
 foreach ($query->fetchAll() as $row) {
   $conn->exec('UPDATE contractnotice SET "childCN" = \'' .
 			 $row['CNID'] . '\' where "CNID" = \'' .
@@ -30,15 +28,13 @@
       FROM contractnotice
       GROUP BY "parentCN" 
       HAVING COUNT(*) > 1 
-      AND "parentCN" != 0
+      AND "parentCN" IS NOT NULL
 )
-AND "childCN" = 0
+AND "childCN" IS NULL
 GROUP BY "parentCN" having count(*) > 1';
 $query = $conn->prepare($query);
 	$query->execute();
-	if (!$query) {
 		databaseError($conn->errorInfo());
-	}
 foreach ($query->fetchAll() as $row) {
 	$cnids = explode(",",str_replace(Array("{","}"),"",$row['array_agg']));
 	$last_cnid = array_pop($cnids);