SO #42033575, MySQL

Language: Layout:

DROP TABLE IF EXISTS `behaviour`;
CREATE TABLE `behaviour` (page INT, poso INT, diff INT, timestamp TIMESTAMP);

INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (1, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (2, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (3, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (4, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (5, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (6, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (7, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (8, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (9, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (10, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (11, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (12, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (13, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (14, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (15, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (16, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (17, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (18, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (19, 1, 1, CURDATE());
INSERT INTO `behaviour` (page, poso, diff, timestamp)
VALUES (20, 1, 1, CURDATE());

SELECT page,
           poso,
           diff
    FROM    (
        SELECT *,
               @counter := @counter + 1 AS counter
        FROM   (select @counter:=0) AS initvar, 
               (SELECT page, 
                       Count(*) AS poso, 
                       ( Sum(Date(timestamp) = Curdate()) - Sum( 
                         Date(timestamp) = Date_sub(Curdate(), 
                                           INTERVAL 1 day)) ) 
                                diff
                FROM   `behaviour` 
                WHERE  Date(timestamp) >= Date_sub(Curdate(), INTERVAL 1 day) 
                GROUP  BY page 
                ORDER  BY ( Sum(Date(timestamp) = Curdate()) - Sum( 
                            Date(timestamp) = Date_sub(Curdate(), 
                                       INTERVAL 1 day)) 
                          ) DESC) AS u
    ) AS v
    WHERE counter <= 10/100 * @counter
    ORDER  BY diff DESC;


absolute service time: 0,39 sec