---

EROARE SQL:

SELECT
      of.id, of.nume, of.moneda, substring(of.descriere,1,1500) AS descriere, of.pret3, marci.nume AS marca, masini.nume AS model, (
SELECT
      poza
FROM
      poze_oferte AS po
WHERE
      po.idoferta=of.id AND
po.tabelaoferta='oferte_rentacar'
ORDER BY pozitie ASC LIMIT 1) AS poza
FROM
      oferte_rentacar AS of, marci_masini AS marci, masini ,agentii
WHERE
      marci.id=masini.idmarca AND
masini.id=of.idmasina AND
of.iduser=agentii.iduser AND
agentii.id='122'
GROUP BY of.id
ORDER BY 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 11

---