|
0
sysadminlk
29.11.18
✎
07:26
|
SELECT COUNT( * ) AS 'r', `p_phone`
FROM `t_voice_mail`
WHERE `p_phone` NOT LIKE '0312%'
AND `p_phone` NOT LIKE '00312%'
AND `p_phone` NOT LIKE '0313%'
AND `p_phone` != ''
AND LENGTH( p_phone ) = 10
AND `r` > 1
GROUP BY `p_phone`
ORDER BY `r` DESC
LIMIT 6000
Почему ошибка? без AND `r` > 1 запрос работает
|
|
|
2
sysadminlk
29.11.18
✎
07:58
|
(1) спасибо
SELECT COUNT( * ) AS r, `p_phone`
FROM `t_voice_mail`
WHERE `p_phone` NOT LIKE '0312%'
AND `p_phone` NOT LIKE '00312%'
AND `p_phone` NOT LIKE '0313%'
AND `p_phone` != ''
AND LENGTH( p_phone ) = 10
GROUP BY `p_phone` HAVING `r` > 1
ORDER BY `r` DESC
LIMIT 6000
|
|