xiaomi_soar

最新推荐文章于 2024-03-20 09:37:53 发布

书山有路_邓

最新推荐文章于 2024-03-20 09:37:53 发布

阅读量265

点赞数 1

分类专栏： php

本文链接：https://blog.csdn.net/weixin_41497075/article/details/100164453

版权

php 专栏收录该内容

37 篇文章 0 订阅

订阅专栏

https://github.com/XiaoMi/soar


echo 'select * from film' | ./soar

eg:
echo 'SELECT A.*,if(B.num is null,0,B.num) as fitness_num,`C`.`username` FROM `fa_companies` `A` LEFT JOIN ( SELECT company_id,count(1) as num FROM `fa_fitness` WHERE  `status` = 0 GROUP BY `company_id` ) `B` ON `A`.`id`=`B`.`company_id` LEFT JOIN ( SELECT `id`,`username`,`company_id` FROM `fa_user` WHERE  `fitness_id` = 0  AND `company_id` <> 0 ) `C` ON `A`.`id`=`C`.`company_id` WHERE  ( C.id in ( SELECT `user_id` FROM `fa_admin_user_role_relations` WHERE  `roles_id` = 7 ) ) ORDER BY `A`.`id` DESC' | ./soar

在这里插入图片描述