SQL Statement failed on preparation: SELECT
sey_id,tarih,
MAX(CASE WHEN tur_id = 11 THEN rakam ELSE 0 END) AS Total,
MAX(CASE WHEN tur_id = 13 THEN rakam ELSE 0 END) AS AB,
MAX(CASE WHEN tur_id = 15 THEN rakam ELSE 0 END) AS ABC,
MAX(CASE WHEN tur_id = 19 THEN rakam ELSE 0 END) AS total_sira,
MAX(CASE WHEN tur_id = 20 THEN rakam ELSE 0 END) AS AB_sira,
MAX(CASE WHEN tur_id = 21 THEN rakam ELSE 0 END) AS ABC_sira,
MAX(CASE WHEN tur_id = 29 THEN rakam ELSE 0 END) AS sezon,
MAX(CASE WHEN tur_id = 30 THEN rakam ELSE 0 END) AS bolum
FROM rakamlar WHERE tarih = ? GROUP BY sey_id
HAVING
MAX(CASE WHEN tur_id IN (11, 13, 15) THEN 1 ELSE 0 END) = 1
ORDER BY ABC DESC' SQL Statement failed on preparation: SELECT
sey_id,tarih,
MAX(CASE WHEN tur_id = 11 THEN rakam ELSE 0 END) AS Total,
MAX(CASE WHEN tur_id = 13 THEN rakam ELSE 0 END) AS AB,
MAX(CASE WHEN tur_id = 15 THEN rakam ELSE 0 END) AS ABC,
MAX(CASE WHEN tur_id = 19 THEN rakam ELSE 0 END) AS total_sira,
MAX(CASE WHEN tur_id = 20 THEN rakam ELSE 0 END) AS AB_sira,
MAX(CASE WHEN tur_id = 21 THEN rakam ELSE 0 END) AS ABC_sira,
MAX(CASE WHEN tur_id = 29 THEN rakam ELSE 0 END) AS sezon,
MAX(CASE WHEN tur_id = 30 THEN rakam ELSE 0 END) AS bolum
FROM rakamlar WHERE tarih = ? GROUP BY sey_id
HAVING
MAX(CASE WHEN tur_id IN (11, 13, 15) THEN 1 ELSE 0 END) = 1
ORDER BY ABC DESC LIMIT 0,3'