gistfile1.aw

<?php
        $adapter = $this->getAdapter();
        $langQuoted = $adapter->quote($lang);
        
        $sql = "
            (SELECT * FROM `news` WHERE published = 1 AND lang = " . $langQuoted . ")
            UNION ALL
            (SELECT * FROM `events` WHERE published = 1 AND lang = " . $langQuoted . ")
            ORDER BY `date` DESC
            ";
        
        $statement = $adapter->query($sql);
        
        $result = $statement->fetchAll();
        
        return $result;