SELECT Images.Path_img, Product.Name, Description.Small_desc, Product.Name
FROM `Images`
JOIN `Product`
JOIN `Description`
JOIN `Popular_product` ON Popular_product.ID_regularProduct = Product.ID;
SELECT `d`.`generation_id`, `d`.`Name`, `d`.`volume`, `d`.`capacity`,
`d`.`type_of_connector`, COUNT(DISTINCT `c`.`color_id`) AS `color_count`
FROM `device` AS `d`
JOIN `device2color_body` AS `c` ON `c`.`device_id` = `d`.`id`
GROUP BY `d`.`generation_id`, `d`.`Name`, `d`.`volume`, `d`.`capacity`,
`d`.`type_of_connector`
SELECT `generation_id`, `Name`, COUNT(*) AS `count`
FROM (
SELECT DISTINCT `d`.`generation_id`, `d`.`Name`, `d`.`volume`, `d`.`capacity`,
`d`.`type_of_connector`, `c`.`color_id`
FROM `device` AS `d`
JOIN `device2color_body` AS `c` ON `c`.`device_id` = `d`.`id`
) AS `t`
GROUP BY `generation_id`, `Name`
WITH `cte` (`id`) AS (
SELECT `ID`
FROM `Orders`
ORDER BY `ID` DESC
LIMIT 3
)
SELECT DISTINCT `op`.`Code`
FROM `cte`
JOIN `OrdersProducts` AS `op`
ON `op`.`OrderID` = `cte`.`id`
SELECT DISTINCT `op`.`Code`
FROM (
SELECT `ID`
FROM `Orders`
ORDER BY `ID` DESC
LIMIT 3
) AS `o`
JOIN `OrdersProducts` AS `op`
ON `op`.`OrderID` = `o`.`id`
SELECT DISTINCT `Code`
FROM `OrdersProducts`
WHERE `OrderID` IN (
SELECT `ID`
FROM `Orders`
ORDER BY `ID` DESC
LIMIT 3
)
SELECT DISTINCT FIRST_VALUE(`id`) OVER `win` AS `id`, `user_id`,
FIRST_VALUE(`score`) OVER `win` AS `score`,
FIRST_VALUE(`user_name`) OVER `win` AS `user_name`
FROM `game_api_score`
WINDOW `win` AS (PARTITION BY `user_id` ORDER BY `score` DESC)
не понятно, какой влияние оказывает третья таблица на вторуюНапрямую никакого. У вас INNER JOIN `wp_company_rates` и `wp_term_relationships`, поэтому естественно, что в финальную выборку попадут только те строки, которые совмещаются по условию JOIN'a. Если после RIGHT JOIN вы получили в объединённой строке `wp_company_rates`.`post_id` равное NULL, то, естественно, в INNER JOIN эта строка не войдёт.
x OR y OR z AND q
будет выполняться как x OR y OR (z AND q)
, так как приоритет у AND выше, чем у OR.SELECT `time`, `ticker`, `price`, `volume`,
`icon`, `tf`, `figure`, `figure_text`
FROM `figure`
WHERE `figure` IN ('vklin', 'nklin', 'doublev', 'doubled', 'mflag', 'bflag', 'flag')
AND `tf` IN ('1h', '4h', '1d')
UNION SELECT `time`, `ticker`, `price`, `volume`,
`icon`, `tf`, `situation`, `situation_text`
FROM `levels`
WHERE `situation` = 'resistance'
AND `tf` IN ('1h', '4h', '1d')