Error by sending a SELECT query

[marinelli82]

Hello

Sometimes when I send the following SQL-Query to the MySQL server I get an error and the whole MySQL server needs to be restarted..
The odd thing is that I don´t get that error every time when I send that query...
I hoped that maybe someone of you could help me


The error (translated from german):

'mysqld-nt.exe made happen an error and will be shut down please restart the program'

My Query:

SELECT sd.kkmID,
       GROUP_CONCAT(DISTINCT kk.rang) AS kkm_raenge,
       COUNT(DISTINCT kk.rang) AS kkm_anzahl,
       sd.lkmID,
       GROUP_CONCAT(DISTINCT lk.rang) AS lkm_raenge, 
       COUNT(DISTINCT lk.rang) AS lkm_anzahl,
       us.ursacheID,
       GROUP_CONCAT(DISTINCT us.rang) AS ursache_raenge,
       COUNT(DISTINCT us.rang) AS ursache_anzahl
FROM kkms AS kk,
     stammdaten AS sd,
     lkms AS lk,
     ursache AS us 
WHERE sd.datensatzID = $datensatzID
  AND kk.kkmID = sd.kkmID
  AND lk.lkmID = sd.lkmID
  AND us.ursacheID = sd.ursacheID 
GROUP BY sd.kkmID, lk.lkmID, us.ursacheID