SELECT *
FROM `shop` AS `s1`
LEFT JOIN `shop` AS `s2` ON `s1`.`price` < `s2`.`price`SELECT *
FROM `shop`
ORDER BY `price` DESC
LIMIT 1WITH `cte` AS (
SELECT *,
ROW_NUMBER() OVER (
PARTITION BY `contact_id` ORDER BY `created_at` DESC
) AS `row`
FROM `contacts_history`
WHERE `created_at` BETWEEN '2021-02-05 15:56:57' AND '2021-02-20 13:44:09'
) SELECT *
FROM `cte`
WHERE `status_id` = 37
AND `row` = 1function round45(value) {
return Math.round(value / 45) * 45;
}
round45(90.3222341); // 90
round45(136.99); // 135
round45(358); // 360
round45(46); // 45data_issued + 10 < curdate()`date_issued` < CURDATE() - INTERVAL 10 DAY
let diff = (new Date('01 Dec 2022') - new Date()) / 1000;
const seconds = diff % 60;
diff = (diff - seconds) / 60;
const minutes = diff % 60;
diff = (diff - minutes) / 60;
const hours = diff % 24;
const days = (diff - hours) / 24;
console.log(days, hours, minutes, seconds);
// 587 6 30 21.51799999922514document
.getElementsByTagName('iframe')[0]
.contentWindow
.document
.getElementsByTagName('iframe')[0]
.contentWindow
.document
.getElementsByClassName('it_this')[0]