inc/toolkit.inc.php
changeset 107 fee925b9bdef
parent 91 f6c1336dbef8
child 111 0a2342a64b83
--- a/inc/toolkit.inc.php	Fri Mar 28 21:40:42 2008 +0000
+++ b/inc/toolkit.inc.php	Fri Mar 28 21:57:43 2008 +0000
@@ -153,12 +153,10 @@
         $query = "SELECT 
 			domains.id AS domain_id,
 			zones.owner,
-			records.id,
 			domains.name AS domainname
 			FROM domains
 			LEFT JOIN zones ON domains.id=zones.domain_id 
-			LEFT JOIN records ON records.domain_id=domains.id
-			AND substring(domains.name,1,1) ".$sql_regexp." ".$db->quote("^".$letter);
+			WHERE substring(domains.name,1,1) ".$sql_regexp." ".$db->quote("^".$letter);
 	$db->setLimit(1);
         $result = $db->query($query);
         $numrows = $result->numRows();