Changes between Initial Version and Version 1 of Ticket #11592, comment 8


Ignore:
Timestamp:
Feb 21, 2014, 1:51:14 AM (10 years ago)
Author:
Ryan J Ollos
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #11592, comment 8

    initial v1  
    41412014-02-20 20:40:38,584 Trac[api] DEBUG: SELECT t.id, t.forum, f.name, t.time, t.author, t.subject, t.status FROM topic t LEFT JOIN (SELECT id, name FROM forum) f ON t.forum = f.id WHERE t.time BETWEEN 1390280399 AND 1392958799 ORDER BY time ASC
    42422014-02-20 20:40:38,586 Trac[api] DEBUG: SELECT m.id, m.forum, f.name, m.topic, t.subject, m.time, m.author FROM message m LEFT JOIN (SELECT id, name FROM forum) f ON m.forum = f.id LEFT JOIN (SELECT id, subject FROM topic) t ON m.topic = t.id WHERE time BETWEEN 1390280399 AND 1392958799 ORDER BY time ASC
    43 
    44 
    4543}}}