create table images (
  id integer not null primary key,
  status integer,
  name integer);

create table deals (
  id integer not null primary key,
  image_id integer,
  status character varying,
  name integer);

insert into images values (1, 1, 1), (2,2,2), (3,3,3);
insert into deals values
  (1, 1,  '', 1),
  (2, 2, 'a', 1),
  (3, 2, 'online', 1),
  (4, 3, 'online', 1),
  (5, 3, 'online', 1),
  (6, 3, 'offline', 1);

SELECT images.*,images.id FROM images join deals on deals.image_id=images.id group by images.id having(count(images.id)>1);
SELECT images.*,images.id FROM images join deals on deals.image_id=images.id and deals.status='online'  group by images.id having(count(images.id)>1);

drop table images;
drop table deals;

NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "images_pkey" for table "images"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "deals_pkey" for table "deals"
query result with 2 rows discarded.

query result with 1 row discarded.


Query returned successfully with no result in 71 ms.