есть такой запрос
CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT COUNT(IF(apremium > 0, 1, NULL)) AS premium_ads,
- COUNT(*) - COUNT(IF(apremium > 0, 1, NULL)) AS ads_in_rub_with_premium,
- COUNT(*) AS ads_in_rub,
- (SELECT COUNT(*) AS number_ads FROM 1ads WHERE astatus > 0) AS ads_in_region
- FROM 1ads WHERE astatus > 0 AND adrub = 101