Помогите с выборкой из mysql

<?php
$curDate=date( 'd.m.Y', time() );
$date= "SELECT value ";
$date .= "FROM " . $modx->getFullTableName('site_tmplvar_contentvalues');
$date .= "WHERE  tmplvarid='24' OR tmplvarid='25' OR tmplvarid='26' OR tmplvarid='27' OR tmplvarid='28' OR tmplvarid='29' OR tmplvarid='30' OR tmplvarid='31' OR tmplvarid='32' OR tmplvarid='33'";
$dater= $modx->dbQuery($date);

  if (!mysql_num_rows($dater))
      echo ("Нет данных");
  else
  {
    $i=1;
    while ($row = mysql_fetch_array($dater))
    {
  print($row["value"]);
  print('<br/>');
      $i++;
    }
  }

$sql= "SELECT pagetitle ";
$sql .= "FROM " . $modx->getFullTableName('site_content');
$sql .= "WHERE parent='3'";
$res= $modx->dbQuery($sql);


  if (!mysql_num_rows($res))
      echo ("Нет данных");
  else
  {
    $i=1;
    while ($row = mysql_fetch_array($res))
    {
  print($row["pagetitle"]);
  print('<br/>');
      $i++;
    }
  }
?>

$all = getDocumentChildrenTVarOutput(3, range(24, 33));
$curDate=date( 'd.m.Y', time() );
$need_ids = array_keys(array_filter($all, function ($value) use ($curDate) { return ($value == $curDate); } ));

foreach($need_ids as $doc_id)
    echo current($modx->getPageInfo($doc_id,1,'pagetitle'));

<?php
$curDate=date( 'd.m.Y', time() );
$date = "SELECT modx_site_content.pagetitle
         FROM modx_site_content
         where modx_site_content.id in 
         (   
         select modx_site_tmplvar_contentvalues.contentid 
         from modx_site_tmplvar_contentvalues 
         where modx_site_tmplvar_contentvalues.value ='".$curDate."'
         )";
$dater= $modx->dbQuery($date);

  if (!mysql_num_rows($dater))
      echo ("Сегодня нет Дня Ангела");
  else
  {
    $i=1;
    while ($row = mysql_fetch_array($dater))
    {
  print($row["pagetitle"]);
  print('<br/>');
      $i++;
    }
  }
?>