Error
  • Unknown column 'analisisformal.total' in 'order clause' SQL=SELECT `analisisformal`.*, `categorias`.`cf_id_categoria_s` AS `categorias.cf_id_categoria_s`, `categorias`.`cf_uid` AS `categorias.cf_uid`, `categorias`.`cf_created` AS `categorias.cf_created`, `categorias`.`cf_modified` AS `categorias.cf_modified`, `categorias`.`cf_created_by` AS `categorias.cf_created_by`, `categorias`.`cf_modified_by` AS `categorias.cf_modified_by`, `categorias`.`cf_ipaddress` AS `categorias.cf_ipaddress`, `categorias`.`cf_user_id` AS `categorias.cf_user_id`, `categorias`.`d_categoria_s` AS `categorias.d_categoria_s`, `categorias`.`ca_signo_desc` AS `categorias.ca_signo_desc`, `categorias`.`ca_signo_obs` AS `categorias.ca_signo_obs`, `subcategorias`.`cf_id_categoria_s` AS `subcategorias.cf_id_categoria_s`, `subcategorias`.`cf_id_subcategoria_s` AS `subcategorias.cf_id_subcategoria_s`, `subcategorias`.`cf_uid` AS `subcategorias.cf_uid`, `subcategorias`.`cf_created` AS `subcategorias.cf_created`, `subcategorias`.`cf_modified` AS `subcategorias.cf_modified`, `subcategorias`.`cf_created_by` AS `subcategorias.cf_created_by`, `subcategorias`.`cf_modified_by` AS `subcategorias.cf_modified_by`, `subcategorias`.`cf_ipaddress` AS `subcategorias.cf_ipaddress`, `subcategorias`.`cf_user_id` AS `subcategorias.cf_user_id`, `subcategorias`.`d_subcategoria_s` AS `subcategorias.d_subcategoria_s`, `subcategorias`.`subca_signo_desc` AS `subcategorias.subca_signo_desc`, `subcategorias`.`subca_signo_obs` AS `subcategorias.subca_signo_obs`, `clases`.`cf_id_categoria_s` AS `clases.cf_id_categoria_s`, `clases`.`cf_id_subcategoria_s` AS `clases.cf_id_subcategoria_s`, `clases`.`cf_id_clase_s` AS `clases.cf_id_clase_s`, `clases`.`cf_uid` AS `clases.cf_uid`, `clases`.`cf_created` AS `clases.cf_created`, `clases`.`cf_modified` AS `clases.cf_modified`, `clases`.`cf_created_by` AS `clases.cf_created_by`, `clases`.`cf_modified_by` AS `clases.cf_modified_by`, `clases`.`cf_ipaddress` AS `clases.cf_ipaddress`, `clases`.`cf_user_id` AS `clases.cf_user_id`, `clases`.`d_clase_s` AS `clases.d_clase_s`, `clases`.`c_signo_desc` AS `clases.c_signo_desc`, `clases`.`c_signo_obs` AS `clases.c_signo_obs`, `tipos`.`cf_id_categoria_s` AS `tipos.cf_id_categoria_s`, `tipos`.`cf_id_subcategoria_s` AS `tipos.cf_id_subcategoria_s`, `tipos`.`cf_id_clase_s` AS `tipos.cf_id_clase_s`, `tipos`.`cf_id_tipo_s` AS `tipos.cf_id_tipo_s`, `tipos`.`cf_uid` AS `tipos.cf_uid`, `tipos`.`cf_created` AS `tipos.cf_created`, `tipos`.`cf_modified` AS `tipos.cf_modified`, `tipos`.`cf_created_by` AS `tipos.cf_created_by`, `tipos`.`cf_modified_by` AS `tipos.cf_modified_by`, `tipos`.`cf_ipaddress` AS `tipos.cf_ipaddress`, `tipos`.`cf_user_id` AS `tipos.cf_user_id`, `tipos`.`d_tipo_s` AS `tipos.d_tipo_s`, `tipos`.`t_signo_desc` AS `tipos.t_signo_desc`, `tipos`.`t_signo_obs` AS `tipos.t_signo_obs`, `subtipos`.`cf_id_categoria_s` AS `subtipos.cf_id_categoria_s`, `subtipos`.`cf_id_subcategoria_s` AS `subtipos.cf_id_subcategoria_s`, `subtipos`.`cf_id_clase_s` AS `subtipos.cf_id_clase_s`, `subtipos`.`cf_id_tipo_s` AS `subtipos.cf_id_tipo_s`, `subtipos`.`cf_id_subtipo_s` AS `subtipos.cf_id_subtipo_s`, `subtipos`.`cf_uid` AS `subtipos.cf_uid`, `subtipos`.`cf_created` AS `subtipos.cf_created`, `subtipos`.`cf_modified` AS `subtipos.cf_modified`, `subtipos`.`cf_created_by` AS `subtipos.cf_created_by`, `subtipos`.`cf_modified_by` AS `subtipos.cf_modified_by`, `subtipos`.`cf_ipaddress` AS `subtipos.cf_ipaddress`, `subtipos`.`cf_user_id` AS `subtipos.cf_user_id`, `subtipos`.`d_subtipo_s` AS `subtipos.d_subtipo_s`, `subtipos`.`st_signo_desc` AS `subtipos.st_signo_desc`, `subtipos`.`st_signo_obs` AS `subtipos.st_signo_obs`, `totedificio`.`total` AS `totedificio.total`, `totedificio`.`cf_id_ficha` AS `totedificio.cf_id_ficha`, `totedificio`.`signos_tot_pos` AS `totedificio.signos_tot_pos`, `totedificio`.`signos_porcentaje_pos` AS `totedificio.signos_porcentaje_pos`, `totedificio`.`signos_tot_edificio` AS `totedificio.signos_tot_edificio`, `totedificio`.`signos_porcentaje_tot` AS `totedificio.signos_porcentaje_tot`, `totedificio`.`cf_id_categoria_s` AS `totedificio.cf_id_categoria_s`, `totedificio`.`d_categoria_s` AS `totedificio.d_categoria_s`, `totedificio`.`cf_id_subcategoria_s` AS `totedificio.cf_id_subcategoria_s`, `totedificio`.`d_subcategoria_s` AS `totedificio.d_subcategoria_s`, `totedificio`.`cf_id_clase_s` AS `totedificio.cf_id_clase_s`, `totedificio`.`d_clase_s` AS `totedificio.d_clase_s`, `totedificio`.`cf_id_tipo_s` AS `totedificio.cf_id_tipo_s`, `totedificio`.`d_tipo_s` AS `totedificio.d_tipo_s`, `totedificio`.`cf_id_subtipo_s` AS `totedificio.cf_id_subtipo_s`, `totedificio`.`d_subtipo_s` AS `totedificio.d_subtipo_s`, `totedificio`.`cf_id_forma_s` AS `totedificio.cf_id_forma_s`, `totedificio`.`d_forma_s` AS `totedificio.d_forma_s`, `totedificio`.`cf_id_edificio` AS `totedificio.cf_id_edificio`, `totedificio`.`d_edificio` AS `totedificio.d_edificio`, `formas`.`cf_id_categoria_s` AS `formas.cf_id_categoria_s`, `formas`.`cf_id_subcategoria_s` AS `formas.cf_id_subcategoria_s`, `formas`.`cf_id_clase_s` AS `formas.cf_id_clase_s`, `formas`.`cf_id_tipo_s` AS `formas.cf_id_tipo_s`, `formas`.`cf_id_subtipo_s` AS `formas.cf_id_subtipo_s`, `formas`.`cf_id_forma_s` AS `formas.cf_id_forma_s`, `formas`.`cf_uid` AS `formas.cf_uid`, `formas`.`cf_created` AS `formas.cf_created`, `formas`.`cf_modified` AS `formas.cf_modified`, `formas`.`cf_created_by` AS `formas.cf_created_by`, `formas`.`cf_modified_by` AS `formas.cf_modified_by`, `formas`.`cf_ipaddress` AS `formas.cf_ipaddress`, `formas`.`cf_user_id` AS `formas.cf_user_id`, `formas`.`d_forma_s` AS `formas.d_forma_s`, `formas`.`f_signo_desc` AS `formas.f_signo_desc`, `formas`.`f_signo_obs` AS `formas.f_signo_obs`, `edificio`.`cf_id_edificio` AS `edificio.cf_id_edificio`, `edificio`.`cf_uid` AS `edificio.cf_uid`, `edificio`.`cf_created` AS `edificio.cf_created`, `edificio`.`cf_modified` AS `edificio.cf_modified`, `edificio`.`cf_created_by` AS `edificio.cf_created_by`, `edificio`.`cf_modified_by` AS `edificio.cf_modified_by`, `edificio`.`cf_ipaddress` AS `edificio.cf_ipaddress`, `edificio`.`cf_user_id` AS `edificio.cf_user_id`, `edificio`.`id_pais` AS `edificio.id_pais`, `edificio`.`cf_id_comunidad` AS `edificio.cf_id_comunidad`, `edificio`.`cf_id_provincia` AS `edificio.cf_id_provincia`, `edificio`.`cf_id_poblacion` AS `edificio.cf_id_poblacion`, `edificio`.`pg_alias` AS `edificio.pg_alias`, `edificio`.`pg_alias_ant` AS `edificio.pg_alias_ant`, `edificio`.`d_edificio` AS `edificio.d_edificio`, `edificio`.`cf_id_clase_e` AS `edificio.cf_id_clase_e`, `edificio`.`cf_id_tipo_e` AS `edificio.cf_id_tipo_e`, `edificio`.`cf_id_estilo_e` AS `edificio.cf_id_estilo_e`, `edificio`.`f_ini_e` AS `edificio.f_ini_e`, `edificio`.`f_fin_e` AS `edificio.f_fin_e`, `edificio`.`f_mod_e` AS `edificio.f_mod_e`, `edificio`.`lat_edificio` AS `edificio.lat_edificio`, `edificio`.`lon_edificio` AS `edificio.lon_edificio`, `edificio`.`c_edificio` AS `edificio.c_edificio`, `edificio`.`e_remodelaciones` AS `edificio.e_remodelaciones`, `edificio`.`e_observaciones` AS `edificio.e_observaciones`, `edificio`.`enlace1` AS `edificio.enlace1`, `edificio`.`enlace2` AS `edificio.enlace2`, `edificio`.`enlace3` AS `edificio.enlace3`, `edificio`.`enlace4` AS `edificio.enlace4`, `edificio`.`e_municipio` AS `edificio.e_municipio`, `edificio`.`e_patronaje` AS `edificio.e_patronaje`, `edificio`.`e_advocacion` AS `edificio.e_advocacion`, `edificio`.`e_localizacion` AS `edificio.e_localizacion`, `edificio`.`e_cronologia` AS `edificio.e_cronologia`, `edificio`.`e_toponimia` AS `edificio.e_toponimia`, `edificio`.`e_planimetria` AS `edificio.e_planimetria`, `edificio`.`e_visitas` AS `edificio.e_visitas`, `edificio`.`e_leyendas` AS `edificio.e_leyendas`, `edificio`.`e_bibliografia` AS `edificio.e_bibliografia`, `edificio`.`e_totales` AS `edificio.e_totales`, `edificio`.`articulos` AS `edificio.articulos`, `poblacion`.`cf_id_poblacion` AS `poblacion.cf_id_poblacion`, `poblacion`.`id_pais` AS `poblacion.id_pais`, `poblacion`.`cf_uid` AS `poblacion.cf_uid`, `poblacion`.`cf_created` AS `poblacion.cf_created`, `poblacion`.`cf_modified` AS `poblacion.cf_modified`, `poblacion`.`cf_created_by` AS `poblacion.cf_created_by`, `poblacion`.`cf_modified_by` AS `poblacion.cf_modified_by`, `poblacion`.`cf_ipaddress` AS `poblacion.cf_ipaddress`, `poblacion`.`cf_user_id` AS `poblacion.cf_user_id`, `poblacion`.`cf_id_comunidad` AS `poblacion.cf_id_comunidad`, `poblacion`.`cf_id_provincia` AS `poblacion.cf_id_provincia`, `poblacion`.`d_poblacion` AS `poblacion.d_poblacion`, `poblacion`.`d_poblacion_obs` AS `poblacion.d_poblacion_obs`, `provincia`.`cf_id_provincia` AS `provincia.cf_id_provincia`, `provincia`.`id_pais` AS `provincia.id_pais`, `provincia`.`cf_uid` AS `provincia.cf_uid`, `provincia`.`cf_created` AS `provincia.cf_created`, `provincia`.`cf_modified` AS `provincia.cf_modified`, `provincia`.`cf_created_by` AS `provincia.cf_created_by`, `provincia`.`cf_modified_by` AS `provincia.cf_modified_by`, `provincia`.`cf_ipaddress` AS `provincia.cf_ipaddress`, `provincia`.`cf_user_id` AS `provincia.cf_user_id`, `provincia`.`cf_id_comunidad` AS `provincia.cf_id_comunidad`, `provincia`.`d_provincia` AS `provincia.d_provincia`, `provincia`.`escudo` AS `provincia.escudo`, `pais`.`id_pais` AS `pais.id_pais`, `pais`.`d_pais` AS `pais.d_pais`, `edtipo`.`cf_id_tipo_e` AS `edtipo.cf_id_tipo_e`, `edtipo`.`cf_uid` AS `edtipo.cf_uid`, `edtipo`.`cf_created` AS `edtipo.cf_created`, `edtipo`.`cf_modified` AS `edtipo.cf_modified`, `edtipo`.`cf_created_by` AS `edtipo.cf_created_by`, `edtipo`.`cf_modified_by` AS `edtipo.cf_modified_by`, `edtipo`.`cf_ipaddress` AS `edtipo.cf_ipaddress`, `edtipo`.`cf_user_id` AS `edtipo.cf_user_id`, `edtipo`.`cf_id_clase_e` AS `edtipo.cf_id_clase_e`, `edtipo`.`t_edificio_desc` AS `edtipo.t_edificio_desc`, `edtipo`.`t_edificio_obs` AS `edtipo.t_edificio_obs` FROM `jos_acm_ficha_subtipos` AS `analisisformal` INNER JOIN `jos_acm_ficha_categorias` AS `categorias` ON categorias.cf_id_categoria_s=analisisformal.cf_id_categoria_s INNER JOIN `jos_acm_ficha_subcategorias` AS `subcategorias` ON subcategorias.cf_id_subcategoria_s=analisisformal.cf_id_subcategoria_s INNER JOIN `jos_acm_ficha_clases` AS `clases` ON clases.cf_id_clase_s=analisisformal.cf_id_clase_s INNER JOIN `jos_acm_ficha_tipos` AS `tipos` ON tipos.cf_id_tipo_s=analisisformal.cf_id_tipo_s INNER JOIN `jos_acm_ficha_subtipos` AS `subtipos` ON subtipos.cf_id_subtipo_s=analisisformal.cf_id_subtipo_s INNER JOIN `jos_acm_v_fichas_total_formales` AS `totedificio` ON totedificio.cf_id_subtipo_s = analisisformal.cf_id_subtipo_s LEFT JOIN `jos_acm_ficha_formas` AS `formas` ON formas.cf_id_forma_s=totedificio.cf_id_forma_s INNER JOIN `jos_acm_edificios` AS `edificio` ON edificio.cf_id_edificio=totedificio.cf_id_edificio INNER JOIN `jos_acm_poblaciones` AS `poblacion` ON poblacion.cf_id_poblacion=edificio.cf_id_poblacion INNER JOIN `jos_acm_provincias` AS `provincia` ON provincia.cf_id_provincia=edificio.cf_id_provincia INNER JOIN `jos_acm_paises` AS `pais` ON pais.id_pais=edificio.id_pais INNER JOIN `jos_acm_edificio_tipos` AS `edtipo` ON edtipo.cf_id_tipo_e=edificio.cf_id_tipo_e ORDER BY `analisisformal`.`total` ASC, `pais`.`id_pais`, `provincia`.`d_provincia`, `poblacion`.`d_poblacion`, `analisisformal`.`cf_id_subcategoria_s`, `subcategorias`.`d_subcategoria_s`, `analisisformal`.`cf_id_clase_s`, `clases`.`d_clase_s`, `analisisformal`.`cf_id_tipo_s`, `tipos`.`d_tipo_s`, `analisisformal`.`cf_id_subtipo_s`, `subtipos`.`d_subtipo_s`, `formas`.`d_forma_s` LIMIT 600,100
Provincia Población Construcción Tipo # Subcategoría # Clase # Tipo # Subtipo # Forma Total