function format($size,$prefix=0){
if (is_numeric($size) && $size>=1000 && $prefix<8) {
$size = format(floor($size/1000),$prefix+1);
return $size;
} else {
$prefixName = ["B","KB","MB","GB","TB","PB","EB","ZB","YB"];
return $size . $prefixName[$prefix];
}
}SELECT rate, type, route_id, weight, volume FROM (
SELECT rate, type, route_id, weight, volume,
CASE WHEN rs.volume >= 300 THEN
row_number() OVER (PARTITION BY route_id ORDER BY volume)
ELSE null END r_volume,
CASE WHEN rs.weight >= 50000 THEN
row_number() OVER (PARTITION BY route_id ORDER BY weight)
ELSE null END r_weight
FROM test_rates rs
WHERE
rs.dt_del IS NULL
AND (rs.volume >= 300 OR rs.weight >= 50000)
) WHERE r_volume=1 OR r_weight=1
ORDER BY rate DESC
LIMIT 1SELECT * FROM (
SELECT
table.*,
CASE
WHEN type='video' THEN row_number() OVER (PARTITION BY type ORDER BY create_date) *2
ELSE row_number() OVER (PARTITION BY type ORDER BY create_date) +1
END ord
FROM table
) result ORDER BY ord, type DESC[Trigger]
Operation = Upgrade
Operation = Remove
Type = Package
Target = linux
[Action]
Depends = bash
Depends = find
When = PreTransaction
Exec = /usr/bin/bash -c "/usr/bin/find . -type l -exec test ! -e {} \; -delete; /usr/bin/mkdir -p /tmp/save-running-kernel-modules && /usr/bin/cp -a /usr/lib/modules/$(uname -r) /tmp/save-running-kernel-modules"[Trigger]
Operation = Upgrade
Operation = Remove
Type = Package
Target = linux
[Action]
Depends = bash
When = PostTransaction
Exec = /usr/bin/bash -c "/usr/bin/ln -s /tmp/save-running-kernel-modules/$(uname -r) /usr/lib/modules/$(uname -r)"SELECT
dstnum AS t2dstnum,
MAX(calldate) AS t2lastcall
FROM cdr
WHERE route = "out"
GROUP BY dstnumn:=((x^3)*ln(z)+2*sqr(y)*z)/((abc(x-z)+abc(y-x))^(1/3)+sqr(x)*z)SELECT
customer_id
FROM table
GROUP BY name
HAVING SUM(is_black=0)=0 AND SUM(is_black=1)!=0session optional pam_exec.so quiet /usr/bin/pam_sshWITH news_images AS (
SELECT news.id news_id, min(images.id) images_id FROM news
LEFT JOIN images ON news.id=images.id
GROUP BY news.id
LIMIT 10
)
SELECT news.*,images.*
FROM news_images
JOIN news ON news.id=news_images.news_id
JOIN images ON images.id=news_images.images_idSELECT
CASE WHEN status="В наличии" THEN 1
WHEN status="На заказ" THEN 2
WHEN status="Нет в наличии" THEN 3
ELSE null END sort_id,
*
FROM table