Modified: freeswitch/trunk/src/mod/applications/mod_commands/mod_commands.c (17268 => 17269)

--- freeswitch/trunk/src/mod/applications/mod_commands/mod_commands.c	2010-04-12 20:10:25 UTC (rev 17268)
+++ freeswitch/trunk/src/mod/applications/mod_commands/mod_commands.c	2010-04-08 00:09:16 UTC (rev 17269)
@@ -3350,7 +3350,7 @@
 		}
 	} else if (!strcasecmp(command, "distinct_channels")) {
 		sprintf(sql, "select * from channels left join calls on "
-				"channels.uuid=calls.caller_uuid where channels.hostname='%s' channels.uuid not in (select callee_uuid from calls where hostname='%s') order by created_epoch", hostname, hostname);
+				"channels.uuid=calls.caller_uuid where channels.hostname='%s' and channels.uuid not in (select callee_uuid from calls where hostname='%s') order by created_epoch", hostname, hostname);
 		if (argv[2] && !strcasecmp(argv[1], "as")) {
 			as = argv[2];
 		}