const defaultOrder = (a, b) => a < b ? -1 : a > b ? 1 : 0
const qSort = (arr, order = defaultOrder) => {
if (arr.length < 2) {
return arr;
}
const pivot = arr[Math.floor(arr.length * Math.random())]
const less = arr.filter(a => order(a, pivot) < 0)
const equal = arr.filter(a => order(a, pivot) === 0)
const greater = arr.filter(a => order(a, pivot) > 0)
return qSort(less, order).concat(equal).concat(qSort(greater, order))
}const qSort = (arr) => {
if (arr.length < 2) {
return arr;
}
const fund = arr[Math.floor(arr.length / 2)]
let less = []
let equal = []
let greater = []
for (let i = 0; i < 0; i += 1) {
if (arr[i] < fund) {
less.push(arr[i])
}
if (arr[i] === fund) {
equal.push(arr[i])
}
if (arr[i] > fund) {
greater.push(arr[i])
}
}
return qSort(less) + equal + qSort(greater)
}SELECT *
FROM `t1`
JOIN `t2` ON `t2`.`client` = `t1`.`id`
AND `t2`.`tiimestamp` BETWEEN `t1`.`session_start` AND `t1`.`session_end`$image_name = preg_replace("/_int-?\d*$/", "", $image_name, -1, $count);$str ='[{"3":5},{"1":2}]';
$arr = json_decode($str, true);
$result = array_map(
function ($el) {
return array_keys($el)[0];
},
$arr
);
var_dump($result);
// array(2) {
// [0] => int(3)
// [1] => int(1)
// }SELECT *
FROM (
SELECT `id`, MAX(`date`) AS `max_date`
FROM `tab2`
GROUP BY `id`
) AS `max`
JOIN `tab2` ON `tab2`.`id` = `max`.`id`
AND `tab2`.`date` = `max`.`max_date`
JOIN `tab1` ON `tab1_id` = `tab2_id`SELECT *
FROM (
SELECT DISTINCT FIRST_VALUE(`id`) OVER `win` AS `id`,
FIRST_VALUE(`date`) OVER `win` AS `date`,
FIRST_VALUE(`loc`) OVER `win` AS `loc`
FROM `tab2`
WINDOW `win` AS (PARTITION BY `id` ORDER BY `date` DESC)
) AS `t2`
JOIN `tab1` ON `tab1`.`id` = `t2`.`id`SELECT COUNT(*) + 1 AS `position`
FROM `users`
WHERE `balance` > (
SELECT `balance`
FROM `users`
WHERE id = :userId
)If a typed property does not have a default value, no implicit null default value is implied (even if the property is nullable). Instead, the property is considered to be uninitialized. Reads from uninitialized properties will generate a TypeErrorhttps://wiki.php.net/rfc/typed_properties_v2#unini...