create table contact (
  id integer primary key autoincrement,
  name varchar
);

create table contactlist (
  id integer primary key autoincrement,
  name varchar
);

create table contact_to_contactlist (
  contact_id integer,
  contactlist_id integer
);

insert into contact (id,name) values (1,'Sergei');
insert into contact (id,name) values (2,'Ivan');
insert into contact (id,name) values (3,'Alex');

insert into contactlist (id,name) values (1,'Home');
insert into contactlist (id,name) values (2,'Friends');
insert into contactlist (id,name) values (3,'Work');

insert into contact_to_contactlist (contact_id,contactlist_id) values (1,1);
insert into contact_to_contactlist (contact_id,contactlist_id) values (1,2);
insert into contact_to_contactlist (contact_id,contactlist_id) values (2,1);
insert into contact_to_contactlist (contact_id,contactlist_id) values (2,3);
insert into contact_to_contactlist (contact_id,contactlist_id) values (3,1);
insert into contact_to_contactlist (contact_id,contactlist_id) values (3,2);
insert into contact_to_contactlist (contact_id,contactlist_id) values (3,3);

SELECT  * FROM `contact` LEFT JOIN `contact_to_contactlist` ON `contact_to_contactlist`.contact_id = `contact`.id LEFT JOIN `contactlist` ON `contact_to_contactlist`.contactlist_id = `contactlist`.id AND contactlist.id IN(2,1) and contactlist.id IN (1,3)