SELECT posts.id_post, posts.text_post, posts.photo, posts.created_at,
users.id_user, users.login, users.name, users.surname, users.avatar
COALESCE(COUNT(`likes`.`id_post`), 0) AS `likes`
FROM `posts`
INNER JOIN `users_connections` ON posts.id_user = users_connections.id_followed
INNER JOIN `users` ON users.id_user = posts.id_user
LEFT JOIN `likes` ON `likes`.`id_post` = `posts`.`id_post`
WHERE users_connections.id_follower = :id_follower
AND `created_at` BETWEEN '$prewweek' AND '$nowdate' ORDER BY `created_at`
GROUP BY posts.id_post, posts.text_post, posts.photo, posts.created_at,
users.id_user, users.login, users.name, users.surname, users.avatar
CREATE TABLE book (
id INTEGER PRIMARY KEY,
title VARCHAR(128),
year INTEGER,
author_id INTEGER,
FOREIGN KEY(author_id) REFERENCES author(id)
);
select * from tbl order by random() limit 1;
SELECT * FROM tbl
OFFSET floor(random() * (SELECT COUNT(*) FROM tbl))
LIMIT 1;
SELECT
SUM(`summa`) as full_summa,
SUM(
IF(
DATE_FORMAT(`start_date`, '%Y-%m') = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH), '%Y-%m'),
`summa`,
0
)
) `month_summa`,
AVG(
IF(
DATE_FORMAT(`start_date`, '%Y-%m') = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH), '%Y-%m'),
`summa`,
null
)
) `month_average`
FROM S;
select
box_id, max(name), max(another_name), "product",
sum(coalesce(incoming::numeric, 0)) "incoming",
sum(coalesce(output::numeric, 0)) "output",
sum(coalesce(incoming::numeric, 0)) - sum(coalesce(output::numeric, 0)) "balance"
from table1
group by product, box_id
order by box_id;
SELECT MAX(category_id) FROM stories
WHERE category = ANY(ARRAY['Тест', 'Тест2']);
echo json_encode($result, JSON_NUMERIC_CHECK);
SELECT
`messages`.`id` AS `messages_id`, `money_box`.`id` AS `money_box_id`
FROM `messages`,`money_box`;
select * from users
order by case
when v1 > 0 then v1
when v2 > 0 then v2
else v3
end desc;