Slava Rozhnev

select 
	portfolio.id, portfolio.name,
	array_agg(json_build_object('src', photos.src, 'src_build', photos.src_build))
from portfolio
left join photos on portfolio.id = photos.portfolio_id
group by portfolio.id, portfolio.name
;

SELECT * FROM ( 
  -- SELECT MOST EXPENSIVE PRODUCT
  SELECT TOP(1) ProdID, Name 
  FROM Product 
  ORDER BY Price DESC 
) ExpensiveProd
JOIN (
  -- CALCULATE SALES BY PRODUCT IN DATE INTERVAL
  SELECT ProdID, SUM(Sum) ProdSales
  FROM Sales 
  WHERE Date BETWEEN '2019-07-01' AND '2019-07-31' GROUP BY ProdID
) ProdSales ON ProdSales.ProdID = ExpensiveProd.ProdID;

$prod = [
 	'x' => new Phone('Iphone X ', '$1500 ', 'Phone ', 'Apple ', 'A9 ', '1024 ', '1 ', '128gb ', 'Ios '),
 	'mon' => new Monitor('Abracadabra ', '$1500 ', 'Monitor ', 'DELL ', '24 ', '144ghz ', 'HDMI '),
  	'mon1' => new Monitor('ROG ', '$1500 ', 'Monitor ', 'ASUS ', '24 ', '144ghz ', 'HDMI ')
];

foreach($prod as $p) $p->show();

$items = [
    'school_table' => [
        'name' => 'School Table',
        'price' => 100
    ],
    'school_chair' => [
        'name' => 'School Chair',
        'price' => 50
    ]
];

$item = $items[ 'school_table'];

echo $item['name'] . ' for ' . $item['price'] . ' money';

$values = ['AF', 'AL'];

$result = array_filter(
	$countries,
	function($el) use ($values) {
		return in_array($el['iso'], $values);
	}
);

select 
	posts.*,
	json_objectagg(likers.user_id, likers.lname) lastnames,
	json_objectagg(likers.user_id, likers.avatar) avatars
from posts
join (
  select post_id, user_id, fname, lname, avatar, row_number() over (partition by post_id) rn
  from likes
  join users on users.id = likes.user_id
) likers on likers.post_id = posts.id
where likers.rn < 6
group by posts.id, posts.title, posts.description
;

<?php
$text = "Не следует, однако, забывать о том, что начало [повседневной] работы по [формированию позиции] влечет за собой [процесс внедрения и [модернизации] системы обучения кадров!";
preg_match_all("/\[(\S+)\]/", $text, $matches);
var_dump($matches[1]);

SELECT
    orders.num, orders.createdon, orders.cost, orders.status, 
   GROUP_CONCAT(products.name) prod_names, 
   GROUP_CONCAT(products.count) prod_counts, 
   GROUP_CONCAT(products.cost) prod_costs
FROM `modx_ms2_orders` AS orders
JOIN `modx_ms2_order_products` AS products ON orders.id = products.order_id
WHERE `user_id` = 106
GROUP BY orders.num, orders.createdon, orders.cost, orders.status

const regExp = new RegExp('(uploads\/[^"]+)', 'g') // регулярка
const text = 'Привет мир "uploads/image.jpg"  ijiji " Привет мир "uploads/image.jpg" Привет мир "uploads/image.jpg"  ijiji'

select * from (
  select 
	*,
	date(from_unixtime(created_at)) created_date,
	row_number() over (partition by created_date order by created_at desc) rn
  from tbl) row_numbers where rn = 1

select tbl.* from tbl
join (
    select max(created_at) max_created_at
    from tbl
    group by date(from_unixtime(created_at))
) last_time on last_time.max_created_at = tbl.created_at;

<?php
$string = 'This is my habr';
$pattern = '/(\w+ \w+)$/i';
$replacement = '<a href="habr.com">${1}<a>';
echo preg_replace($pattern, $replacement, $string);

$last_city = ''; // initial empty value
foreach($cities as $city) {
	if ($last_city != '') { // if value not empty show transit option
		echo '<option value="'.$last_city.'-'.$city['name'].'">'.$last_city.'-'.$city['name'].'</option>'. PHP_EOL;
	}
	echo '<option value="'.$city['name'].'">'.$city['name'].'</option>' . PHP_EOL;
	$last_city = $city['name']; // store value for next iteration
}

<?php
header( 'Content-type: text/html; charset=utf-8' );
echo 'Begin ...<br />';
for( $i = 0 ; $i < 10 ; $i++ )
{
    echo $i . '<br />';
    flush();
    ob_flush();
    sleep(1);
}
echo 'End ...<br />';
?>