EROARE SQL:
SELECT
of.id, of.nume, of.moneda, stele.nume AS stele, l.nume AS localitate, tari.nume AS tara, of.descriere,
c.nume AS cazare, agentii.nume AS agentie, masa.nume AS masa,
of.pozadefault AS poza,
of.pretdoubleminim AS pret
FROM
oferte_cazare AS of,
tari, localitati AS l,
cazari AS c,
clasificari AS stele,
clasificari AS masa,
agentii
WHERE
of.idtara=tari.id AND
l.id=of.idlocalitate AND
masa.id=of.idmasa AND
agentii.iduser=of.iduser AND
c.id=of.idhotel AND
stele.id=c.clasificare AND
of.tip='' AND
of.expira>='2011-12-10' AND
of.iduser='123' AND
of.idtara='10' AND
of.idlocalitate='558'
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 18