function getByEmail($email = null)
{
global $pommo;
$dbo =& Pommo::$_dbo;
$o = array();
$query = "\n SELECT\n p.*\n FROM\n " . $dbo->table['subscriber_pending'] . " p,\n " . $dbo->table['subscribers'] . " s\n WHERE\n s.subscriber_id = p.subscriber_id\n AND s.email = '%s'\n AND s.status IN(1,2)\n LIMIT 1";
$query = $dbo->prepare($query, array($email));
while ($row = $dbo->getRows($query)) {
$o = Pommo_Pending::makeDB($row);
}
return empty($o) ? false : $o;
}