select count(*) from ec_problems_log where resolved_date is null select sum(one_if_within_n_days(confirmed_date,1)) as n_in_last_24_hours, sum(one_if_within_n_days(confirmed_date,7)) as n_in_last_7_days from ec_orders_reportable select count(*) as n_products, coalesce(round(avg(price),2), 0) as avg_price from ec_products_displayable select count(*) from ec_customer_service_issues where close_date is null select count(*) from ec_product_comments where approved_p is null select count(*) from ec_user_class_user_map where user_class_approved_p is null or user_class_approved_p='f'