The following sql-query creates an error while it is correct in phpmyadmin:
SELECT `gdg_ergebnisse`.`user_id`,
`jos_users`.`name`,
sum( CASE WHEN `anwesend` =0 THEN 25 ELSE 5 + `verloren` + ( `neun` 0.5 ) + ( `pumpe` 0.3 ) + `strafe` + `sonst` END ) AS beitraege,
CASE WHEN sum( `haben` ) IS NULL THEN 0 ELSE min( `haben` ) END AS einzahlung,
CASE WHEN sum( `haben` ) IS NULL THEN 0 ELSE min( `haben` ) END - sum( CASE WHEN `anwesend` =0 THEN 25 ELSE 5 + `verloren` + ( `neun` 0.5 ) + ( `pumpe` 0.3) + `strafe` + `sonst` END ) AS rueckstand
FROM (select `user_id`, sum (`haben`) as haben from `gdg_kasse` group by `user_id`) as gdg_kasse1
right join `gdg_ergebnisse` ON `gdg_ergebnisse`.`user_id` = `gdg_kasse1`.`user_id` LEFT JOIN `jos_users` ON `gdg_ergebnisse`.`user_id` =`jos_users`.`id` GROUP BY `user_id` order by jos_users.name
Any suggestions ?
psychodad71