SQLize Online / PHPize Online  /  SQLtest Online

create table if not exists orders ( id integer, name text, client text, deadline text, placed_at text, primary key(id) ); insert into orders (id, name, client, deadline, placed_at) values (1, 'name1', 'c1', '2017-11-23 19:12:00', '2017-11-22 10:01:00'); insert into orders (id, name, client, deadline, placed_at) values (123, 'name2', 'c2', '2017-11-23 19:12:00', '2017-11-22 10:00:00'); insert into orders (id, name, client, deadline, placed_at) values (1337, 'name1', 'c1', '2017-11-23 19:12:00', '2017-11-22 10:09:00'); insert into orders (id, name, client, deadline, placed_at) values (124, 'name3', 'c3', '2017-11-23 19:10:00', '2017-11-22 13:01:00'); select id, client, name, placed_at, deadline, count(*) from orders group by name, client, date(deadline, '%Y-%m-%d'), date(placed_at, '%Y-%m-%d') having count(*) > 1 order by count(*);