In EvidenzaEmergenza COVID19bandi in pubblicazione
Select distinct txttif.*, tcttif.* from txttif, tcttif where Txcnt=Tccit and Tctab='txttif' and Tctag=5 and ((Tcdal<='2021-01-27' and Tcall>='2021-01-27') 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<='2021-01-27' and Tcall>='2021-01-27') 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<='2021-01-27' and Tcall>='2021-01-27') or (Tcall is NULL or Tcall='')) order by Tcall desc, Tcdal desc, Txcnt desc
