upit nije izvrsen zbog:
- broj greske=1054
- greska=Unknown column 'balance.payable' in 'field list'
- 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) / (balance.stockequ - balance.intangibles - balance.goodwill))) AS rank , tm, trimester FROM izracunato WHERE code = 'JNPR' AND tm + 100 >= 202200 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) / (balance.stockequ - balance.intangibles - balance.goodwill))) 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 (balance.stockequ - balance.intangibles - balance.goodwill) > 0