Vitsliputsli

WITH discussion_count AS (
    SELECT count(*) cnt FROM discussion WHERE author_id=?
),
discussion_messages_count AS (
    SELECT count(*) cnt FROM discussion_messages WHERE author_id=?
)
SELECT 
        p.name, dc.cnt discussions, dmc.cnt dcount
    FROM people p, discussion_count dc, discussion_messages_count dmc
    WHERE p.id=?

SELECT
        table1.*
    FROM table1
    LEFT JOIN table2 ON table1.searchArticle=table2.searchArticle AND table1.brand=table2.brand
    WHERE table2.brand is null // здесь лучше указать table2.id

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 1

SELECT * 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