In EvidenzaEmergenza COVID19bandi in pubblicazione
Select distinct txttif.*, tcttif.* from txttif, tcttif where Txcnt=Tccit and Tctab='txttif' and Tctag=5 and ((Tcdal<='2020-07-16' and Tcall>='2020-07-16') or (Tcall is NULL or Tcall='')) order by Tcall desc, Tcdal desc, Txcnt desc
Select distinct txttif.*, tcttif.* from txttif, tcttif where Txcnt=Tccit and Tctab='txttif' and Tctag=49 and ((Tcdal<='2020-07-16' and Tcall>='2020-07-16') or (Tcall is NULL or Tcall='')) order by Tcall desc, Tcdal desc, Txcnt desc
Select distinct txttif.*, tcttif.* from txttif, tcttif where Txcnt=Tccit and Tctab='txttif' and Tctag=31 and ((Tcdal<='2020-07-16' and Tcall>='2020-07-16') or (Tcall is NULL or Tcall='')) order by Tcall desc, Tcdal desc, Txcnt desc
