select
req_id, req_text,
recipient.name as recipient_name,
sender.name as sender_name
from request
join users as recipient on request.recipient_id = recipient.id
join users as sender on request.sender_id = sender.id;
Create table course (
id serial primary key,
name text
);
Create table programm (
id serial primary key,
name text
);
Create table course_programms (
cource_id int references course(id),
progamm_id int references programm(id),
programm_order int,
primary key (cource_id, progamm_id)
);
CREATE TABLE User (
id INTEGER NOT NULL AUTO_INCREMENT,
login VARCHAR(255) NOT NULL,
password VARCHAR(255) NOT NULL,
status INTEGER NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE Message (
id INTEGER NOT NULL AUTO_INCREMENT,
userid INTEGER NOT NULL,
message VARCHAR(255) NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (userid) REFERENCES User(id)
);
SELECT order_number, order_status, order_date
FROM (
SELECT order_number, order_status, order_date,
RANK() OVER(PARTITION BY order_number ORDER BY order_date DESC) AS r
FROM orders
) t
WHERE r = 1
select
p.name,
group_concat(case when a.name = 'color' then pa.val end) colors
from products p
join products_attributes pa on p.id = pa.product_id
join attributes a on a.id = pa.attribute_id
group by p.id, p.name;
select d, STR_TO_DATE(d,'%d/%m/%Y в %H:%i')
from t
order by STR_TO_DATE(d,'%d/%m/%Y в %H:%i');
curl -fsSL https://deb.nodesource.com/setup_19.x | bash - &&\
apt-get install -y nodejs
Argument #2 ($array) must be of type ?array, string given in
Аргумент #2 ($array) должен иметь тип ?array, строка указана в
echo implode(',', array_column($arr['domains'], 'fqdn'));
<?php
$html =" <span>
123 </span>";
echo json_encode(["content"=>$html]);
$html =" <span>
123 </span>";
echo '{"content":'.json_encode ($html) .'}';
usort($arr, fn($a, $b)=>$b['STATUS_WORK_DAY']<=>$a['STATUS_WORK_DAY']);