Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Time: 101026 9:56:40
- # User@Host: jizztag[jizztag] @ theplanet.com [216.40.221.50]
- # Query_time: 12.310083 Lock_time: 0.000210 Rows_sent: 528 Rows_examined: 1044443
- SET timestamp=1288105000;
- SELECT tags.*, COUNT(*) AS count FROM `tags` LEFT OUTER JOIN taggings ON tags.id = taggings.tag_id AND taggings.context = 'tags' INNER JOIN videos ON videos.id = taggings.taggable_id WHERE (taggings.taggable_type = 'Video') AND (taggings.taggable_id IN(SELECT videos.id FROM `videos` JOIN taggings videos_taggings_hardcore_365 ON videos_taggings_hardcore_365.taggable_id = videos.id AND videos_taggings_hardcore_365.taggable_type = 'Video' AND videos_taggings_hardcore_365.tag_id = 32 JOIN taggings videos_taggings_fucking_904 ON videos_taggings_fucking_904.taggable_id = videos.id AND videos_taggings_fucking_904.taggable_type = 'Video' AND videos_taggings_fucking_904.tag_id = 158)) GROUP BY tags.id, tags.name HAVING COUNT(*) > 0 ORDER BY count desc LIMIT 600;
Add Comment
Please, Sign In to add comment