Top Users
Users from 41 to 50 of 1467
| Member | Subjects | Items | Comments | Profile views |
|---|
MySQL ERROR: (1317) Query execution was interrupted
QUERY: SELECT m.`id`, m.`login`, m.`profile_views`, COUNT(DISTINCT c.`id`) AS `cmt_count`, COUNT(DISTINCT s.`id`) AS `subj_count`, COUNT(DISTINCT i.`id`) AS `item_count`, COUNT(DISTINCT u.`id`) AS `scmt_count` FROM `t10_member` m LEFT JOIN `t10_comment` AS c ON m.`id` = c.`member_id` LEFT JOIN `t10_subject` AS s ON m.`id` = s.`member_id` LEFT JOIN `t10_subject_comment` AS u ON m.`id` = u.`member_id` LEFT JOIN `t10_subject_item` AS i ON m.`id` = i.`member_id` WHERE m.`login` LIKE '%' GROUP BY m.`id` ORDER BY `subj_count` DESC LIMIT 40, 10