<?php $results=''; $query = $modx->db->query(" SELECT DISTINCT c.id, c.pagetitle, c.introtext, tv.value img FROM site_content c LEFT JOIN site_tmplvar_contentvalues tv ON c.id = tv.contentid WHERE c.parent=$trenutna AND c.published=1 AND c.deleted=0 ORDER BY c.menuindex LIMIT 50 "); $results = $modx->db->makeArray($query); ?>