nerestaren

SELECT DATE_FORMAT(FROM_UNIXTIME(post_time), '%d/%m/%Y %T'), username, forum_name, topic_title, (
	SELECT COUNT(topic_id)
    FROM posts as b
    WHERE topic_id = posts.topic_id AND post_time <= posts.post_time
), CAST(CONCAT('https://tadaima.cat/topic', posts.topic_id, '.html#p', posts.post_id) AS CHAR) AS url
FROM posts
LEFT JOIN users on poster_id = user_id
LEFT JOIN topics on posts.topic_id = topics.topic_id
LEFT JOIN forums on topics.forum_id = forums.forum_id
WHERE posts.forum_id IN (39, 40, 41, 42)

nerestaren

function filtra(tipus, criteri) {
        var valor = filtre[tipus][criteri].val;
        if (criteri == 'Tot') {
            Object.keys(filtre[tipus]).forEach(function(c) {
                if (filtre[tipus][c].val == valor) {
                    filtre[tipus][c].val = !valor;
                    $(filtre[tipus][c].btn).toggleClass('off', !filtre[tipus][c].val); 
                }
            });
        } else {

nerestaren

SELECT username,
  user_posts AS sempre,
  (SELECT COUNT(post_id) FROM posts WHERE poster_id = user_id AND post_time < UNIX_TIMESTAMP() - 7776000) AS 'des de fa més de tres mesos', 
  (SELECT COUNT(post_id) FROM posts WHERE poster_id = user_id AND post_time BETWEEN UNIX_TIMESTAMP() - 7776000 AND UNIX_TIMESTAMP() - 5184000) AS 'des de fa tres mesos fins fa dos', 
  (SELECT COUNT(post_id) FROM posts WHERE poster_id = user_id AND post_time BETWEEN UNIX_TIMESTAMP() - 5184000 AND UNIX_TIMESTAMP() - 2592000) AS 'des de fa dos mesos fins fa un', 
  (SELECT COUNT(post_id) FROM posts WHERE poster_id = user_id AND post_time >= UNIX_TIMESTAMP() - 2592000) AS 'des de fa un mes fins avui',
  (SELECT pf_padri FROM profile_fields_data WHERE profile_fields_data.user_id = users.user_id) AS 'padri' 
FROM users WHERE user_posts > 0