Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {exp:query sql="SELECT c.entry_id, c.comment_date, COUNT(c.entry_id) AS comment_count, t.url_title AS url_titel, t.title FROM exp_comments c, exp_channel_titles t WHERE c.entry_id = t.entry_id AND UNIX_TIMESTAMP() - c.comment_date <= (114*24*60*60) GROUP BY c.entry_id ORDER BY comment_count DESC, c.comment_date DESC LIMIT 10"}
- gets to
- {exp:query sql="SELECT c.entry_id, c.comment_date, COUNT(c.entry_id) AS comment_count, t.url_title AS url_titel, t.title FROM exp_comments c, exp_channel_titles t WHERE c.entry_id = t.entry_id AND UNIX_TIMESTAMP() - c.comment_date <= (114*24*60*60) GROUP BY c.entry_id ORDER BY comment_count DESC, c.comment_date DESC LIMIT 10"}
- The problem is the "<" (<)
Add Comment
Please, Sign In to add comment