Where clause

[SilverDragonTears]

How do I do a where clause for this if I only want adopts that have the value 'shop' for the field whenisavail to show up?

$stmt = $adopts->join("adoptables_conditions", "adoptables_conditions.id = adoptables.id")
				   ->select("adoptables", array());