Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. SELECT "belina" as jmeno,
  2. (SELECT count(*) FROM synopsis.va_pohledavky) as pohledavky,
  3. (SELECT count(*) FROM synopsis.va_pohledavky WHERE p_datum_prevzeti >= '2016-01-01' AND p_datum_prevzeti <= '2016-12-31') as pohledavky_rok,
  4. (SELECT count(*) FROM synopsis.va_pohledavky_plrozkaz) as EPR,
  5. (SELECT count(*) FROM synopsis.va_pohledavky_plrozkaz WHERE status = 2) as EPR_odeslane,
  6. (SELECT count(*) FROM synopsis.va_dopis_online_delivery) as dopis_online,
  7. (SELECT count(*) FROM synopsis.va_spisy) as spisy,
  8. (SELECT count(*) FROM synopsis.va_isds_zpravy JOIN synopsis.va_posta ON FKID_posta = ID_posta WHERE posta_typ = 0) as datovky_odeslane,
  9. (SELECT count(*) FROM synopsis.va_isds_zpravy JOIN synopsis.va_posta ON FKID_posta = ID_posta WHERE posta_typ = 1) as datovky_prijate,
  10. (SELECT count(*) FROM synopsis.va_posta WHERE posta_typ = 0) as posta_odeslana,
  11. (SELECT count(*) FROM synopsis.va_posta WHERE posta_typ = 1) as posta_prijata,
  12. (SELECT count(*) FROM synopsis.va_ukony) as ukony
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement