select b.*  from tbl_boats as b LEFT JOIN tbl_boat_type as t ON t.id=b.type  where b.status='y' ORDER BY  b.id DESC