create table table1(id integer primary key autoincrement, name varchar(20),text varchar(20),user_id integer);
create table table2(id integer primary key autoincrement, text varchar(20),table1_id integer,read integer);
insert into table1(name,user_id) values('test1',1);
insert into table2(text,table1_id,read) values('test_text1',1,1);
insert into table2(text,table1_id,read) values('test_text2',1,1);
insert into table2(text,table1_id,read) values('test_text3',1,0);
insert into table2(text,table1_id,read) values('test_text4',1,0);
select `a`.`name`,count(`b`.`id`) from `table1` as `a` left join `table2` as `b` on `a`.`id` = `b`.`table1_id` where `a`.`user_id` = 1;

Y3JlYXRlIHRhYmxlIHRhYmxlMShpZCBpbnRlZ2VyIHByaW1hcnkga2V5IGF1dG9pbmNyZW1lbnQsIG5hbWUgdmFyY2hhcigyMCksdGV4dCB2YXJjaGFyKDIwKSx1c2VyX2lkIGludGVnZXIpOwpjcmVhdGUgdGFibGUgdGFibGUyKGlkIGludGVnZXIgcHJpbWFyeSBrZXkgYXV0b2luY3JlbWVudCwgdGV4dCB2YXJjaGFyKDIwKSx0YWJsZTFfaWQgaW50ZWdlcixyZWFkIGludGVnZXIpOwppbnNlcnQgaW50byB0YWJsZTEobmFtZSx1c2VyX2lkKSB2YWx1ZXMoJ3Rlc3QxJywxKTsKaW5zZXJ0IGludG8gdGFibGUyKHRleHQsdGFibGUxX2lkLHJlYWQpIHZhbHVlcygndGVzdF90ZXh0MScsMSwxKTsKaW5zZXJ0IGludG8gdGFibGUyKHRleHQsdGFibGUxX2lkLHJlYWQpIHZhbHVlcygndGVzdF90ZXh0MicsMSwxKTsKaW5zZXJ0IGludG8gdGFibGUyKHRleHQsdGFibGUxX2lkLHJlYWQpIHZhbHVlcygndGVzdF90ZXh0MycsMSwwKTsKaW5zZXJ0IGludG8gdGFibGUyKHRleHQsdGFibGUxX2lkLHJlYWQpIHZhbHVlcygndGVzdF90ZXh0NCcsMSwwKTsKc2VsZWN0IGBhYC5gbmFtZWAsY291bnQoYGJgLmBpZGApIGZyb20gYHRhYmxlMWAgYXMgYGFgIGxlZnQgam9pbiBgdGFibGUyYCBhcyBgYmAgb24gYGFgLmBpZGAgPSBgYmAuYHRhYmxlMV9pZGAgd2hlcmUgYGFgLmB1c2VyX2lkYCA9IDE7