Database error: SQL No Valido: SELECT DISTINCT DOC_clave AS clave, DOC_idioma_key AS idioma, idioma_nombre AS idioma_nombre, idioma_pre AS idioma_pre, CASE WHEN DOC_nombre ='' THEN 'Sin Nombre' ELSE DOC_nombre END AS nombre, DOC_ruta AS ruta, mm_clave AS tipo, mm_nombre AS tipo_nombre, DOC_alt AS alt, DOC_resumen AS resumen, DOC_estado AS estado, DOC_td_key AS categoria, td_nombre AS categoria_nombre, td_en_mapa AS geolocalizar, td_ruta AS ruta_tipo, geo_id AS geolocalizado, mm_mime AS mime, mm_extension AS extension, mm_icono AS icono, mm_tipo AS mime_tipo, DOC_protegido AS protegido, DOC_usu_key AS usuario, DOC_fecha_grab AS fecha_grabacion, DATE_FORMAT(DOC_fecha,'%d/%m/%Y') AS fecha, CONCAT( '' , ifnull(DOC_ruta,'') , ifnull(DOC_clave,'') , '.' , ifnull(mm_extension,'') ) AS documento, CONCAT( 'http://mancomunidaddonbenitovillanueva.es/' , ifnull(DOC_ruta,'') , ifnull(DOC_clave,'') , '.' , ifnull(mm_extension,'') ) AS documentoabs, CONCAT( ifnull(DOC_ruta,'') , ifnull(DOC_clave,'') , '.' , ifnull(mm_extension,'') ) AS documento_sin_ruta, CONCAT( '' , ifnull(DOC_ruta,'') , 'thumbnails/' , 'tn_' , ifnull(DOC_clave,'') , '.', MM_extension ) AS thumbnail, CONCAT( 'http://mancomunidaddonbenitovillanueva.es/' , ifnull(DOC_ruta,'') , 'thumbnails/' , 'tn_' , ifnull(DOC_clave,'') , '.', MM_extension ) AS thumbnailabs, CONCAT( ifnull(DOC_ruta,'') , 'thumbnails/' , 'tn_' , ifnull(DOC_clave,'') , '.jpg' ) AS thumbnail_sin_ruta, sub_clave AS subcategoria_clave, CASE WHEN sub_clave IS NULL THEN '' ELSE sub_nombre END AS subcategoria, CASE WHEN rd_DOC_key > 0 THEN 1 ELSE 0 END AS relacionados, CASE WHEN DOC_mm_key IN (1,2,9,10,11) THEN 1 ELSE 0 END AS multimedia, CASE WHEN DOC_estado = 1 THEN 'Alta' ELSE 'Baja' END AS estado_nombre FROM t_documentos INNER JOIN mime ON mm_clave = DOC_mm_key INNER JOIN tc_tipo_documento ON td_clave = DOC_td_key INNER JOIN idiomas ON idioma_clave=DOC_idioma_key LEFT JOIN td_rel_doc ON rd_DOC_key = DOC_clave LEFT JOIN td_cat_subcategoria ON sc_clave = DOC_clave LEFT JOIN tc_subcategorias ON sub_clave = sc_sub_key AND sub_tipo = 'documento' AND SUB_idioma_key = DOC_idioma_key LEFT JOIN geo_links ON geo_key = DOC_clave AND geo_tipo = 'Documento' WHERE DOC_estado IN (1) AND DOC_td_key = 16
MySQL Error: 1146 (Table 'qyd717.geo_links' doesn't exist)
Sesion Parada.