galaxy

$stmt = $pdo->prepare("TRUNCATE TABLE `rests`");
$stmt->execute();
$stmt = $pdo->prepare("
INSERT INTO
`cg_rests`(
`Name`,

user_id которых будет равен user_id или friend_id, в свою очередь user_id или friend_id должны соответствовать например '1'.

SELECT id FROM posts
 WHERE user_id IN (
    SELECT '1'
     UNION
    SELECT user_id FROM friends WHERE friend_id = '1'
     UNION
    SELECT friend_id FROM friends WHERE user_id = '1'
)
ORDER BY id DESC LIMIT 0, 10

PARTITION BY RANGE COLUMNS(datetime) (
    PARTITION 2019_01 VALUES LESS THAN ('2019-02-01'),
    PARTITION 2019_02 VALUES LESS THAN ('2019-03-01'),
    ...
);

DATE_FORMAT(CURRENT_DATE - INTERVAL 11 MONTH, '%Y-%m-01' AND `category_id` = '1')

AND `category_id` = '2' AND `category_id` = '3'

SELECT
SUM(`price`) as `sales`,
SUM(`seller_salary`) as `salary`,
COUNT(CASE WHEN `category_id` = '1' THEN 1 END) as cat1_count,
COUNT(CASE WHEN `category_id` = '2' OR `category_id` = '3'  THEN 1 END) as cat23_count,
DATE_FORMAT(`putdate`, '%Y-%m') as period
FROM `ms_sales`
WHERE `putdate` >= DATE_FORMAT(CURRENT_DATE - INTERVAL 11 MONTH, '%Y-%m-01')
GROUP BY period