SET @t = 0;
SET @p = 0;
SELECT MIN(`time`) AS `t1`, MAX(`time`) AS `t2`
FROM (
SELECT `time`, @t AS `prev`,
@p := IF(@t+1 = `time`, @p, @p+1) AS `packet`,
@t := `time`
FROM `table`
ORDER BY `time`
) AS `t`
GROUP BY `packet`
ORDER BY `packet`;SELECT `t`.* FROM (
SELECT MAX(`id`) AS `id`
FROM `table`
GROUP BY `pole1`, `pole2`
) AS `i`
JOIN `table` AS `t` ON `t`.`id` = `i`.`id`SELECT `goods`.`article`
FROM `goods`
JOIN `cross` AS `c1` ON `c1`.`goods_id` = `goods`.`id`
AND `c1`.`options_id`='1' AND `c1`.`value`='15кг'
JOIN `cross` AS `c2` ON `c2`.`goods_id` = `goods`.`id`
AND `c2`.`options_id`='4' AND `c2`.`value`='Синий'INSERT INTO `result_table` (...)
SELECT ...
FROM `table1` AS `t1`
JOIN (
SELECT DISTINCT ... FROM `table2`
) AS `t2` ON ...
WHERE ....ALTER TABLE `sellers`
ADD UNIQUE `seller` (`first_name`, `last_name`, `phone`);
INSERT IGNORE INTO `sellers` (`firt_name`, `last_name`, `phone`)
VALUES (:firstName, :lastName, :phone);
SELECT `id` FROM `sellers`
WHERE `first_name` = :firstName
AND `last_name` = :lastName
AND `phone` = :phone;
INSERT INTO `objects` ...