Привет Всем!
Подскажите в чем может быть причина? Выдает такую ошибку MySQL
MySQL answer: BIGINT UNSIGNED value is out of range in '(`agrupru_factor`.`tree`.`param_level` - `agrupru_factor`.`fw_tree`.`param_level`)'
Цитата (Diakon @ 1.04.2015 - 15:39) |
Подскажите в чем может быть причина? |
SELECT tree.*,
(SELECT param_left FROM fw_tree WHERE param_right>tree.param_left AND tree.param_level-param_level=1 ORDER BY param_left LIMIT 1) AS p_left,
(SELECT param_right FROM fw_tree WHERE param_right>tree.param_left AND tree.param_level-param_level=1 ORDER BY param_left LIMIT 1) AS p_right
FROM fw_tree AS tree
WHERE
tree.module='page'
AND
tree.status='1'
ORDER BY tree.param_left