select b.*,c.*,a.* from boats_details b inner join boats_classes l on l.id=b.class_id inner join customers c on c.customers_id=b.customers_id inner join address_book a on a.customers_id=c.customers_id where l.class_category in ('Power Boat','Commercial') and b.boats_details_id=5582053 and c.members_status>1