SELECT `u`.`name`, `t`.`sum`
FROM (
SELECT `o`.`user_id` AS `user_id`, SUM(`r`.`sum`) AS `sum`
FROM `rabota` AS `r`
JOIN `object` AS `o` ON `o`.`id` = `r`.`ubject_id`
GROUP BY `o`.`user_id`
ORDER BY `sum` DESC
LIMIT 1
) AS `t`
JOIN `user` AS `u` ON `u`.`id` = `t`.`user_id`A microtask is a colloquial way of referring to a task that was created via the queue a microtask algorithm.
document.querySelector('.foo'); // null
document.querySelector('.foo').classList;
// Uncaught TypeError: document.querySelector(...) is null
document.querySelector('.foo')?.classList; // undefined
document.querySelector('.foo').classList.add('active');
// Uncaught TypeError: document.querySelector(...) is null
document.querySelector('.foo')?.classList?.add('active'); // undefinedfunction toAlphabet($value, $alphabet) {
$result = '';
$base = count($alphabet);
do {
$result = $alphabet[$value % $base] . $result;
$value = intdiv($value, $base);
} while ($value > 0);
return $result;
}
function gen($minLength, $maxLength, $alphabet) {
$maxVal = count($alphabet) ** $maxLength;
for ($i = 0; $i < $maxVal; $i += 1) {
yield str_pad(toAlphabet($i, $alphabet), $minLength, $alphabet[0], STR_PAD_LEFT);
}
}
foreach (gen(2, 3, ['x', 'y', 'z']) as $val) {
print "{$val}\n";
}
/*
xx
xy
xz
yx
yy
yz
zx
zy
zz
yxx
yxy
yxz
yyx
yyy
yyz
yzx
yzy
yzz
zxx
zxy
zxz
zyx
zyy
zyz
zzx
zzy
zzz
*/