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 (100 * ((balance.payable + balance.liability + balance.expenses + balance.s' at line 1
- upit=CREATE TEMPORARY TABLE t1 SELECT (100 * ((balance.payable + balance.liability + balance.expenses + balance.shdebt + balance.liabilityother + balance.taxother + balance.liab1 + balance.liab2 + balance.longdebt + balance.debt1 + balance.debt2 + balance.reserve + balance.employeeBP + balance.defcredit + balance.deftax + balance.discop + balance.longliab + balance.minority) / stockequ)) AS rank , tm, trimester FROM izracunato WHERE code = 'CREC' AND tm + 100 >= AND (100 * ((balance.payable + balance.liability + balance.expenses + balance.shdebt + balance.liabilityother + balance.taxother + balance.liab1 + balance.liab2 + balance.longdebt + balance.debt1 + balance.debt2 + balance.reserve + balance.employeeBP + balance.defcredit + balance.deftax + balance.discop + balance.longliab + balance.minority) / stockequ)) IS NOT NULL AND (balance.payable + balance.liability + balance.expenses + balance.shdebt + balance.liabilityother + balance.taxother + balance.liab1 + balance.liab2 + balance.longdebt + balance.debt1 + balance.debt2 + balance.reserve + balance.employeeBP + balance.defcredit + balance.deftax + balance.discop + balance.longliab + balance.minority) > 0 AND stockequ > 0