Guest User

Untitled

a guest
Oct 17th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. {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"}
  2.  
  3. gets to
  4.  
  5.  
  6.  
  7. {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"}
  8.  
  9. The problem is the "<" (<)
Add Comment
Please, Sign In to add comment