[sql] chiste

Viewer

*** This page was generated with the meta tag "noindex, nofollow". This happened because you selected this option before saving or the system detected it as spam. This means that this page will never get into the search engines and the search bot will not crawl it. There is nothing to worry about, you can still share it with anyone.

copy download embed printName: chiste

(SELECT COUNT(*) AS Люди,
SUM( vig.summa ) AS Услуги,
(SELECT COUNT( t1.fio )
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio,
DTR
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 1"
AND amount IS NULL) AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL ; ) AS Нет_услуг_у_Людей , "1" AS Отделение
FROM
(SELECT t1.fio
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 1") AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL) AS [GO],
(SELECT summa,
FM +" "+ IM + " " + OT AS fio
FROM
(SELECT SUM(amount) AS summa,
FM,
IM,
OT
FROM
(SELECT *
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 1"
AND amount>0) AS [%$##@_Alias]
GROUP BY FM, IM, OT) AS [%$##@_Alias]
WHERE summa>0) AS vig
WHERE GO.fio = vig.fio; )
UNION
::~(SELECT COUNT(*) AS Люди,
SUM( vig.summa ) AS Услуги,
(SELECT COUNT( t1.fio )
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio,
DTR
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 2"
AND amount IS NULL) AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL ; ) AS Нет_услуг , "2" AS Отделение
FROM
(SELECT t1.fio
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 2") AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL) AS [GO],
(SELECT summa,
FM +" "+ IM + " " + OT AS fio
FROM
(SELECT SUM(amount) AS summa,
FM,
IM,
OT
FROM
(SELECT *
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 2"
AND amount>0) AS [%$##@_Alias]
GROUP BY FM, IM, OT) AS [%$##@_Alias]
WHERE summa>0) AS vig
WHERE GO.fio = vig.fio; )
UNION
::~(SELECT COUNT(*) AS Люди,
SUM( vig.summa ) AS Услуги,
(SELECT COUNT( t1.fio )
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio,
DTR
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 3"
AND amount IS NULL) AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL ; ) AS Нет_услуг , "3" AS Отделение
FROM
(SELECT t1.fio
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 3") AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL) AS [GO],
(SELECT summa,
FM +" "+ IM + " " + OT AS fio
FROM
(SELECT SUM(amount) AS summa,
FM,
IM,
OT
FROM
(SELECT *
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 3"
AND amount>0) AS [%$##@_Alias]
GROUP BY FM, IM, OT) AS [%$##@_Alias]
WHERE summa>0) AS vig
WHERE GO.fio = vig.fio; )
UNION
::~(SELECT COUNT(*) AS Люди,
SUM( vig.summa ) AS Услуги,
(SELECT COUNT( t1.fio )
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio,
DTR
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 4"
AND amount IS NULL) AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL ; ) AS Нет_услуг , "4" AS Отделение
FROM
(SELECT t1.fio
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 4") AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL) AS [GO],
(SELECT summa,
FM +" "+ IM + " " + OT AS fio
FROM
(SELECT SUM(amount) AS summa,
FM,
IM,
OT
FROM
(SELECT *
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 4"
AND amount>0) AS [%$##@_Alias]
GROUP BY FM, IM, OT) AS [%$##@_Alias]
WHERE summa>0) AS vig
WHERE GO.fio = vig.fio; )
UNION
::~(SELECT COUNT(*) AS Люди,
SUM( vig.summa ) AS Услуги,
(SELECT COUNT( t1.fio )
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio,
DTR
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 5"
AND amount IS NULL) AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL ; ) AS Нет_услуг , "5" AS Отделение
FROM
(SELECT t1.fio
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 5") AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL) AS [GO],
(SELECT summa,
FM +" "+ IM + " " + OT AS fio
FROM
(SELECT SUM(amount) AS summa,
FM,
IM,
OT
FROM
(SELECT *
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 5"
AND amount>0) AS [%$##@_Alias]
GROUP BY FM, IM, OT) AS [%$##@_Alias]
WHERE summa>0) AS vig
WHERE GO.fio = vig.fio; )
UNION
::~(SELECT COUNT(*) AS Люди,
SUM( vig.summa ) AS Услуги,
(SELECT COUNT( t1.fio )
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio,
DTR
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста, проживающих в домах муниципального специализированного жилищного фонда для социальной защиты отдельных категорий граждан"
AND amount IS NULL) AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL ; ) AS Нет_услуг , "6" AS Отделение
FROM
(SELECT t1.fio
FROM
(SELECT *
FROM
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста, проживающих в домах муниципального специализированного жилищного фонда для социальной защиты отдельных категорий граждан") AS t1
LEFT JOIN
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
ON t2.fio = t1.fio) AS tk
WHERE tk.t2.fio IS NOT NULL) AS [GO],
(SELECT summa,
FM +" "+ IM + " " + OT AS fio
FROM
(SELECT SUM(amount) AS summa,
FM,
IM,
OT
FROM
(SELECT *
FROM tab1
WHERE dep="Отделение социального обслуживания на дому граждан пожилого возраста, проживающих в домах муниципального специализированного жилищного фонда для социальной защиты отдельных категорий граждан"
AND amount>0) AS [%$##@_Alias]
GROUP BY FM, IM, OT) AS [%$##@_Alias]
WHERE summa>0) AS vig
WHERE GO.fio = vig.fio; )
UNION
::~(SELECT "" ,
"",
(SELECT COUNT( t2.fio )
FROM
(SELECT *
FROM
(SELECT DISTINCT fio
FROM tab3
WHERE vid1=4) AS t2
LEFT JOIN
(SELECT DISTINCT FM +" "+ IM +" "+OT AS fio
FROM tab1
WHERE dep IN ("Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 1", "Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 2", "Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 3" , "Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 4" , "Отделение социального обслуживания на дому граждан пожилого возраста и инвалидов 5" , "Отделение социального обслуживания на дому граждан пожилого возраста, проживающих в домах муниципального специализированного жилищного фонда для социальной защиты отдельных категорий граждан")) AS t1
ON t2.fio = t1.fio) AS tk
WHERE tk.t1.fio IS NULL; ), "Невошедшие в Выгруску "
FROM tab3 );

Editor

You can edit this paste and save as new:

fullscreen copy clear

Syntax Highlighting

Title / Paste Name

Meta robots tag

reCaptcha

File Description

chiste
Paste Code
06 May-2021
19.06 Kb

You can Share it:

Latest Code Pastes

Full list

Tools

[sql] chiste

Viewer

Editor