Rules for MemOC.org
- In order to publish results on MemOC.org, a person has to register. Registration is absolutely free.
- Every member can have only one account registered with her/his email.
- Every member agrees that the results (s)he publishes belong to her/him and are not used by someone else. Violation of this rule leads to temporary or permanent ban for all users sharing the score.
- Every member agrees that at the time, when the result was achieved, (s)he was the owner of the equipment listed with the result, and no one else has any rights to it.
- Publishing fake results will lead to permanent ban for the cheater.
- All results are subject to moderation - any suspicious results should be reported either by using 'report' link on the result summary page, or by posting link to the result at the forum in marked thread.
- Supplying insufficient evidence (for example unclear screenshot) will lead to blocking the result.
- A member can post one result in different categories, provided that the evidence is OK.
- A member can post result achieved with the same memory sticks several times, but they will count separately only if other hardware (CPU or chipset) is different.
Statistics
3Queries:
Time needed:
SELECT d1.id, d1.value as mem_type, ms.id, ms.speed, ms.memory_type, dd1.value AS brand_name, dd2.value AS model_name, u.id AS user_id, u.user_login
FROM memoc_dictionary d1
INNER JOIN memoc_scores ms ON d1.id = ms.memory_type
AND ms.speed = (
SELECT max( ms.speed )
FROM memoc_scores ms2
WHERE ms2.memory_type = ms.memory_type
ORDER BY ms2.posting_date DESC )
AND ms.id = (
SELECT ms3.id
FROM memoc_scores ms3
WHERE ms3.memory_type = ms.memory_type
ORDER BY ms3.speed DESC , ms3.posting_date DESC
LIMIT 1 )
INNER JOIN memoc_sticks s ON ms.sticks_id = s.id
INNER JOIN memoc_dictionary dd1 ON s.brand_id = dd1.id
INNER JOIN memoc_dictionary dd2 ON s.model_id = dd2.id
INNER JOIN memoc_users u ON ms.user_id = u.id
WHERE d1.dict_group = 'mem_type'
ORDER BY d1.value ASC ;
select id, user_login, max(score_count) as score_count from
(select u.id, u.user_login, count(s.id) as score_count from memoc_scores s inner join memoc_users u on s.user_id = u.id
where s.approved = 1
group by u.id, u.user_login) as us
group by id, user_login
limit 0, 4
SELECT s.user_id, u.user_login, count( s.id ) AS score_count
FROM memoc_scores s
INNER JOIN memoc_users u ON s.user_id = u.id
WHERE s.position = 1 and s.approved = 1
GROUP BY s.user_id
LIMIT 0, 5