select date(`created_at`) as create_date, sum(if(type = 'new', 1,0)) as new_count, sum(if(type = remove, 1,0)) as rm_count
from actions
where user_id = 1 and created_at > DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)
group by create_dateDATE(orders.created_at) >= :start
SELECT orders.delivery, SUM(orders.delivery) AS summ
FROM orders
JOIN baskets ON orders.basket_id=baskets.id
WHERE baskets.purchase_status = 3 AND orders.deleted_at IS NULL
AND orders.created_at >= :start AND orders.created_at <= (:finish + interval 1 day)
GROUP BY orders.deliverySELECT SUM(if(orders.delivery = "kazpost", orders.delivery,0)) AS kazpost,
SUM(if(orders.delivery = "courier", orders.delivery,0)) AS courier,
SUM(if(orders.delivery = "pickup", orders.delivery,0)) AS pickup
FROM orders
JOIN baskets ON orders.basket_id=baskets.id
WHERE baskets.purchase_status = 3 AND orders.deleted_at IS NULL
AND orders.created_at >= :start AND orders.created_at <= (:finish + interval 1 day)DELETE FROM Users WHERE regdate < (NOW() - interval 1 day) AND confirmed = 0;create temporary table external_geo_ids (ext_id int(11) not null);
insert into external_geo_ids values (1),(2),(-1);
select /**/
from external_geo_ids
left join geo_regions_yandex on GeoRegionId=ext_id;select /**/
from (
select 1 as ext_id
union all
select 2
union all
select -1
) external_geo_ids
left join geo_regions_yandex on GeoRegionId=ext_id;select property_reg_num, property_owner_name_id from
tablename y1
join tablename y2 using(property_reg_num, property_owner_name_id)
join tablename y3 using(property_reg_num, property_owner_name_id)
where y2.property_record_on_year = y1.property_record_on_year + 1
and y3.property_record_on_year = y2.property_record_on_year + 1$mysqli->set_charset('utf8');
select
a.id, a.title, a.content,
count(c.id) comments
from
articles a
left join comments c on c.article_id = a.id
group by a.idТ.е организовать единую точку управления этими серверами.