1:
2:
3:
4:
5:
6:

ID | NAME
-----------
1 | A
2 | B

1:
2:
3:
4:
5:

SERVICE_ID | PERSON_ID |TASK_ID
1             | 1             |  1
1             | 2             |  1

1:
2:
3:
4:
5:
6:
7:

SELECT ii_task.ID, ii_task.NAME
FROM `ii_task` 
LEFT JOIN ii_service_person_task 
ON (ii_task.ID=ii_service_person_task.TASK_ID) 
WHERE ii_service_person_task.SERVICE_ID=X

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:

Loading Dump File [C:\Windows\Minidump\Mini032708-02.dmp]
Mini Kernel Dump File: Only registers and stack trace are available

Symbol search path is: SRV*C:\Symbols*http://msdl.microsoft.com/download/symbols
Executable search path is: 
Windows Vista Kernel Version 6000 MP (2 procs) Free x86 compatible
Product: WinNt, suite: TerminalServer SingleUserTS
Built by: 6000.16584.x86fre.vista_gdr.071023-1545
Kernel base = 0x82400000 PsLoadedModuleList = 0x82511e10
Debug session time: Thu Mar 27 12:12:38.007 2008 (GMT+1)
System Uptime: 0 days 0:08:30.776
Loading Kernel Symbols
....................................................................................................................................................................................
Loading User Symbols
Loading unloaded module list
.....
ERROR: FindPlugIns 8007007b
*******************************************************************************
*                                                                             *
*                        Bugcheck Analysis                                    *
*                                                                             *
*******************************************************************************

Use !analyze -v to get detailed debugging information.

BugCheck F4, {3, 90939438, 979b8cd4, 0}



Probably caused by : csrss.exe

Followup: MachineOwner
---------

1: kd> !analyze -v
ERROR: FindPlugIns 8007007b
*******************************************************************************
*                                                                             *
*                        Bugcheck Analysis                                    *
*                                                                             *
*******************************************************************************

CRITICAL_OBJECT_TERMINATION (f4)
A process or thread crucial to system operation has unexpectedly exited or been
terminated.
Several processes and threads are necessary for the operation of the
system; when they are terminated (for any reason), the system can no
longer function.
Arguments:
Arg1: 00000003, Process
Arg2: 90939438, Terminating object
Arg3: 979b8cd4, Process image file name
Arg4: 00000000, Explanatory message (ascii)

Debugging Details:
------------------




PROCESS_OBJECT: 90939438

IMAGE_NAME:  csrss.exe

DEBUG_FLR_IMAGE_TIMESTAMP:  0

MODULE_NAME: csrss

FAULTING_MODULE: 00000000 

PROCESS_NAME:  csrss.exe

CUSTOMER_CRASH_COUNT:  2

DEFAULT_BUCKET_ID:  VISTA_DRIVER_FAULT

BUGCHECK_STR:  0xF4

CURRENT_IRQL:  0

STACK_TEXT:  
9d757cf0 978167e8 000000f4 00000003 90939438 nt!KeBugCheckEx+0x1e
9d757d34 9780514f 87fa8a70 00000001 979dff40 win32k!xxxDesktopThread+0x240
9d757d48 978d8d19 00000004 0245fa90 9d757d64 win32k!xxxCreateSystemThreads+0x54
9d757d58 8248caaa 00000004 0245fad0 77280f34 win32k!NtUserCallNoParam+0x1b
9d757d58 77280f34 00000004 0245fad0 77280f34 nt!KiFastCallEntry+0x12a
WARNING: Frame IP not in any known module. Following frames may be wrong.
0245fad0 00000000 00000000 00000000 00000000 0x77280f34


STACK_COMMAND:  kb

FOLLOWUP_NAME:  MachineOwner

FAILURE_BUCKET_ID:  0xF4_IMAGE_csrss.exe

BUCKET_ID:  0xF4_IMAGE_csrss.exe

Followup: MachineOwner
---------

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:

<!--
function push_option(from, to) {
 var form_name="einteilung";
 var selected_Index = document.forms[form_name].elements[from].selectedIndex;

  /*
Selectliste
*/
  

  var neue_option = document.createElement("option");
  var attr_value = document.createAttribute("value");
  attr_value.nodeValue = document.forms[form_name].elements[from].options[selected_Index].value;
  neue_option.setAttributeNode(attr_value);
  var namenstext = document.createTextNode(document.forms[form_name].elements[from].options[selected_Index].text);
  neue_option.appendChild(namenstext);
  
  var ausgabe = document.getElementById(to);
  
  ausgabe.appendChild(neue_option);
  
  var eventhandler = document.createAttribute("ondblclick");
  eventhandler.nodeValue = "push_option('"+to+"','"+from+"')";
  neue_option.setAttributeNode(eventhandler);
  
  document.forms[form_name].elements[to].options[document.forms[form_name].elements[to].length - 1].selected = true;

/*
geklickte Option löschen
*/  
  document.forms[form_name].elements[from].options[selected_Index] = null;
    
}
--></script>

<form name="einteilung">
<select size="5" name="nicht_noetig" id="role_src" >
<option value="1" ondblclick="push_option('role_src', 'role_tgt')">Name 1</<option>
<option value="2" ondblclick="push_option('role_src', 'role_tgt')">Name 2</<option>
</select>
<select size="5" name="roles[]" id="role_tgt" multiple disabled>
</select>
</form>