Сломали запрос :-(

[zefirok]

Всем привет! Я учусь на С++ программиста и для хобби копаюсь в одной игрушке онлайновой.
В игрушке есть ПвП (игрок против игрока), хотел разделить подсчет убийств на простые (FRAG) и убийства на Арене (FRAG_ARENA) и SQL запрос сломался, ничего не выдает.

В SQL понимаю только базовые запросы, так что такой запрос для меня как Теория Струн. Помогите пожалуйста.

Изначальный запрос(рабочий):

query << "SELECT `scores`.`guid`, `c`.`level`, `c`.`account`, `c`.`RankPoints`, `c`.`HighestRank`, SUM(`kpoints`), SUM(`fpoints`), SUM(`rewpoints`) FROM"
"("
" SELECT `guid` AS `guid`, COUNT(*) AS `kpoints`, 0 AS `fpoints`, SUM(`rewpoints`) AS `cp` FROM `character_kill_rewpoints` WHERE `type` = " << FRAG <<
" AND (`date` BETWEEN " << weekBeginDay << " AND " << weekEndDay << ") GROUP BY `guid`"
" UNION"
" SELECT `guid` AS `guid`, 0 AS `kpoints`, COUNT(*) AS `fpoints`, 0 AS `rewpoints` FROM `character_kill_rewpoints` WHERE `type` = " << FAIL <<
" AND (`date` BETWEEN " << weekBeginDay << " AND " << weekEndDay << ") GROUP BY `guid`"
" UNION"
" SELECT `guid` AS `guid`, 0 AS `kpoints`, 0 AS `fpoints`, SUM(`rewpoints`) AS `cp` FROM `character_kill_rewpoints` WHERE `type` NOT IN (" << FRAG << ", " << FAIL << ")"
" AND (`date` BETWEEN " << weekBeginDay << " AND " << weekEndDay << ") GROUP BY `guid`"
" UNION"
" SELECT `guid` AS `guid`, 0 AS `kpoints`, 0 AS `fpoints`, 0 AS `rewpoints` FROM `characters` WHERE `RankPoints` > 0"
") AS `scores` INNER JOIN `characters` AS `c` ON `scores`.`guid` = `c`.`guid` GROUP BY `guid` ORDER BY `guid` ";



Мой запрос(добавил FRAG_ARENA):

query << "SELECT `scores`.`guid`, `c`.`level`, `c`.`account`, `c`.`RankPoints`, `c`.`HighestRank`, SUM(`kpoints`), SUM(`fpoints`), SUM(`rewpoints`) FROM"
"("
" SELECT `guid` AS `guid`, COUNT(*) AS `kpoints`, 0 AS `fpoints`, SUM(`rewpoints`) AS `cp` FROM `character_kill_rewpoints` WHERE `type` = (" << FRAG << ", " << FRAG_ARENA << ")"
" AND (`date` BETWEEN " << weekBeginDay << " AND " << weekEndDay << ") GROUP BY `guid`"
" UNION"
" SELECT `guid` AS `guid`, 0 AS `kpoints`, COUNT(*) AS `fpoints`, 0 AS `rewpoints` FROM `character_kill_rewpoints` WHERE `type` = " << FAIL <<
" AND (`date` BETWEEN " << weekBeginDay << " AND " << weekEndDay << ") GROUP BY `guid`"
" UNION"
" SELECT `guid` AS `guid`, 0 AS `kpoints`, 0 AS `fpoints`, SUM(`rewpoints`) AS `cp` FROM `character_kill_rewpoints` WHERE `type` NOT IN (" << FRAG << ", " << FRAG_ARENA << ", " << FAIL << ")"
" AND (`date` BETWEEN " << weekBeginDay << " AND " << weekEndDay << ") GROUP BY `guid`"
" UNION"
" SELECT `guid` AS `guid`, 0 AS `kpoints`, 0 AS `fpoints`, 0 AS `rewpoints` FROM `characters` WHERE `RankPoints` > 0"
") AS `scores` INNER JOIN `characters` AS `c` ON `scores`.`guid` = `c`.`guid` GROUP BY `guid` ORDER BY `guid` ";



Заранее огромное спасибо!!!

[p51x]

Замените равнество на in

[zefirok]

Сообщение от p51x

Замените равнество на in

Уточню, так?

query << "SELECT `scores`.`guid`, `c`.`level`, `c`.`account`, `c`.`RankPoints`, `c`.`HighestRank`, SUM(`kpoints`), SUM(`fpoints`), SUM(`rewpoints`) FROM"
"("
" SELECT `guid` AS `guid`, COUNT(*) AS `kpoints`, 0 AS `fpoints`, SUM(`rewpoints`) AS `cp` FROM `character_kill_rewpoints` WHERE `type` IN (" << FRAG << ", " << FRAG_ARENA << ")"
" AND (`date` BETWEEN " << weekBeginDay << " AND " << weekEndDay << ") GROUP BY `guid`"
" UNION"
" SELECT `guid` AS `guid`, 0 AS `kpoints`, COUNT(*) AS `fpoints`, 0 AS `rewpoints` FROM `character_kill_rewpoints` WHERE `type` = " << FAIL <<
" AND (`date` BETWEEN " << weekBeginDay << " AND " << weekEndDay << ") GROUP BY `guid`"
" UNION"
" SELECT `guid` AS `guid`, 0 AS `kpoints`, 0 AS `fpoints`, SUM(`rewpoints`) AS `cp` FROM `character_kill_rewpoints` WHERE `type` NOT IN (" << FRAG << ", " << FRAG_ARENA << ", " << FAIL << ")"
" AND (`date` BETWEEN " << weekBeginDay << " AND " << weekEndDay << ") GROUP BY `guid`"
" UNION"
" SELECT `guid` AS `guid`, 0 AS `kpoints`, 0 AS `fpoints`, 0 AS `rewpoints` FROM `characters` WHERE `RankPoints` > 0"
") AS `scores` INNER JOIN `characters` AS `c` ON `scores`.`guid` = `c`.`guid` GROUP BY `guid` ORDER BY `guid` ";