nozzy

select
t1.*
t2.name,
t2.surname
from reviews t1
left join users t2 on t2.id = t1.user_id

select
t1.*,
t2.username,
t3.username  
from orders t1
left join users t2 on t2.userid = t1.userid
left join users t3 on t3.userid = t1.fromuserid

select
t1.name_goods,
t2.name_subcat,
t3.name_cat
from goods t1
left join subcategory t2 on t2.id_subcat = t1.id_subcat
left join category t3 on t3.id_cat = t1.id_cat

select 
iduser,
sum(reward)
from ochk 
where EXTRACT(YEAR_MONTH FROM dateadd) = EXTRACT(YEAR_MONTH FROM CURRENT_DATE()) 
group dy iduser;

$mes = 1;
$output = exec("kode.py $mes");
echo $output;

INSERT INTO `product_comments` (`product_slug`, `product_id`, `user_id`, `created_at`, `updated_at`, `content`) VALUES ('крем-для-рук-и-ногтей',1,2,'2019-04-08 13:25:31.000000','2019-04-08 13:25:31.000000','Крем вообще супер.')

select * from table where date is null
union
select * from table where date = '20190101'

SELECT
    user_id,  
    SUM(CASE WHEN (message='Купил Lada') THEN 1 ELSE 0 END) AS Lada,
    SUM(CASE WHEN (message='Купил Volvo') THEN 1 ELSE 0 END) AS Volvo,
    SUM(CASE WHEN (message='Купил Kia') THEN 1 ELSE 0 END) AS Kia
FROM 
    your_table
GROUP BY 
    user_id