EROARE SQL:

SELECT
      of.id, of.nume, of.moneda, of.pret, of.tipdestinatie, stele.nume AS stele, of.descriere, of.pozadefault AS poza, agentii.nume AS agentie, masa.nume AS masa, of.durata
FROM
      oferte_circuit AS of, clasificari AS stele, agentii, clasificari AS masa
WHERE
      stele.id=of.idstele AND
agentii.iduser=of.iduser AND
masa.id=of.idmasa AND
of.expira>='2011-12-10' AND
of.iduser='123' AND
of.idtransport='6' AND
( of.idtara='42' or of.enumtari like '%{42,%' )
GROUP BY of.id
ORDER BY stele.nume desc, of.datamodificare desc, of.id desc LIMIT -10,10

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 '-10,10' at line 8