前置子查询如何优化成join
SELECT
IfNull( f.JOIN, 0 ) AS `join`,
IfNull( t.people_num, 0 ) AS need,
IfNull( f.found_id, 0 ) AS found_id,
t.team_id as team_id,
t.user_notpz_reward AS rebate_money,
t.del,
g.id,
g.NAME,
g.image,
g.min_price AS price,
g.market_price,
(select tg.team_price from ls_team_goods_item tg where g.id = tg.item_id and t.team_id = tg.team_id) jiage
FROM
`ls_goods` `g`
LEFT JOIN `ls_team_activity` `t` ON `g`.`id` = `t`.`goods_id`
LEFT JOIN ( SELECT id AS found_id, need, team_id, max( `join` ) AS `join` FROM ls_team_found WHERE STATUS = 0 GROUP BY team_id ) f ON `f`.`team_id` = t.team_id
WHERE
`g`.`del` = 0
AND `g`.`status` = 1
AND `g`.`is_best` = 1
AND `g`.`is_team` = 1
AND t.del = 0
and t.status = 1
ORDER BY
`g`.`sort` DESC,
`g`.`id` DESC
LIMIT 0,
15
(select tg.team_price from ls_team_goods_item tg where g.id = tg.item_id ,商品表id=规格id and t.team_id = tg.team_id) jiage ,这个是查询实际拼团的价格,根据商品表id查出的。g.id = tg.item_id ,商品表id=规格id
怎么把这个优化,变成join形式。
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
![扫码二维码加入Web技术交流群](/public/img/jiaqun_03.jpg)
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
你直接直接使用expain分析sql
SELECT
FROM
WHERE
ORDER BY