Oh I see, this is because
whenisavail field is present in both columns. The trick here is:
PHP Code:
$stmt = $adopts->join("adoptables_conditions", "adoptables_conditions.id = adoptables.id")
->select("adoptables", array(), constant(PREFIX)."adoptables.whenisavail = 'shop'");