Query
Template: /painel-admin/modulos/noticias/001/sql/sql_not_gal.cfc:202
Execution Time: 0.808 ms
Record Count: 20
Cached: No
Datasource: CP_ABM
Lazy: No
SQL:
(
SELECT
NotGal.IdCod_tng,
NotGal.IdCod_tn,
NotGal.Nom_tng,
NotGal.Img_tng,
NotGal.Dis_tng,
NotGalFot.IdCod_tngf,
NotGalFot.Nom_tngf,
NotGalFot.Img_tngf,
NotGalFot.Len_tngf,
NotGalFot.Dis_tngf,
"" AS IdCod_tngv,
"" AS Nom_tngv,
"" AS Des_tngv,
"" AS Url_tngv,
"" AS Dis_tngv
FROM
tab_001_not_gal_fot AS NotGalFot
INNER JOIN tab_001_not_gal AS NotGal ON (NotGalFot.IdCod_tng = NotGal.IdCod_tng)
WHERE
1=1
AND NotGalFot.Dis_tngf = 1
AND NotGal.IdCod_tn = 2815
)
UNION
(
SELECT
NotGal.IdCod_tng,
NotGal.IdCod_tn,
NotGal.Nom_tng,
NotGal.Img_tng,
NotGal.Dis_tng,
"" AS IdCod_tngf,
"" AS Nom_tngf,
"" AS Img_tngf,
"" AS Len_tngf,
"" AS Dis_tngf,
NotGalVid.IdCod_tngv,
NotGalVid.Nom_tngv,
NotGalVid.Des_tngv,
NotGalVid.Url_tngv,
NotGalVid.Dis_tngv
FROM
tab_001_not_gal_vid AS NotGalVid
INNER JOIN tab_001_not_gal AS NotGal ON (NotGalVid.IdCod_tng = NotGal.IdCod_tng)
WHERE
1=1
AND NotGalVid.Dis_tngv = 1
AND NotGal.IdCod_tn = 2815
)
| | IdCod_tng | IdCod_tn | Nom_tng | Img_tng | Dis_tng | IdCod_tngf | Nom_tngf | Img_tngf | Len_tngf | Dis_tngf | IdCod_tngv | Nom_tngv | Des_tngv | Url_tngv | Dis_tngv | | 1 | 485 | 2815 | Galeria | | 1 | 838 | | 000838.webp | | 1 | | | | | | | 2 | 485 | 2815 | Galeria | | 1 | 839 | | 000839.webp | | 1 | | | | | | | 3 | 485 | 2815 | Galeria | | 1 | 840 | | 000840.webp | | 1 | | | | | | | 4 | 485 | 2815 | Galeria | | 1 | 841 | | 000841.webp | | 1 | | | | | | | 5 | 485 | 2815 | Galeria | | 1 | 842 | | 000842.webp | | 1 | | | | | | | 6 | 485 | 2815 | Galeria | | 1 | 843 | | 000843.webp | | 1 | | | | | | | 7 | 485 | 2815 | Galeria | | 1 | 844 | | 000844.webp | | 1 | | | | | | | 8 | 485 | 2815 | Galeria | | 1 | 845 | | 000845.webp | | 1 | | | | | | | 9 | 485 | 2815 | Galeria | | 1 | 846 | | 000846.webp | | 1 | | | | | | | 10 | 485 | 2815 | Galeria | | 1 | 847 | | 000847.webp | | 1 | | | | | | | 11 | 485 | 2815 | Galeria | | 1 | 848 | | 000848.webp | | 1 | | | | | | | 12 | 485 | 2815 | Galeria | | 1 | 849 | | 000849.webp | | 1 | | | | | | | 13 | 485 | 2815 | Galeria | | 1 | 850 | | 000850.webp | | 1 | | | | | | | 14 | 485 | 2815 | Galeria | | 1 | 851 | | 000851.webp | | 1 | | | | | | | 15 | 485 | 2815 | Galeria | | 1 | 852 | | 000852.webp | | 1 | | | | | | | 16 | 485 | 2815 | Galeria | | 1 | 853 | | 000853.webp | | 1 | | | | | | | 17 | 485 | 2815 | Galeria | | 1 | 854 | | 000854.webp | | 1 | | | | | | | 18 | 485 | 2815 | Galeria | | 1 | 855 | | 000855.webp | | 1 | | | | | | | 19 | 485 | 2815 | Galeria | | 1 | 856 | | 000856.webp | | 1 | | | | | | | 20 | 485 | 2815 | Galeria | | 1 | 857 | | 000857.webp | | 1 | | | | | |
|
