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