Error
  • Unknown column 'analisisformal.d_forma_s' 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`.`total_catalogo` AS `totedificio.total_catalogo`, `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`, `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` 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_signos_total_tipos` 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 ORDER BY `analisisformal`.`d_forma_s` ASC, `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 0,100
# Subcategoría # Clase # Tipo # Subtipo # Forma Total