Slava Rozhnev

$asr_res = "первое";

if (preg_match('/(первое|первае|первуе)/', $asr_res)) {
    $ress = 1;
}

SELECT
    `t1`.*,
    GROUP_CONCAT(`t3`.`name` SEPARATOR ', ') AS `role_group`
FROM
    `user` AS `t1`
JOIN `user_role` AS `t2`
ON
    `t1`.`id` = `t2`.`user_id`
JOIN `access_group` AS `t3`
ON
    `t2`.`group_id` = `t3`.`id`
GROUP BY
    `t1`.`id`
HAVING SUM(`group_id` IN('20', '24'))  = 2
LIMIT 0, 20

INSERT INTO bookstorev2.book_store (BOOK_ID, STORE_ID, PRICE, QUANTITY)
    SELECT 
        book.ID, 
        1,  -- default STORE_ID
        book.price, 
        book.quantity 
    FROM bookstore.book;

SELECT
	book.NAME, 
	SUM(IF(store.CITY = 'Moscow', QUANTITY, 0)) AS CITY1_QUANTITY,
	SUM(IF(store.CITY = 'London', QUANTITY, 0)) AS CITY2_QUANTITY,
	SUM(IF(store.CITY = 'Moscow', QUANTITY, 0)- IF(store.CITY = 'London', QUANTITY, 0)) AS DIFF_QUANTITY
FROM book
LEFT JOIN book_store ON book_store.BOOK_ID = book.ID
JOIN store ON store.ID = book_store.STORE_ID
WHERE store.CITY IN ('Moscow', 'London')
GROUP BY book.NAME;

$get_product = $db->prepare("SELECT * FROM products");
$get_product->execute();

// объявление массива
$product_data_array = [];

while ($product_data = $get_product->fetch()) {
    // добавляем массив как елемент 2-мерного массива
    $product_data_array[] = [
        "name" => $product_data["name"],
        "price" => $product_data["price"],
        "status" => $product_data["status"],
    ];
}

var_dump($product_data_array);

$get_product = $db->prepare("SELECT * FROM products");
$get_product->execute();

$product_data_array = $get_product->fetchAll(PDO::FETCH_ASSOC);

var_dump($product_data_array);

<?php
$date = new DateTime();
$date->setTimestamp(1644537600000/1000);
echo $date->format('Y-m-d') . "\n";

UPDATE first_table
JOIN second_table ON first_table.id = second_table.id
SET first_table.count = first_table.count + second_table.total_count,  second_table.total_count = 0
WHERE second_table.id = 1;

SELECT 
    `table1`.`model`, 
    `table1`.`quantity`, 
    SUM(table2.sale_quantity)
FROM `table1`
JOIN  `table2` ON `table1`.`model`=`table2`.`model`
WHERE 
    `table1`.`manufacturer_id` = 'apple'
    AND `table1`.`quantity` < 20
GROUP BY `table1`.`model`,  `table1`.`quantity`;

create table datavalues (
	id serial primary key,
  	value text -- json or any suitable type
);

create table manydata (
	id bigserial primary key,
  	value_id int,
  	inserted_at timestamp with time zone default current_timestamp,
  	updated_at timestamp,
    foreign key (value_id) references datavalues(id)
);
create index on manydata(value_id);

-- group by s.ID,t.TIME,s.NAME,t.M8_SUM ,t.TRAFF_SUM,t.PMAC_SUM
GROUP BY s.ID, t.TIME, s.NAME

let source = [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20];
let chank_size = 4;
let result = [];

while (source.length > 0) {
		result.push(source.splice(0, chank_size));
		chank_size = chank_size == 4 ? 6 : 4;
}

console.log(result);

SELECT 
  `users`.`name`,
  COUNT(`orders`.`id`) as counts,
  COALESCE(SUM(`orders`.`amount`), 0) as sums
FROM
  `users`
LEFT JOIN `orders` ON 
  `users`.`id` = `orders`.`user_id` AND 
  `orders`.`date` BETWEEN '2021-03-29' AND '2021-03-30'  
GROUP BY
  `users`.`id`, `users`.`name`;

SELECT `user_id` 
FROM `users` 
WHERE status = 'admin' 
ORDER BY `connected_users` ASC 
LIMIT 1;