POPULIARIAUSIOS PROGRAMOS

NAUJAUSIOS PROGRAMOS

Array
(
    [0] => Array
        (
            [number] => 1064
            [err] => 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 '-15, 15' at line 17
            [text] => SQL
            [sql] => SELECT rec.*, t0.*, 

                                                                               (t0.price * list.addition) as ordering_p,

                                                                               REPLACE( format( (t0.price * list.addition), 2), ',', '') as price,

                                                                               t3.translation as short_desc, t2.translation as item_title, list.addition FROM cms_items as t0 LEFT JOIN cms_items_rec as rec ON rec.id = t0.id

                                                                              LEFT JOIN cms_translations AS t2 ON t2.id = t0.item_title AND t2.lng='lt'  

                                                                              LEFT JOIN cms_translations AS t3 ON t3.id = t0.short_desc AND t3.lng='lt'  

                                                                              LEFT JOIN cms_lists_by_mod AS list ON list.id=t0.fk_currency

                                                                              WHERE rec.active=1 AND rec.trash=0 AND t0.new > 0 AND list.addition != 0

                                                                              ORDER BY  rec.sort   LIMIT -15, 15
        )

)