upit nije izvrsen zbog:
- broj greske=1054
- greska=Unknown column 'balance.cash' in 'field list'
- upit=CREATE TEMPORARY TABLE t1 SELECT (100 * ((balance.cash + balance.cashother + balance.shinv1 + balance.shinv2 + balance.shinv3 + balance.shinv4 + balance.shinv5 + balance.notes + balance.shasset1 + balance.shasset2 + balance.shasset3 + balance.shasset4 + balance.inventories + balance.currasset) / (balance.payable + balance.liability + balance.expenses + balance.shdebt + balance.liabilityother + balance.taxother + balance.liab1 + balance.liab2))) AS rank , tm, trimester FROM izracunato WHERE code = 'JNPR' AND tm + 100 >= 202200 AND (100 * ((balance.cash + balance.cashother + balance.shinv1 + balance.shinv2 + balance.shinv3 + balance.shinv4 + balance.shinv5 + balance.notes + balance.shasset1 + balance.shasset2 + balance.shasset3 + balance.shasset4 + balance.inventories + balance.currasset) / (balance.payable + balance.liability + balance.expenses + balance.shdebt + balance.liabilityother + balance.taxother + balance.liab1 + balance.liab2))) IS NOT NULL AND (balance.cash + balance.cashother + balance.shinv1 + balance.shinv2 + balance.shinv3 + balance.shinv4 + balance.shinv5 + balance.notes + balance.shasset1 + balance.shasset2 + balance.shasset3 + balance.shasset4 + balance.inventories + balance.currasset) > 0 AND (balance.payable + balance.liability + balance.expenses + balance.shdebt + balance.liabilityother + balance.taxother + balance.liab1 + balance.liab2) > 0