SENT: INSERT INTO bloglecturanotas (id_tema, fechalectura) VALUES (elinmobiliario, now('')) 1054 - Unknown column 'elinmobiliario' in 'field list'SENT: SELECT t.*, UNIX_TIMESTAMP(t.fechaalta)fechaa, UNIX_TIMESTAMP(t.fechamodif)fecham, t.nombre nomtema, t.id_multimedia multi, (select count(*) from bloglecturanotas l where t.id_tema = l.id_tema) leidas, s.nombre nomcategoria, (select count(*) from blogcomentario c where t.id_tema = c.id_tema AND c.eliminado = 'No') coments, (select link from blogvideos vi where vi.id_tema = t.id_tema AND vi.principal = 'Si' AND vi.eliminado = 'No' limit 1) nomvideo, (select fo.nombre from blogfotos fo where fo.id_tema = t.id_tema AND fo.eliminado ='No' AND fo.principal = 'Si' limit 1) nomfoto FROM blogtemas t LEFT JOIN blogcategoria s ON s.id_blogcategoria = t.id_blogcategoria WHERE t.eliminado = 'No' AND t.online AND t.id_tema = elinmobiliario GROUP BY t.id_tema ORDER BY t.orden DESC 1054 - Unknown column 'elinmobiliario' in 'where clause' |