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?
Code:
$stmt = $adopts->join("adoptables_conditions", "adoptables_conditions.id = adoptables.id")
->select("adoptables", array());