 |
|
 |
| 0/0 |
|
0/0 |
|
|
|
|
select *, Round(((Y_OK*100)/allP)) YPercent, Round(((G_OK*100)/allP)) GPercent
from (
select count(*) allP
from seo_keywords_updates s
where s.position_date=:Date
) allP,
(
select count(*) Y_OK
from seo_keywords_updates s
where s.position_date=:Date and s.status_yandex='OK_PARSE'
) Y_OK,
(
select count(*) G_OK
from seo_keywords_updates s
where s.position_date=:Date and s.status_google='OK'
) G_OK
Выполнено за 0.00955 с. Использовано памяти: 1.13 MB