SHOW:
|
|
- or go back to the newest paste.
1 | - | select * from ( |
1 | + | select |
2 | if(cm.comment_approved = '1' and cm.user_id > 0, cm_u.display_name, ps_u.display_name) as display_name, | |
3 | - | if(com.comment_approved = '1' and com.user_id > 0, com_u.display_name, u.display_name) as display_name, |
3 | + | cm.comment_author, |
4 | - | com.comment_author, |
4 | + | a.title as title, |
5 | - | if(p.post_type = 'reply', t.post_title, p.post_title) as title, |
5 | + | if(cm.comment_approved = '1', cm.comment_ID, pst.ID) as post_id, |
6 | - | if(com.comment_approved = '1', com.comment_ID, p.ID) as post_id, |
6 | + | if(cm.comment_approved = '1', cm.user_id, pst.post_author) as author_id, |
7 | - | if(com.comment_approved = '1', com.user_id, p.post_author) as author_id, |
7 | + | a.max_post_date as post_date, |
8 | - | if(com.comment_approved = '1', unix_timestamp(com.comment_date), unix_timestamp(p.post_date)) as post_date, |
8 | + | if(cm.comment_approved = '1', SUBSTRING(cm.comment_content, 1, 200), SUBSTRING(pst.post_content, 1, 200)) as content, |
9 | - | if(com.comment_approved = '1', SUBSTRING(com.comment_content, 1, 200), SUBSTRING(p.post_content, 1, 200)) as content, |
9 | + | if(cm.comment_approved = '1', 'comment', pst.post_type) as type, |
10 | - | if(com.comment_approved = '1', 'comment', p.post_type) as type, |
10 | + | if(pst.post_type = 'reply', ifnull(pst.post_parent,0), pst.ID) as post_parent |
11 | - | if(p.post_type = 'reply', ifnull(p.post_parent,0), p.ID) as post_parent, |
11 | + | from ( |
12 | - | max(post_date) as max_post_date |
12 | + | |
13 | if(p.post_type = 'reply', t.post_title, p.post_title) as title, | |
14 | - | LEFT JOIN `wp_users` as u on u.ID = p.post_author |
14 | + | |
15 | if(com.comment_approved = '1', unix_timestamp(com.comment_date), unix_timestamp(p.post_date)) as post_date, | |
16 | if(p.post_type = 'reply', ifnull(p.post_parent,0), p.ID) as post_parent, | |
17 | - | LEFT JOIN `wp_users` as com_u on com_u.ID = com.user_id |
17 | + | max(if(com.comment_approved = '1', unix_timestamp(com.comment_date), unix_timestamp(p.post_date))) as max_post_date, |
18 | max(if(com.comment_approved = '1', com.comment_ID, p.ID)) as max_post_id | |
19 | - | AND p.post_status = 'publish' |
19 | + | |
20 | - | AND p.post_content <> '') |
20 | + | |
21 | - | OR com.comment_approved = '1' |
21 | + | |
22 | - | GROUP BY post_parent) |
22 | + | |
23 | - | ORDER BY max_post_date DESC |
23 | + | AND p.post_status = 'publish' |
24 | - | LIMIT 0,12 |
24 | + | AND p.post_content <> '') |
25 | OR com.comment_approved = '1' | |
26 | group by post_parent) a | |
27 | LEFT JOIN `wp_posts` as pst on a.max_post_id = pst.id | |
28 | LEFT JOIN `wp_comments` as cm on a.max_post_id = cm.comment_post_ID | |
29 | LEFT JOIN `wp_users` as cm_u on cm_u.ID = cm.user_id | |
30 | LEFT JOIN `wp_users` as ps_u on ps_u.ID = pst.post_author | |
31 | order by max_post_date desc | |
32 | limit 0,12 |