Select (select count(*) from x where name='reddoc') as name_count, (select count(*) from x where email='asd@reddoc.net') as email_count;