1. $unix = time();
  2. $query_posebna = $modx->db->query("
  3. SELECT c.id,c.pagetitle,c.introtext
  4. FROM site_content c
  5. LEFT JOIN site_tmplvar_contentvalues tv
  6. ON c.id=tv.contentid
  7. WHERE tv.tmplvarid=1 AND c.parent!=32
  8. AND UNIX_TIMESTAMP(str_to_date(tv.value,'%d-%m-%Y %T'))>=$unix
  9. AND c.published=1 AND c.deleted=0
  10. LIMIT 10
  11. ");
  12. $posebna = $modx->db->makeArray($query_posebna);
  13. $st_ponudb = count($posebna);