++added:
 -- Show all new items posted by user #65804
 mysql> SELECT * FROM bugs WHERE submitted_by='65804'
  UNION SELECT * FROM task WHERE submitted_by='65804'
  UNION SELECT * FROM patch WHERE submitted_by='65804'
  UNION SELECT * FROM support WHERE submitted_by='65804';
 
 -- Show all follow-ups posted by user #65804
 mysql> SELECT * FROM bugs_history WHERE mod_by='65804' AND field_name='details'
  UNION SELECT * FROM task_history WHERE mod_by='65804' AND field_name='details'
  UNION SELECT * FROM patch_history WHERE mod_by='65804' AND 
field_name='details'
  UNION SELECT * FROM support_history WHERE mod_by='65804' AND 
field_name='details';
 

??changed:
-
 

??changed:
-
 

--
forwarded from https://savannah.gnu.org/maintenance/[EMAIL 
PROTECTED]://savannah.gnu.org/maintenance


_______________________________________________
Savannah-cvs mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/savannah-cvs

Reply via email to