EROARE SQL:
SELECT
of.id, of.nume, of.moneda, of.durata, transp.nume AS transport, masa.nume AS masa, stele.nume AS stele, l.nume AS localitate, tari.nume AS tara, of.descriere,
of.pozadefault AS poza, c.nume AS cazare, agentii.nume AS agentie,
of.pretdoubleminim AS pret, (of.`pretdoubleminim`/if(of.moneda='ron',4.2,if(of.moneda='usd',1.23,1))) AS pretcomun
FROM
oferte_sejur AS of,
tari, localitati AS l,
cazari AS c,
clasificari AS stele,
clasificari AS masa,
agentii,
clasificari AS transp
WHERE
of.idtara=tari.id AND
l.id=of.idlocalitate AND
agentii.iduser=of.iduser AND
c.id=of.idhotel AND
stele.id=c.clasificare AND
masa.id=of.idmasa AND
of.expira>='2011-12-10'
AND
transp.id=of.idtransport
AND
of.iduser='123' AND
of.idtara='42' AND
of.idlocalitate='4962'
GROUP BY of.id
ORDER BY stele.nume desc, (of.`pretdoubleminim`/if(of.moneda='ron',4.2,if(of.moneda='usd',1.23,1))) 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 19