upit nije izvrsen zbog:
- broj greske=1064
- greska=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 'AND tm <= 202200
ORDER BY tm DESC LIMIT 0, 1' at line 45
- upit=
SELECT trimester, datumobjave, kvartal, sectind, tm,
totalrevCurrent AS totalrev, totalrevPrevious AS totalrev1, totalrevYear AS totalrev5,
opbalanceCurrent AS opbalance, opbalancePrevious AS opbalance1, opbalanceYear AS opbalance5,
contoperCurrent AS contoper, contoperPrevious AS contoper1, contoperYear AS contoper5,
netincomeCurrent AS netincome, netincomePrevious AS netincome1, netincomeYear AS netincome5,
epsCurrent AS eps, epsPrevious AS eps1, epsYear AS eps5,
dilutedavgCurrent AS dilutedavg, dilutedavgPrevious AS dilutedavg1, dilutedavgYear AS dilutedavg5,
fcfCurrent AS fcf, fcfPrevious AS fcf1, fcfYear AS fcf5,
ncfCurrent AS ncf, ncfPrevious AS ncf1, ncfYear AS ncf5,
capxCurrent AS capx, capxPrevious AS capx1, capxYear AS capx5,
totalrev4t AS totalrev4t,
opbalance4t AS opbalance4t,
contoper4t AS contoper4t,
netinc4t AS netinc4t,
eps4t AS eps4t,
dilutedeps4t AS dilutedeps4t,
fcf4t AS fcf4t,
ncf4t AS ncf4t,
capx4t AS capx4t,
totalrev5t AS totalrev5t,
opbalance5t AS opbalance5t,
contoper5t AS contoper5t,
netinc5t AS netinc5t,
eps5t AS eps5t,
dilutedeps5t AS dilutedeps5t,
fcf5t AS fcf5t,
ncf5t AS ncf5t,
capx5t AS capx5t,
totalrev8t AS totalrev8t,
opbalance8t AS opbalance8t,
contoper8t AS contoper8t,
netinc8t AS netinc8t,
eps8t AS eps8t,
dilutedeps8t AS dilutedeps8t,
fcf8t AS fcf8t,
ncf8t AS ncf8t,
capx8t AS capx8t
FROM ind_values
WHERE
sectind =
AND tm <= 202200
ORDER BY tm DESC LIMIT 0, 1