View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0026908mantisbtfilterspublic2020-04-23 03:372020-04-23 03:59
Reporterjacekwww Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
Product Version2.24.0 
Summary0026908: Not all users are available in the filter
Description

Hello,

Unfortunately my English is not that good, I write the text in German. Thanks for your understanding.

Problem:
ich habe das Problem in der MantisBT 1.21.1 erstmals entdeckt, in der Version 2.24.0 tritt es ebenfalls auf.

Die Auswahl „Assigned To“ zeigt nicht alle Benutzer an (vgl. Screenshot)

Aus dem MySQL-log geht hervor, dass das Ergebnis folgender Anfrage:

„SELECT DISTINCT p.id, ph.parent_id, p.inherit_global, ph.inherit_parent
                  FROM mantis_project_table p
                  LEFT JOIN mantis_project_hierarchy_table ph
                    ON ph.child_id = p.id
                  WHERE p.enabled = '1'“

+-----+-----------+----------------+----------------+
| id  | parent_id | inherit_global | inherit_parent |
+-----+-----------+----------------+----------------+
{...}
| 170 |       111 |              0 |              0 |
| 171 |      NULL |              0 |           NULL |
| 173 |      NULL |              0 |           NULL |
| 185 |       119 |              0 |              0 |
| 185 |       592 |              0 |              1 |
| 187 |       119 |              0 |              0 |
| 187 |       592 |              0 |              1 |
{...}
| 988 |      NULL |              1 |           NULL |
| 989 |      NULL |              1 |           NULL |
| 990 |       929 |              1 |              1 |
| 992 |      NULL |              1 |           NULL |
| 993 |      NULL |              1 |           NULL |
| 994 |       187 |              1 |              1 |
| 995 |       187 |              0 |              0 |
| 996 |       929 |              1 |              1 |
+-----+-----------+----------------+----------------+
586 rows in set (0.001 sec)

viel mehr Projekte anzeigt, als später abgefragt werden:
(hier wird das Projekt 173 und danach 189 abgefragt, alles da zwischen wird übersprungen)

            44 Query    SELECT u.id, u.username, u.realname, l.access_level
                FROM mantis_project_user_list_table l, mantis_user_table u
                WHERE l.user_id = u.id
                AND u.enabled = 1
                AND l.project_id = 173
            44 Query    SELECT * FROM mantis_project_table WHERE id=189
            44 Query    SELECT id, username, realname, access_level
                FROM mantis_user_table
                WHERE enabled = 1
                    AND access_level >= 90
            44 Query    SELECT u.id, u.username, u.realname, l.access_level
                FROM mantis_project_user_list_table l, mantis_user_table u
                WHERE l.user_id = u.id
                AND u.enabled = 1
                AND l.project_id = 189
SELECT u.id, u.username, u.realname, l.access_level
                FROM mantis_project_user_list_table l, mantis_user_table u
                WHERE l.user_id = u.id
                AND u.enabled = 1
                AND l.project_id = 1
{…}

und so weiter (vgl. Anhang log.txt)

Hier die Daten von einem betroffenen User (ID = 5635)

select * from mantis_project_user_list_table where user_id = 5635;
+------------+---------+--------------+
| project_id | user_id | access_level |
+------------+---------+--------------+
|        185 |    5635 |           60 |
|        199 |    5635 |           60 |
|        330 |    5635 |           60 |
|        731 |    5635 |           25 |
|        931 |    5635 |           60 |
|        969 |    5635 |           60 |
|        990 |    5635 |           60 |
+------------+---------+--------------+
7 rows in set (0.001 sec)

Demanch sollte der User 5635 in der Auswahl stehen, da er auch im Projekt 185 drin ist und auch zugewiesene Ticket hat:

 select project_id, handler_id, status from mantis_bug_table where handler_id = 5635;
+------------+------------+--------+
| project_id | handler_id | status |
+------------+------------+--------+
|        185 |       5635 |     50 |
|        185 |       5635 |     50 |
+------------+------------+--------+
2 rows in set (0.469 sec)

Detailliertes MYSQL-Logfile aus dem Aufruf von

curl -q -k -b mantis.cookies -c mantis.cookies  "${host}/return_dynamic_filters.php?filter_target=handler_id_filter&filter_id=18537&_=1587366232945"

lege ich im Anhang bei.

TagsNo tags attached.
Attached Files
Auswahl_112.png (29,311 bytes)   
Auswahl_112.png (29,311 bytes)   
log.txt (72,054 bytes)    
200422  7:43:07	    43 Change user	xxxxxxxxxxx@192.168.179.38 on mantisdb
		    43 Init DB	mantisdb
		    43 Query	SET NAMES UTF8
		    43 Query	SELECT
			TABLE_NAME,
			CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
		FROM INFORMATION_SCHEMA.TABLES
		WHERE TABLE_SCHEMA=schema()
		    43 Query	SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled='1' ORDER BY priority DESC
		    43 Query	SELECT * FROM mantis_user_table WHERE cookie_string='c5beebb0a8af6e43206871a3a1463cede569770736cb5307d9e6b4f21e3dcec2'
		    43 Query	SELECT * FROM mantis_user_pref_table WHERE user_id IN (3080) AND project_id = 0
		    43 Query	SELECT
			TABLE_NAME,
			CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
		FROM INFORMATION_SCHEMA.TABLES
		WHERE TABLE_SCHEMA=schema()
		    43 Query	SELECT config_id, user_id, project_id, type,  value, access_reqd FROM mantis_config_table
		    43 Query	DELETE FROM mantis_tokens_table WHERE 1587534186 > expiry
		    43 Query	SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=3080
		    43 Query	UPDATE mantis_user_table SET password='680474c84a7abaf8581915266a968c90' WHERE id=3080
		    43 Query	SELECT * FROM mantis_user_table WHERE id IN (3080)
		    43 Query	UPDATE mantis_user_table SET login_count=login_count+1 WHERE id=3080
		    43 Query	UPDATE mantis_user_table SET failed_login_count=0 WHERE id=3080
		    43 Query	UPDATE mantis_user_table SET lost_password_request_count=0 WHERE id=3080
		    43 Query	SELECT * FROM mantis_user_table WHERE id IN (3080)
		    43 Query	SELECT * FROM mantis_tokens_table WHERE type=4 AND owner=3080
		    43 Query	SELECT id FROM mantis_tokens_table WHERE id='1496128' LIMIT 1
		    43 Query	UPDATE mantis_tokens_table SET expiry=1587534486 WHERE id='1496128'
		    44 Change user	mantis2user@192.168.179.38 on mantisdb
		    44 Init DB	mantisdb
		    44 Query	SET NAMES UTF8
		    44 Query	SELECT
			TABLE_NAME,
			CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
		FROM INFORMATION_SCHEMA.TABLES
		WHERE TABLE_SCHEMA=schema()
		    44 Query	SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled='1' ORDER BY priority DESC
		    44 Query	SELECT * FROM mantis_user_table WHERE cookie_string='c5beebb0a8af6e43206871a3a1463cede569770736cb5307d9e6b4f21e3dcec2'
		    44 Query	SELECT * FROM mantis_user_pref_table WHERE user_id IN (3080) AND project_id = 0
		    44 Query	SELECT
			TABLE_NAME,
			CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
		FROM INFORMATION_SCHEMA.TABLES
		WHERE TABLE_SCHEMA=schema()
		    44 Query	SELECT config_id, user_id, project_id, type,  value, access_reqd FROM mantis_config_table
		    44 Query	DELETE FROM mantis_tokens_table WHERE 1587534186 > expiry
		    44 Query	SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=3080
		    44 Query	SELECT * FROM mantis_filters_table WHERE id IN (18537)
		    44 Query	SELECT * FROM mantis_custom_field_table
		    44 Query	SELECT field_id, project_id FROM mantis_custom_field_project_table
		    44 Query	SELECT DISTINCT p.id, ph.parent_id, p.inherit_global, ph.inherit_parent
				  FROM mantis_project_table p
				  LEFT JOIN mantis_project_hierarchy_table ph
				    ON ph.child_id = p.id
				  WHERE p.enabled = '1'
		    44 Query	SELECT * FROM mantis_project_table WHERE id=1
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 1
		    44 Query	SELECT * FROM mantis_project_table WHERE id=2
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 2
		    44 Query	SELECT * FROM mantis_project_table WHERE id=4
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 4
		    44 Query	SELECT * FROM mantis_project_table WHERE id=6
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 6
		    44 Query	SELECT * FROM mantis_project_table WHERE id=19
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 19
		    44 Query	SELECT * FROM mantis_project_table WHERE id=24
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 24
		    44 Query	SELECT * FROM mantis_project_table WHERE id=63
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 63
		    44 Query	SELECT * FROM mantis_project_table WHERE id=64
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 64
		    44 Query	SELECT * FROM mantis_project_table WHERE id=67
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 67
		    44 Query	SELECT * FROM mantis_project_table WHERE id=69
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 69
		    44 Query	SELECT * FROM mantis_project_table WHERE id=85
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 85
		    44 Query	SELECT * FROM mantis_project_table WHERE id=88
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 88
		    44 Query	SELECT * FROM mantis_project_table WHERE id=89
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 89
		    44 Query	SELECT * FROM mantis_project_table WHERE id=91
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 91
		    44 Query	SELECT * FROM mantis_project_table WHERE id=96
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 96
		    44 Query	SELECT * FROM mantis_project_table WHERE id=101
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 101
		    44 Query	SELECT * FROM mantis_project_table WHERE id=111
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 111
		    44 Query	SELECT * FROM mantis_project_table WHERE id=114
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 114
		    44 Query	SELECT * FROM mantis_project_table WHERE id=123
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 123
		    44 Query	SELECT * FROM mantis_project_table WHERE id=124
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 124
		    44 Query	SELECT * FROM mantis_project_table WHERE id=144
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 144
		    44 Query	SELECT * FROM mantis_project_table WHERE id=145
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 145
		    44 Query	SELECT * FROM mantis_project_table WHERE id=148
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 148
		    44 Query	SELECT * FROM mantis_project_table WHERE id=171
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 171
		    44 Query	SELECT * FROM mantis_project_table WHERE id=173
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 173
		    44 Query	SELECT * FROM mantis_project_table WHERE id=189
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 189
		    44 Query	SELECT * FROM mantis_project_table WHERE id=194
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 194
		    44 Query	SELECT * FROM mantis_project_table WHERE id=201
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 201
		    44 Query	SELECT * FROM mantis_project_table WHERE id=210
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 210
		    44 Query	SELECT * FROM mantis_project_table WHERE id=217
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 217
		    44 Query	SELECT * FROM mantis_project_table WHERE id=227
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 227
		    44 Query	SELECT * FROM mantis_project_table WHERE id=242
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 242
		    44 Query	SELECT * FROM mantis_project_table WHERE id=244
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 244
		    44 Query	SELECT * FROM mantis_project_table WHERE id=245
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 245
		    44 Query	SELECT * FROM mantis_project_table WHERE id=250
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 250
		    44 Query	SELECT * FROM mantis_project_table WHERE id=255
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 255
		    44 Query	SELECT * FROM mantis_project_table WHERE id=257
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 257
		    44 Query	SELECT * FROM mantis_project_table WHERE id=262
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 262
		    44 Query	SELECT * FROM mantis_project_table WHERE id=271
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 271
		    44 Query	SELECT * FROM mantis_project_table WHERE id=275
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 275
		    44 Query	SELECT * FROM mantis_project_table WHERE id=297
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 297
		    44 Query	SELECT * FROM mantis_project_table WHERE id=307
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 307
		    44 Query	SELECT * FROM mantis_project_table WHERE id=311
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 311
		    44 Query	SELECT * FROM mantis_project_table WHERE id=315
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 315
		    44 Query	SELECT * FROM mantis_project_table WHERE id=319
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 319
		    44 Query	SELECT * FROM mantis_project_table WHERE id=324
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 324
		    44 Query	SELECT * FROM mantis_project_table WHERE id=327
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 327
		    44 Query	SELECT * FROM mantis_project_table WHERE id=342
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 342
		    44 Query	SELECT * FROM mantis_project_table WHERE id=343
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 343
		    44 Query	SELECT * FROM mantis_project_table WHERE id=363
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 363
		    44 Query	SELECT * FROM mantis_project_table WHERE id=383
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 383
		    44 Query	SELECT * FROM mantis_project_table WHERE id=387
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 387
		    44 Query	SELECT * FROM mantis_project_table WHERE id=397
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 397
		    44 Query	SELECT * FROM mantis_project_table WHERE id=398
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 398
		    44 Query	SELECT * FROM mantis_project_table WHERE id=404
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 404
		    44 Query	SELECT * FROM mantis_project_table WHERE id=411
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 411
		    44 Query	SELECT * FROM mantis_project_table WHERE id=413
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 413
		    44 Query	SELECT * FROM mantis_project_table WHERE id=419
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 419
		    44 Query	SELECT * FROM mantis_project_table WHERE id=423
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 423
		    44 Query	SELECT * FROM mantis_project_table WHERE id=425
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 425
		    44 Query	SELECT * FROM mantis_project_table WHERE id=426
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 426
		    44 Query	SELECT * FROM mantis_project_table WHERE id=430
200422  7:43:08	    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 430
		    44 Query	SELECT * FROM mantis_project_table WHERE id=434
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 434
		    44 Query	SELECT * FROM mantis_project_table WHERE id=493
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 493
		    44 Query	SELECT * FROM mantis_project_table WHERE id=509
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 509
		    44 Query	SELECT * FROM mantis_project_table WHERE id=515
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 515
		    44 Query	SELECT * FROM mantis_project_table WHERE id=523
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 523
		    44 Query	SELECT * FROM mantis_project_table WHERE id=525
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 525
		    44 Query	SELECT * FROM mantis_project_table WHERE id=532
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 532
		    44 Query	SELECT * FROM mantis_project_table WHERE id=537
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 537
		    44 Query	SELECT * FROM mantis_project_table WHERE id=548
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 548
		    44 Query	SELECT * FROM mantis_project_table WHERE id=549
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 549
		    44 Query	SELECT * FROM mantis_project_table WHERE id=551
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 551
		    44 Query	SELECT * FROM mantis_project_table WHERE id=553
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 553
		    44 Query	SELECT * FROM mantis_project_table WHERE id=554
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 554
		    44 Query	SELECT * FROM mantis_project_table WHERE id=562
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 562
		    44 Query	SELECT * FROM mantis_project_table WHERE id=570
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 570
		    44 Query	SELECT * FROM mantis_project_table WHERE id=577
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 577
		    44 Query	SELECT * FROM mantis_project_table WHERE id=592
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 592
		    44 Query	SELECT * FROM mantis_project_table WHERE id=594
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 594
		    44 Query	SELECT * FROM mantis_project_table WHERE id=598
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 598
		    44 Query	SELECT * FROM mantis_project_table WHERE id=601
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 601
		    44 Query	SELECT * FROM mantis_project_table WHERE id=604
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 604
		    44 Query	SELECT * FROM mantis_project_table WHERE id=610
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 610
		    44 Query	SELECT * FROM mantis_project_table WHERE id=613
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 613
		    44 Query	SELECT * FROM mantis_project_table WHERE id=617
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 617
		    44 Query	SELECT * FROM mantis_project_table WHERE id=619
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 619
		    44 Query	SELECT * FROM mantis_project_table WHERE id=630
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 630
		    44 Query	SELECT * FROM mantis_project_table WHERE id=632
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 632
		    44 Query	SELECT * FROM mantis_project_table WHERE id=648
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 648
		    44 Query	SELECT * FROM mantis_project_table WHERE id=649
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 649
		    44 Query	SELECT * FROM mantis_project_table WHERE id=653
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 653
		    44 Query	SELECT * FROM mantis_project_table WHERE id=654
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 654
		    44 Query	SELECT * FROM mantis_project_table WHERE id=659
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 659
		    44 Query	SELECT * FROM mantis_project_table WHERE id=679
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 679
		    44 Query	SELECT * FROM mantis_project_table WHERE id=680
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 680
		    44 Query	SELECT * FROM mantis_project_table WHERE id=681
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 681
		    44 Query	SELECT * FROM mantis_project_table WHERE id=682
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 682
		    44 Query	SELECT * FROM mantis_project_table WHERE id=683
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 683
		    44 Query	SELECT * FROM mantis_project_table WHERE id=692
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 692
		    44 Query	SELECT * FROM mantis_project_table WHERE id=693
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 693
		    44 Query	SELECT * FROM mantis_project_table WHERE id=695
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 695
		    44 Query	SELECT * FROM mantis_project_table WHERE id=698
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 698
		    44 Query	SELECT * FROM mantis_project_table WHERE id=699
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 699
		    44 Query	SELECT * FROM mantis_project_table WHERE id=712
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 712
		    44 Query	SELECT * FROM mantis_project_table WHERE id=729
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 729
		    44 Query	SELECT * FROM mantis_project_table WHERE id=738
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 738
		    44 Query	SELECT * FROM mantis_project_table WHERE id=740
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 740
		    44 Query	SELECT * FROM mantis_project_table WHERE id=744
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 744
		    44 Query	SELECT * FROM mantis_project_table WHERE id=746
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 746
		    44 Query	SELECT * FROM mantis_project_table WHERE id=748
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 748
		    44 Query	SELECT * FROM mantis_project_table WHERE id=753
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 753
		    44 Query	SELECT * FROM mantis_project_table WHERE id=757
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 757
		    44 Query	SELECT * FROM mantis_project_table WHERE id=758
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 758
		    44 Query	SELECT * FROM mantis_project_table WHERE id=760
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 760
		    44 Query	SELECT * FROM mantis_project_table WHERE id=764
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 764
		    44 Query	SELECT * FROM mantis_project_table WHERE id=765
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 765
		    44 Query	SELECT * FROM mantis_project_table WHERE id=775
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 775
		    44 Query	SELECT * FROM mantis_project_table WHERE id=782
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 782
		    44 Query	SELECT * FROM mantis_project_table WHERE id=783
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 783
		    44 Query	SELECT * FROM mantis_project_table WHERE id=785
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 785
		    44 Query	SELECT * FROM mantis_project_table WHERE id=789
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 789
		    44 Query	SELECT * FROM mantis_project_table WHERE id=795
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 795
		    44 Query	SELECT * FROM mantis_project_table WHERE id=796
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 796
		    44 Query	SELECT * FROM mantis_project_table WHERE id=799
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 799
		    44 Query	SELECT * FROM mantis_project_table WHERE id=800
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 800
		    44 Query	SELECT * FROM mantis_project_table WHERE id=802
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 802
		    44 Query	SELECT * FROM mantis_project_table WHERE id=804
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 804
		    44 Query	SELECT * FROM mantis_project_table WHERE id=821
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 821
		    44 Query	SELECT * FROM mantis_project_table WHERE id=822
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 822
		    44 Query	SELECT * FROM mantis_project_table WHERE id=825
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 825
		    44 Query	SELECT * FROM mantis_project_table WHERE id=827
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 827
		    44 Query	SELECT * FROM mantis_project_table WHERE id=830
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 830
		    44 Query	SELECT * FROM mantis_project_table WHERE id=843
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 843
		    44 Query	SELECT * FROM mantis_project_table WHERE id=845
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 845
		    44 Query	SELECT * FROM mantis_project_table WHERE id=846
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 846
		    44 Query	SELECT * FROM mantis_project_table WHERE id=852
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 852
		    44 Query	SELECT * FROM mantis_project_table WHERE id=855
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 855
		    44 Query	SELECT * FROM mantis_project_table WHERE id=858
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 858
		    44 Query	SELECT * FROM mantis_project_table WHERE id=866
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 866
		    44 Query	SELECT * FROM mantis_project_table WHERE id=871
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 871
		    44 Query	SELECT * FROM mantis_project_table WHERE id=875
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 875
		    44 Query	SELECT * FROM mantis_project_table WHERE id=877
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 877
		    44 Query	SELECT * FROM mantis_project_table WHERE id=878
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 878
		    44 Query	SELECT * FROM mantis_project_table WHERE id=883
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 883
		    44 Query	SELECT * FROM mantis_project_table WHERE id=884
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 884
		    44 Query	SELECT * FROM mantis_project_table WHERE id=885
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 885
		    44 Query	SELECT * FROM mantis_project_table WHERE id=893
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 893
		    44 Query	SELECT * FROM mantis_project_table WHERE id=897
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 897
		    44 Query	SELECT * FROM mantis_project_table WHERE id=902
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 902
		    44 Query	SELECT * FROM mantis_project_table WHERE id=911
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 911
		    44 Query	SELECT * FROM mantis_project_table WHERE id=919
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 919
		    44 Query	SELECT * FROM mantis_project_table WHERE id=920
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 920
		    44 Query	SELECT * FROM mantis_project_table WHERE id=928
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 928
		    44 Query	SELECT * FROM mantis_project_table WHERE id=935
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 935
		    44 Query	SELECT * FROM mantis_project_table WHERE id=947
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 947
		    44 Query	SELECT * FROM mantis_project_table WHERE id=950
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 950
		    44 Query	SELECT * FROM mantis_project_table WHERE id=956
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 956
		    44 Query	SELECT * FROM mantis_project_table WHERE id=960
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 960
		    44 Query	SELECT * FROM mantis_project_table WHERE id=964
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 964
		    44 Query	SELECT * FROM mantis_project_table WHERE id=967
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 967
		    44 Query	SELECT * FROM mantis_project_table WHERE id=971
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 971
		    44 Query	SELECT * FROM mantis_project_table WHERE id=972
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 972
		    44 Query	SELECT * FROM mantis_project_table WHERE id=976
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 976
		    44 Query	SELECT * FROM mantis_project_table WHERE id=981
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 981
		    44 Query	SELECT * FROM mantis_project_table WHERE id=987
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 987
		    44 Query	SELECT * FROM mantis_project_table WHERE id=988
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 988
		    44 Query	SELECT * FROM mantis_project_table WHERE id=989
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 989
		    44 Query	SELECT * FROM mantis_project_table WHERE id=992
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 992
		    44 Query	SELECT * FROM mantis_project_table WHERE id=993
		    44 Query	SELECT id, username, realname, access_level
				FROM mantis_user_table
				WHERE enabled = 1
					AND access_level >= 90
		    44 Query	SELECT u.id, u.username, u.realname, l.access_level
				FROM mantis_project_user_list_table l, mantis_user_table u
				WHERE l.user_id = u.id
				AND u.enabled = 1
				AND l.project_id = 993
log.txt (72,054 bytes)   

Activities

jacekwww

jacekwww

2020-04-23 03:58

reporter   ~0063897

Last edited: 2020-04-23 03:59

Output attached from:

SELECT DISTINCT p.id, ph.parent_id, p.inherit_global, ph.inherit_parent
                  FROM mantis_project_table p
                  LEFT JOIN mantis_project_hierarchy_table ph
                    ON ph.child_id = p.id
                  WHERE p.enabled = '1'
select.txt (7,965 bytes)    
SELECT DISTINCT p.id, ph.parent_id, p.inherit_global, ph.inherit_parent
                  FROM mantis_project_table p
                  LEFT JOIN mantis_project_hierarchy_table ph
                    ON ph.child_id = p.id
                  WHERE p.enabled = '1';

id	parent_id	inherit_global	inherit_parent
1	NULL	0	NULL
2	NULL	0	NULL
4	NULL	0	NULL
6	NULL	0	NULL
11	383	0	0
19	NULL	1	NULL
24	NULL	0	NULL
28	703	0	0
28	858	0	1
40	383	0	0
41	613	0	0
41	703	0	0
43	858	0	1
52	632	0	0
63	NULL	0	NULL
64	NULL	0	NULL
67	NULL	0	NULL
69	NULL	0	NULL
70	324	0	0
74	858	0	1
84	19	0	1
85	NULL	0	NULL
88	NULL	0	NULL
89	NULL	0	NULL
91	NULL	0	NULL
92	324	0	0
93	185	0	1
93	324	0	0
94	324	0	0
96	NULL	0	NULL
101	NULL	0	NULL
107	19	0	0
111	NULL	0	NULL
112	324	0	0
113	324	0	0
114	NULL	0	NULL
119	123	0	0
123	NULL	0	NULL
124	NULL	0	NULL
144	NULL	0	NULL
145	NULL	0	NULL
146	145	0	1
148	NULL	0	NULL
149	19	0	1
149	148	0	0
159	111	0	0
163	111	0	0
164	111	0	0
166	24	0	0
167	123	0	0
167	592	0	1
170	111	0	0
171	NULL	0	NULL
173	NULL	0	NULL
185	119	0	0
185	592	0	1
187	119	0	0
187	592	0	1
189	NULL	0	NULL
192	111	0	0
194	NULL	0	NULL
199	330	0	1
199	592	0	1
200	187	0	0
201	NULL	0	NULL
210	NULL	0	NULL
217	NULL	0	NULL
218	939	0	1
220	111	0	0
223	111	0	0
227	NULL	0	NULL
228	227	0	0
229	227	0	0
236	300	0	0
237	300	0	0
238	218	0	1
238	613	0	0
239	218	0	0
241	239	0	0
242	NULL	0	NULL
244	NULL	0	NULL
245	NULL	0	NULL
246	245	0	0
250	NULL	0	NULL
252	239	0	0
253	111	0	0
255	NULL	0	NULL
256	255	0	0
257	NULL	0	NULL
262	NULL	0	NULL
264	267	0	0
267	754	0	1
268	324	0	1
270	111	0	0
271	NULL	0	NULL
274	218	0	1
275	NULL	0	NULL
276	275	0	0
277	275	0	0
280	185	0	0
287	218	0	1
287	754	0	1
292	218	0	1
292	613	0	0
293	613	0	0
297	NULL	0	NULL
300	218	0	1
300	617	0	0
303	267	0	0
304	145	0	1
306	632	0	0
307	NULL	0	NULL
308	324	0	0
310	187	0	0
311	NULL	0	NULL
312	24	0	0
315	NULL	0	NULL
316	111	0	0
317	383	0	0
319	NULL	0	NULL
322	19	0	1
322	245	0	0
324	NULL	0	NULL
327	NULL	0	NULL
328	145	0	1
329	330	0	0
330	123	0	1
330	592	0	1
331	613	0	0
332	111	0	0
338	493	0	1
339	111	0	0
342	NULL	0	NULL
343	NULL	0	NULL
347	245	0	0
348	698	0	1
349	632	1	0
363	NULL	1	NULL
364	324	0	0
365	703	1	0
365	858	1	1
366	632	0	0
367	632	0	0
368	632	0	0
369	632	0	0
373	632	0	0
374	111	1	1
376	632	0	0
378	632	0	0
379	111	1	1
381	218	0	1
381	632	0	0
383	NULL	0	NULL
386	334	1	1
387	NULL	0	NULL
388	334	1	1
393	324	0	1
394	383	1	1
395	632	0	0
397	NULL	0	NULL
398	NULL	1	NULL
404	NULL	0	NULL
406	383	0	0
407	273	0	1
408	532	0	1
409	532	0	1
411	NULL	1	NULL
412	111	1	1
412	324	1	1
413	NULL	1	NULL
415	738	0	0
419	NULL	1	NULL
423	NULL	1	NULL
425	NULL	0	NULL
426	NULL	1	NULL
429	111	1	1
430	NULL	0	NULL
431	493	0	1
433	218	0	1
434	NULL	1	NULL
450	755	1	1
461	754	0	1
463	453	0	1
463	754	0	1
465	454	0	1
465	754	0	1
467	754	1	1
469	754	1	1
471	457	1	1
472	457	1	1
473	458	1	1
474	458	1	1
475	632	1	1
481	570	1	1
493	NULL	1	NULL
497	111	0	1
509	NULL	1	NULL
515	NULL	1	NULL
518	632	0	0
521	520	0	1
521	632	0	0
523	NULL	1	NULL
525	NULL	1	NULL
527	111	1	0
530	527	1	1
531	532	0	1
532	NULL	0	NULL
534	532	0	1
535	324	0	1
536	535	0	1
537	NULL	1	NULL
538	19	1	1
538	24	1	1
542	24	1	1
543	187	0	0
544	493	0	1
545	493	0	1
546	493	0	1
548	NULL	1	NULL
549	NULL	0	NULL
550	187	1	0
551	NULL	1	NULL
552	324	1	1
553	NULL	1	NULL
554	NULL	1	NULL
558	613	1	0
562	NULL	1	NULL
566	187	0	0
569	111	0	1
570	NULL	1	NULL
577	NULL	1	NULL
581	577	1	1
584	123	0	0
584	592	0	1
585	584	0	0
588	584	0	0
588	592	0	1
592	NULL	0	NULL
594	NULL	0	NULL
595	532	0	1
596	111	1	1
598	NULL	0	NULL
601	NULL	1	NULL
602	324	0	0
603	111	0	0
604	NULL	0	NULL
605	604	1	1
606	604	0	0
607	604	0	0
609	532	0	1
610	NULL	1	NULL
611	613	0	0
612	613	0	0
613	NULL	0	NULL
614	111	1	1
617	NULL	1	NULL
619	NULL	1	NULL
620	619	1	1
621	619	1	1
622	619	1	1
623	619	1	1
624	619	1	1
625	619	1	1
626	584	0	0
627	577	1	1
629	632	0	0
630	NULL	0	NULL
631	613	1	1
632	NULL	0	NULL
633	570	1	1
635	218	0	0
635	613	0	0
635	703	0	0
637	632	0	0
638	632	0	0
642	145	0	1
643	604	1	1
644	532	1	1
646	218	1	1
646	613	1	0
647	111	0	1
648	NULL	0	NULL
649	NULL	0	NULL
651	570	1	1
652	570	1	1
653	NULL	1	NULL
654	NULL	1	NULL
659	NULL	1	NULL
662	111	1	1
664	111	1	0
673	187	0	0
676	324	0	0
677	111	0	0
678	676	1	1
679	NULL	1	NULL
680	NULL	0	NULL
681	NULL	1	NULL
682	NULL	1	NULL
683	NULL	0	NULL
684	111	0	0
685	111	1	0
686	648	0	0
690	632	1	1
692	NULL	1	NULL
693	NULL	0	NULL
695	NULL	1	NULL
697	111	1	0
698	NULL	0	NULL
699	NULL	1	NULL
700	699	1	1
701	699	1	1
702	699	1	1
703	699	1	1
706	699	1	1
707	570	1	1
708	218	0	0
708	613	0	0
709	111	0	0
709	858	0	1
710	703	0	0
710	738	0	0
712	NULL	0	NULL
713	712	0	0
714	712	0	0
715	712	0	0
716	712	0	0
717	712	0	0
718	712	0	0
719	712	0	0
720	111	1	0
722	570	0	1
723	703	0	0
723	972	0	1
726	703	1	0
726	858	1	1
727	858	1	1
728	858	0	1
729	NULL	0	NULL
730	324	1	1
730	592	1	1
731	185	1	1
731	592	1	1
732	218	0	1
732	613	0	1
732	703	0	1
733	570	1	1
734	324	0	0
735	734	0	0
736	187	1	0
738	NULL	0	NULL
739	712	0	0
740	NULL	1	NULL
741	570	1	1
742	699	0	0
743	699	1	1
744	NULL	1	NULL
745	111	1	0
746	NULL	1	NULL
748	NULL	1	NULL
749	632	0	0
750	111	1	1
752	532	1	1
753	NULL	1	NULL
754	218	1	1
755	218	1	1
756	592	0	1
757	NULL	1	NULL
758	NULL	0	NULL
760	NULL	1	NULL
761	324	1	0
762	761	1	1
763	111	1	0
764	NULL	1	NULL
765	NULL	1	NULL
766	584	0	1
767	493	0	1
768	63	0	0
769	63	0	0
770	63	0	0
771	570	1	1
773	754	1	1
774	123	1	0
774	785	1	1
775	NULL	1	NULL
776	775	1	0
777	145	1	1
778	785	0	1
782	NULL	1	NULL
783	NULL	1	NULL
784	783	1	0
785	NULL	1	NULL
788	111	1	1
789	NULL	1	NULL
790	792	1	1
791	792	1	1
793	111	1	0
794	783	1	0
795	NULL	1	NULL
796	NULL	1	NULL
797	632	1	0
799	NULL	1	NULL
800	NULL	1	NULL
801	84	0	0
802	NULL	1	NULL
803	19	1	1
804	NULL	1	NULL
805	804	1	0
806	804	1	0
807	804	1	0
809	111	1	0
811	111	0	0
814	111	1	1
815	632	1	1
816	570	1	1
817	218	1	1
817	613	1	1
819	785	1	1
820	111	0	1
821	NULL	1	NULL
822	NULL	1	NULL
823	754	1	1
824	187	0	0
825	NULL	1	NULL
826	111	0	0
827	NULL	0	NULL
828	111	1	1
829	603	0	0
830	NULL	1	NULL
831	830	1	1
832	830	1	1
833	830	1	1
834	830	1	1
836	111	0	0
837	830	1	1
839	699	1	1
840	699	1	1
841	699	1	1
843	NULL	1	NULL
844	185	0	1
844	929	0	1
845	NULL	1	NULL
846	NULL	1	NULL
847	218	1	1
847	613	1	1
848	218	1	1
848	613	1	1
848	846	1	1
850	785	0	0
851	123	1	0
852	NULL	1	NULL
853	187	0	0
854	111	1	1
855	NULL	1	NULL
856	619	0	0
857	858	1	1
858	NULL	1	NULL
859	827	1	1
860	827	1	1
861	827	1	1
862	827	1	1
863	827	1	1
865	111	1	1
866	NULL	1	NULL
867	111	1	1
868	699	1	1
869	699	1	1
870	185	1	1
871	NULL	0	NULL
872	89	0	1
872	871	0	0
873	871	0	0
875	NULL	0	NULL
876	785	1	1
877	NULL	1	NULL
878	NULL	1	NULL
881	111	1	1
883	NULL	1	NULL
884	NULL	1	NULL
885	NULL	1	NULL
886	885	1	1
887	885	1	1
888	858	1	1
889	111	1	0
890	187	1	0
891	858	1	1
892	111	1	1
893	NULL	0	NULL
895	111	1	1
896	584	1	1
897	NULL	1	NULL
898	897	1	1
899	897	1	1
900	897	1	1
901	885	1	1
902	NULL	1	NULL
903	902	1	1
904	902	1	1
905	111	1	1
906	89	1	1
907	89	1	1
908	910	1	1
909	910	0	1
910	111	1	0
911	NULL	0	NULL
912	858	0	1
912	911	0	0
913	912	0	0
914	912	0	0
915	912	0	0
916	912	0	0
917	912	0	0
918	911	0	0
919	NULL	1	NULL
920	NULL	1	NULL
921	111	1	1
922	218	0	1
922	613	0	0
922	918	0	1
924	111	1	1
925	755	1	0
926	754	1	0
927	613	0	0
928	NULL	0	NULL
929	592	0	1
930	929	0	1
931	929	0	1
932	194	0	0
933	194	0	0
934	972	1	1
935	NULL	1	NULL
936	19	1	1
937	972	1	1
938	972	1	1
939	111	0	0
940	939	0	0
941	939	0	0
942	911	1	0
943	85	1	1
944	324	1	0
945	324	1	0
946	324	1	0
947	NULL	0	NULL
948	858	0	1
950	NULL	0	NULL
951	939	0	0
952	939	0	0
953	939	0	0
955	939	0	0
956	NULL	1	NULL
957	111	1	1
958	972	1	1
959	632	0	1
960	NULL	1	NULL
961	939	0	0
962	632	1	0
963	613	1	0
964	NULL	1	NULL
965	89	0	1
966	939	1	0
967	NULL	0	NULL
968	111	0	0
969	929	1	1
971	NULL	1	NULL
972	NULL	1	NULL
973	939	1	0
974	939	1	0
975	613	1	0
976	NULL	1	NULL
977	613	1	0
978	939	1	1
979	111	1	1
980	111	1	1
981	NULL	1	NULL
982	493	1	1
983	493	1	1
984	85	1	1
986	111	0	0
987	NULL	0	NULL
988	NULL	1	NULL
989	NULL	1	NULL
990	929	1	1
992	NULL	1	NULL
993	NULL	1	NULL
994	187	1	1
995	187	0	0
996	929	1	1
select.txt (7,965 bytes)