Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Jesus Malverde

(10,274 posts)
Fri May 13, 2016, 01:51 PM May 2016

DU sql

for the curious. I got an error page from a link and it printed out the following sql

SELECT m.*, u.id as u_id, u.g_id, u.pa, u.pb, u.pc, u.pk, u.ua, u.ub, u.uc, u.ug, u.uj, u.username as author, u.num_posts, u.num_votes, u.points, UNIX_TIMESTAMP(m.last_date) as last_date, UNIX_TIMESTAMP(m.mesg_date) as mesg_date, UNIX_TIMESTAMP(m.edit_date) as edit_date, UNIX_TIMESTAMP(u.reg_date) as reg_date FROM 102_mesg_archive as m LEFT JOIN dcuser as u ON m.author_id = u.id WHERE m.id = 1525789

http://www.democraticunderground.com/discuss/duboard.php?az=view_all&address=102x1525789

Latest Discussions»Retired Forums»Website, DB, & Software Developers»DU sql