SharuPoNemnogu

SELECT count(
  CASE WHEN NOT exists(
    SELECT null FROM table t2 WHERE t2.d = t1.d + 1
  ) THEN 1 END
) - 1
FROM table t1;

SELECT count(t1.d) - 1
FROM table t1
LEFT JOIN table t2 ON t2.d = t1.d + 1
WHERE t2.d IS NULL;

SELECT p.author_id, 
       count(IF(pu.post_id IS NULL, 1, NULL))
FROM posts p
INNER JOIN author_user au ON p.author_id = au.author_id
LEFT JOIN post_user pu ON pu.post_id = p.id AND pu.user_id = au.user_id
WHERE au.user_id = :user_id
GROUP BY p.author_id

SELECT l.id, lp.param_id 
FROM lots AS l 
INNER JOIN lots_params AS lp ON l.id = lp.lot_id 
WHERE (lp.param_id = 1 AND lp.param_value = 36) OR
      (lp.param_id = 2 AND lp.param_value = 54)
GROUP BY l.id
HAVING COUNT(lp.param_id) = 2
LIMIT 5

UPDATE table SET maximumOnline = :newValue WHERE id = :id AND maximumOnline < :newValue

SELECT `money` FROM `table`
  WHERE date(`date`) BETWEEN вчера AND сегодня

ALTER TABLE b_file MODIFY COLUMN description VARCHAR(2000) DEFAULT NULL;

UPDATE table
SET alias = TRIM(LEADING CAST(alias AS SIGNED) FROM alias);