sql

SELECT 
    *
FROM
evente_venue_seat
WHERE
    org_id = 25009
GROUP BY
  screenings_id,
    area_id,
    price_id,
    X,
    Y
HAVING
    COUNT(*) > 1
ORDER BY isSell asc

SELECT sum(r.number) from eos_order_master as m JOIN eos_order_event_rel as r on m.increment_id = r.increment_id where m.order_state in(20,30,40) and r.event_id = 109630;
from_unixtime

select e.id,e.title,r.name,f.name,e.address from evente.evente_event as e LEFT JOIN em_common.ecs_regions as r on e.province_id = r.code  JOIN em_common.ecs_regions as f on e.city_id = f.`code` where e.`status` = 5 and e.address like concat("%",r.name,"%");

SELECT 
    GROUP_CONCAT(id),GROUP_CONCAT(isSell)
FROM
evente_venue_seat
WHERE
    org_id = 24455
and
screenings_id !=0
and `status` !=3
GROUP BY
  screenings_id,
    area_id,
    price_id,
    X,
    Y
HAVING
    COUNT(*) > 1
ORDER BY isSell asc