Formación
Database error: SQL No Valido: SELECT
txt_clave AS clave,
txt_idioma_key AS idioma,
idioma_nombre AS idioma_nombre,
idioma_pre AS idioma_pre,
CASE WHEN txt_titulo = '' THEN ifnull(txt_id,'Sin Titulo') ELSE txt_titulo END AS titulo,
txt_subtitulo AS subtitulo,
txt_resumen AS resumen,
txt_texto AS texto,
txt_firma AS firma,
txt_estado AS estado,
txt_galeria AS galeria,
txt_inscripcion AS inscripcion,
txt_comentar AS comentar,
DATE_FORMAT(txt_fecha,'%d/%m/%Y %H:%i') AS fecha,
DATE_FORMAT(txt_fin,'%d/%m/%Y %H:%i') AS fin,
txt_tt_key AS tipo,
tt_nombre AS tipo_nombre,
tt_icono AS icono,
tt_georeferenciar AS tipo_geo,
tt_ver AS tipo_ver, ( SELECT COUNT(sub_clave) FROM td_cat_subcategoria INNER JOIN tc_subcategorias ON sub_clave = sc_sub_key AND sub_tipo = 'texto' WHERE sc_clave = txt_clave ) AS subcategorias, tt_subcategorias AS tipo_tiene_subcat,
txt_id AS id,
DATE_FORMAT(txt_fecha_grab,'%d/%m/%Y %H:%i') AS grabado,
DATE_FORMAT(txt_fecha_mod, '%d/%m/%Y %H:%i') AS modificado,
txt_usu_key AS usuario,
txt_enc_key AS encuesta,
txt_relacionadas AS relacionadas,
tt_comportamiento AS comportamiento,
pro_nombre AS provincia,
mun_nombre AS municipio,
geo_id AS geolocalizado,
X(geo_pt) AS lat,
Y(geo_pt) AS lng
FROM t_textos
INNER JOIN tc_tipo_texto ON tt_clave=txt_tt_key
INNER JOIN tc_idiomas ON idioma_clave=txt_idioma_key LEFT JOIN geo_links ON geo_key = txt_clave AND geo_tipo = 'texto'
LEFT JOIN ts_pais ON pais_clave = geo_pais_key
LEFT JOIN ts_provincias ON pro_clave = geo_pro_key AND pro_pais_key=pais_clave
LEFT JOIN ts_municipios ON mun_clave = geo_mun_key AND mun_pro_key = pro_clave WHERE txt_estado IN ( 'publicado' ) AND txt_tt_key<>1 AND txt_tt_key = 5 AND DATEDIFF(IFNULL(txt_fin,txt_fecha),'2013-05-21')<=0 ORDER BY txt_fecha DESC LIMIT 0 , 10
MySQL Error: 1146 (Table 'qin401.geo_links' doesn't exist)
Sesion Parada.