nozzy

$stmt = pdo()->prepare("INSERT INTO `freeroll` (`name_turnament`, `prize`, `password`, `data`, `time`, `category_id`, `prize_symbol`, `buyin` , `buyin_symbol`, `category_name`, `category_img`, `category_url`) 
SELECT :name_turnament, :prize, :password, .......... и тд, name, img, url FROM category WHERE id = :category_id");

$stmt->execute([
    'name_turnament' => $_POST['name_turnament'],
    'prize' => $_POST['prize'],
    'password' => $_POST['password'],
    'data' => $_POST['data'],
    'time' => $_POST['time'],
    'prize_symbol' => $_POST['symbol'],
    'buyin' => $_POST['buyin'],
    'buyin_symbol' => $_POST['buyin_symbol'],
    'category_id' => $category_id
	]);

$query = ("
        INSERT INTO `order_archive`(`id`, `user_id`, `articul_id`, `barcode`, `quantity`, `supply_id`) VALUES ($supply_id)
        SELECT `id`, `user_id`, `articul_id`, `barcode`, `quantity`, " . $supply_id . " as supply_id FROM `order` WHERE `id` IN ($ids);
        DELETE FROM `order` WHERE `id` IN ($ids)");

select 
tag,
count(*)
from table
group by tag;

select
t1.*,
t2.*,
t3.*
from mainTable t1
inner join mainTable_table1 t2 on t2.id_mainTable = t1.id_mainTable 
inner join table1 t3 on t3.id_table1 = t2.id_table1

SELECT 
t1.*,
t2.ban_type,
t2.w_site
FROM `betaintranet`.`ad_stat_cleaned` t1 
LEFT JOIN `ad_c` t2 ON t1.bid = t2.bid WHERE t1.`date` = '2020-09-09'

UPDATE 
`modx_site_content` t1
SET t1.`longtitle` = REPLACE(`longtitle`, ' ? ', 
(
select t2.*
from 
(
  select 'a'
  union
  select 'b'
  union
  select 'c'
) t2
order by rand() limit 1
)
);

select
stars_id,
sum(val)
from my_table
group by stars_id