尝试使用子请求…
你的申请 ：
SELECT
dishes.title,
dishes.name,
dishes.id,
countries.locale,
countries_count.dishes_nb
FROM countries
JOIN companies ON companies.`country_id` = countries.`id`
JOIN company_dish ON company_dish.`company_id` = companies.`id`
JOIN dishes ON company_dish.`dish_id` = dishes.`id`
JOIN
({SubRequest}) countries_count ON countries_count.`country_id` = countries.`id`
ORDER BY
countries_count.dishes_nb DESC
和子请求,按国家统计菜肴：
SELECT
countries.id AS country_id,
COUNT(company_dish.dish_id) AS country_dishes_nb
FROM countries
JOIN companies ON companies.country_id = countries.id
JOIN company_dish ON company_dish.company_id = companies.id
GROUP BY
country_id
或按国家/地区计算每道菜：
你的申请 ：
SELECT
dishes.title,
dishes.name,
dishes.id,
countries.locale,
countries_count.dishes_nb
FROM countries
JOIN companies ON companies.`country_id` = countries.`id`
JOIN company_dish ON company_dish.`company_id` = companies.`id`
JOIN dishes ON company_dish.`dish_id` = dishes.`id`
JOIN
({SubRequest}) countries_count ON countries_count.`country_id` = countries.`id`
AND countries_count.`dish_id` = dishes.`id`
ORDER BY
countries_count.dishes_nb DESC
和子请求：
SELECT
countries.id AS country_id,
dishes.id AS dish_id,
COUNT(company_dish.dish_id) AS country_dishes_nb
FROM countries
JOIN companies ON companies.country_id = countries.id
JOIN company_dish ON company_dish.company_id = companies.id
JOIN dishes ON company_dish.dish_id = dishes.id) AS countries_count ON countries_count.country_id` = countries.`id`
GROUP BY
country_id, dish_id
并在{SubRequest}中连接(替换)
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
