From 63622966666729ba82fef8f12484e022500ff867 Mon Sep 17 00:00:00 2001
From: Hypolite Petovan <mrpetovan@gmail.com>
Date: Wed, 13 Dec 2017 10:32:59 -0500
Subject: [PATCH] Add INNER JOIN to admin pending user list please @annando

---
 mod/admin.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/mod/admin.php b/mod/admin.php
index 9c03188097..af6150460e 100644
--- a/mod/admin.php
+++ b/mod/admin.php
@@ -1594,8 +1594,8 @@ function admin_page_users(App $a)
 	/* get pending */
 	$pending = q("SELECT `register`.*, `contact`.`name`, `user`.`email`
 				 FROM `register`
-				 JOIN `contact` ON `register`.`uid` = `contact`.`uid`
-				 JOIN `user` ON `register`.`uid` = `user`.`uid`;");
+				 INNER JOIN `contact` ON `register`.`uid` = `contact`.`uid`
+				 INNER JOIN `user` ON `register`.`uid` = `user`.`uid`;");
 
 
 	/* get users */
-- 
2.39.5