$stmt = $adopts->join("adoptables_conditions", "adoptables_conditions.id = adoptables.id") ->select("adoptables", array(), "breed = 'short'", "1 ordered by cost ASC");