select `id`,`name`,`age`,`address_id`,(select `street` from `address` where `person`.`address_id` = `address`.`id` ) `address` from `person` where (select `street` from `address` where `person`.`address_id` = `address`.`id` ) like "%rostokas%" [:a]