Query Template: /painel-admin/modulos/noticias/001/sql/sql_not_gal.cfc:202 Execution Time: 0.867 ms Record Count: 10 Cached: No Datasource: CP_MuseuM_V2 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 = 17 ) 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 = 17 )
| | 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 | 13 | 17 | Galeria | | 1 | 153 | | 000153.JPG | | 1 | | | | | | | 2 | 13 | 17 | Galeria | | 1 | 154 | | 000154.jpg | | 1 | | | | | | | 3 | 13 | 17 | Galeria | | 1 | 155 | | 000155.JPG | | 1 | | | | | | | 4 | 13 | 17 | Galeria | | 1 | 156 | | 000156.jpg | | 1 | | | | | | | 5 | 13 | 17 | Galeria | | 1 | 157 | | 000157.JPG | | 1 | | | | | | | 6 | 13 | 17 | Galeria | | 1 | 158 | | 000158.JPG | | 1 | | | | | | | 7 | 13 | 17 | Galeria | | 1 | 159 | | 000159.JPG | | 1 | | | | | | | 8 | 13 | 17 | Galeria | | 1 | 160 | | 000160.JPG | | 1 | | | | | | | 9 | 13 | 17 | Galeria | | 1 | 161 | | 000161.jpg | | 1 | | | | | | | 10 | 13 | 17 | Galeria | | 1 | 162 | | 000162.jpg | | 1 | | | | | |
|