$query_posebna = $modx->db->query(" SELECT c.id,c.pagetitle,c.introtext FROM site_content c LEFT JOIN site_tmplvar_contentvalues tv ON c.id=tv.contentid WHERE tv.tmplvarid=1 AND c.parent!=32 AND UNIX_TIMESTAMP(str_to_date(tv.value,'%d-%m-%Y %T'))>=$unix AND c.published=1 AND c.deleted=0 LIMIT 10 "); $posebna = $modx->db->makeArray($query_posebna);