CREATE FUNCTION SearchRoot(id INT)
BEGIN
DECLARE parent INT;
SET parent = id;
REPEAT
SET id = parent;
SET parent = (SEARCH `id_parent` FROM `table` WHERE `id` = id);
UNTIL parent > 0 END REPEAT;
RETURN id;
ENDSELECT COUNT(*),
SUBSTRING_INDEX(SUBSTRING_INDEX(`params`, '"', -2), '"', 1) AS `type`
FROM `table`
GROUP BY `type`ls -l configure что показывает? Возможно не установлено разрешение на запуск скрипта.
SELECT `t2`.*
FROM (
SELECT `t1`.`strana`, `t1`.`min_price`, MAX(`t2`.`date`) AS `max_date`
FROM (
SELECT `strana`, MIN(`price`) AS `min_price`
FROM `table`
GROUP BY `strana`
) AS `t1`
JOIN `table` AS `t2` ON `t2`.`strana` = `t1`.`strana`
AND `t2`.`price` = `t1`.`min_price`
GROUP BY `strana`
) AS `t1`
JOIN `table` AS `t2` ON `t2`.`strana` = `t1`.`strana`
AND `t2`.`date` = `t1`.`max_date` AND `t2`.`price` = `t1`.`min_price`UPDATE `users` AS `u`
JOIN (
SELECT SUM(`sum`) AS `s`, `user_id`
FROM `user_deposits`
GROUP BY `user_id`
) AS `d` ON `d`.`user_id` = `u`.`id`
SET `u`.`balance` = `u`.`balance` + `d`.`s`/100*5SELECT `name`, GROUP_CONCAT(`order_id`), SUM(`count`)
FROM `orders`
GROUP BY `name`