Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT "belina" as jmeno,
- (SELECT count(*) FROM synopsis.va_pohledavky) as pohledavky,
- (SELECT count(*) FROM synopsis.va_pohledavky WHERE p_datum_prevzeti >= '2016-01-01' AND p_datum_prevzeti <= '2016-12-31') as pohledavky_rok,
- (SELECT count(*) FROM synopsis.va_pohledavky_plrozkaz) as EPR,
- (SELECT count(*) FROM synopsis.va_pohledavky_plrozkaz WHERE status = 2) as EPR_odeslane,
- (SELECT count(*) FROM synopsis.va_dopis_online_delivery) as dopis_online,
- (SELECT count(*) FROM synopsis.va_spisy) as spisy,
- (SELECT count(*) FROM synopsis.va_isds_zpravy JOIN synopsis.va_posta ON FKID_posta = ID_posta WHERE posta_typ = 0) as datovky_odeslane,
- (SELECT count(*) FROM synopsis.va_isds_zpravy JOIN synopsis.va_posta ON FKID_posta = ID_posta WHERE posta_typ = 1) as datovky_prijate,
- (SELECT count(*) FROM synopsis.va_posta WHERE posta_typ = 0) as posta_odeslana,
- (SELECT count(*) FROM synopsis.va_posta WHERE posta_typ = 1) as posta_prijata,
- (SELECT count(*) FROM synopsis.va_ukony) as ukony
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement