Количество аккаунтов на каждом прокси

SQL |

280 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

SELECT
     proxy.id AS proxy_id,
     COUNT(account_vk.login) AS account_acount
FROM 
     likepanel.proxy
     INNER JOIN likepanel.account_vk
     ON account_vk.proxy_id = proxy.id
WHERE
     account_vk.STATUS = 'active'
     OR account_vk.STATUS = 'need_token'
GROUP BY proxy.id

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

Количество аккаунтов на каждом прокси

Comments