select d.*,c.*,a.* from advertise_boats d inner join customers c on c.customers_id=d.customers_id inner join address_book a on a.customers_id=c.customers_id where d.advertise_boats_id=146 and c.members_status>1