SubscriptionSection::GetSubscriptionSections PHP Method

    public static function GetSubscriptionSections($p_subscriptionId, $p_sectionId = null, $p_languageId = null)
    {
        $queryStr = "SELECT SubsSections.*, Sections.Name, Subscriptions.Type, " . "Languages.Name as LangName, Languages.OrigName as LangOrigName" . " FROM Subscriptions, Sections, SubsSections LEFT JOIN Languages " . " ON SubsSections.IdLanguage = Languages.Id " . " WHERE Subscriptions.Id = {$p_subscriptionId} " . " AND Subscriptions.Id = SubsSections.IdSubscription " . " AND Subscriptions.IdPublication = Sections.IdPublication " . " AND SubsSections.SectionNumber = Sections.Number ";
        if (!is_null($p_sectionId)) {
            $queryStr .= " AND SubsSections.SectionNumber = {$p_sectionId}";
        }
        if (!is_null($p_languageId)) {
            $queryStr .= " AND SubsSections.IdLanguage = {$p_languageId}";
        }
        $queryStr .= " GROUP BY SectionNumber, IdLanguage ORDER BY SectionNumber, LangName";
        $sections = DbObjectArray::Create('SubscriptionSection', $queryStr);
        return $sections;
    }

 protected function getExpirationDate() {
     $expirationDate = null;
     $sections = SubscriptionSection::GetSubscriptionSections($this->m_dbObject->getSubscriptionId());
     foreach ($sections as $section) {
         $sectionExpDate = $section->getExpirationDate();
         if ($sectionExpDate > $expirationDate) {
             $expirationDate = $sectionExpDate;
         }
     }
     return $expirationDate;
 }