SELECT SUM(`p`) AS `s`, `id` FROM poi WHERE `m`=90209 AND `k`=73 AND `id` IN (7500,1290,329,40587,9641) GROUP BY `id` ORDER BY `s` DESC, `id` ASC LIMIT 4
Prosze o pomoc.
SELECT SUM(`p`) AS `s`, `id` FROM poi WHERE `m`=90209 AND `k`=73 AND `id` IN (7500,1290,329,40587,9641) GROUP BY `id` ORDER BY `s` DESC, `id` ASC LIMIT 4
SELECT SUM(`p`) AS `s`, `id`, IF(p<0, 0, p) AS p_nieujemne FROM poi WHERE `m`=90209 AND `k`=73 AND `id` IN (7500,1290,329,40587,9641) GROUP BY `id` ORDER BY `s` DESC, `id` ASC LIMIT 4