DIBI nebere slozitejsi vyraz, hlasi jako chybu

Ahoj,

potrebuji poradit s timto problemem.

<?php
SELECT ROUND(( UNIX_TIMESTAMP() - UNIX_TIMESTAMP(datum_narozeni)) /  (86400 * 365), 1)
?>

Tento SQL dotaz je v poradku. A pokud aplikuji slucovaci funkci CONCAT

<?php
SELECT  CONCAT(ROUND(( UNIX_TIMESTAMP() - UNIX_TIMESTAMP(datum_narozeni)) /  (86400 * 365), 1), ' test ')
?>

Tak DIBI zahlasi Fatal error: Uncaught exception ‚DibiException‘ with message 'SQL translate error: SELECT SQL_CALC_FOUND_ROWS CONCAT(ROUND / (86400 * 365), 1), Alone quotetest

V phpMyadminu se dotaz normalne provede. Pokousel jsem se i zaclenit modifikator %sql ale to same.

Muze me nekdo prosim nasmerovat?

Cela metoda vypada takto ( i kdyz to nebude dulezite )

<?php
    protected function getStatsPlayersData2($type)
    {
        $where = "";

        /*                                  'nejstarsi-hraci'   => 'Nejstarší hráči',
                                            'nejmladsi-hraci'   => 'Nejmladší hráči',
                                            'nejvyssi-hraci'    => 'Nejvyšší hráči',
                                            'nejnizsi-hraci'    => 'Nejnižší hráči',
                                            'nejtezsi-hraci'    => 'Nejtěžší hráči',
                                            'nejlehci-hraci'    => 'Nejlehčí hráči',*/

        switch ($type)
        {
            case 'nejstarsi-hraci':
            $where = "datum_narozeni";
            //$value = "UNIX_TIMESTAMP(datum_narozeni) ";
            $value = "ROUND(( UNIX_TIMESTAMP() - UNIX_TIMESTAMP(datum_narozeni)) /  (86400 * 365), 1) ";
            //$age = number_format((time() - $unix) / (86400 * 365), 1);
            //$value = "UNIX_TIMESTAMP(datum_narozeni)";
            $value2 = "datum_narozeni, ";
            $sort  = "ASC";
            break;

            case 'nejmladsi-hraci':
            $where = "datum_narozeni";
            $value = "CONCAT(ROUND(( UNIX_TIMESTAMP() - UNIX_TIMESTAMP(datum_narozeni)) /  (86400 * 365), 1), 'test') "; // tady je takova jako chybka, u poradi ve vypisu pak nebude presne odpovidat, protoze to zaokrouhluji
            $value2 = "datum_narozeni, ";
            $sort  = "DESC";
            break;

            case 'nejvyssi-hraci':
            $where = "vyska";
            $value = "vyska";
            $sort  = "DESC";
            break;

            case 'nejnizsi-hraci':
            $where = "vyska";
            $value = "vyska";
            $sort  = "ASC";
            break;

            case 'nejtezsi-hraci':
            $where = "vaha";
            $value = "vaha";
            $sort  = "DESC";
            break;

            case 'nejlehci-hraci':
            $where = "vaha";
            $value = "vaha";
            $sort  = "ASC";
            break;

            // exit
            default:
                return;
        }

        $this->str = new Strankovani(COMPET_STATS_LIMIT, "l");
        $q = "  SELECT
                SQL_CALC_FOUND_ROWS
                ".$value." as _count,
                ".$value2."
                t2.jmeno as hrac_nazev,
                t2.alternativni_jmeno,
                t3.nazev as soutez_nazev,
                t4.nazev as sezona_nazev,
                t3.seo as soutez_seo,
                t4.seo as sezona_seo,
                t5.nazev as tym_nazev,
                t5.seo as tym_seo,
                n.ID as  zeme_id,
                n.nazev as narodnost_nazev,
                n.zkratka as narodnost_zkratka,
                t1.hracID as hrac_id,
                t1.tymID
                FROM
                soupisky t1
                JOIN rejstrik_hraci t2 ON t2.ID = t1.hracID
                JOIN souteze t3 ON t3.ID = t1.soutezID
                JOIN sezony t4 ON t4.ID = t1.sezonaID
                JOIN rejstrik_tymy t5 ON t5.ID = t1.tymID
                JOIN narodnosti n ON n.ID = t2.narodnost
                WHERE
                soutezID = %i
                AND sezonaID = %i
                ORDER BY ".$where." ".$sort.",  hrac_nazev, hrac_id ASC
                LIMIT ".$this->str->l.", ".$this->str->rows
                ;


        $rows = DIBI::fetchAll($q, Compet::$selected_compet['ID'], Compet::$selected_season['ID']);
        $this->str->pocet_radku = $this->str->PocetRadku();
        DIBI::dump();

        return $rows;
    }
?>

Vypisovana chybka

<?php


Fatal error: Uncaught exception 'DibiDriverException' with message 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'test, '%Y-%m-%d')'

?>

Ja nevim :/

Editoval Kcko (22. 10. 2009 17:04)