Rsa97

SELECT `b`.`*`, `i`.`count`
  FROM (
    SELECT `ib`.`id_brand` AS `brand`,  COUNT(*) AS `count` 
      FROM `item_brand` AS `ib`
      JOIN `item` AS `i` ON `i`.`enabled` = 1 
        AND `i`.`id_category` IN (21,317,318) 
        AND `i`.`id` = `ib`.`id_item`
      GROUP BY `ib`.`id_brand`
  ) AS `i`
  JOIN `brand` AS `b` ON `b`.`id` = `i`.`id_brand`
  ORDER BY `i`.`count` DESC

for (power = 128; power > 0; power >>= 1)
  printf((denary & power ? "1" : "0");

SELECT to_char(c.date, 'YYYY-MM-dd HH24:MI:ss') as day,
       c.title, c.email, c.price, c.pages
  FROM (
    SELECT MIN(date) AS date, email FROM customer GROUP BY email
  ) AS t
  JOIN customer AS c ON c.date = t.date AND c.email = d.email