获取PHP查询结果,php – 在一个查询中通过计数和运算符获取结果

*****解*****

SELECT

*

FROM

people_details as t1

inner join

people_branches as t2

on t1.id = t2.id

inner join

(

SELECT

count(t1.id) as worker_counter,t1.branch_id

FROM

people_branches as t1

inner join people_details as t2

on t1.id = t2.id

WHERE

t2.job_types LIKE '%C%'

group by branch_id

) as t3

on t2.branch_id = t3.branch_id

inner join people_frontpage as t4

on t4.id = t1.id

inner join business as t5

on t5.id = t2.branch_id

WHERE

t1.job_types LIKE '%C%'

AND t3.worker_counter > 200

———-

旧 – 更新

>

>

>

>

SELECT

t3.bus_name, t1.name, t1.job_types

FROM

SO_WORKER as t1

inner join

SO_RELATIONSHIP as t2

on t1.id = t2.w_id

inner join

(

SELECT

count(t1.w_id) as worker_counter,t1.b_id,t3.bus_name

FROM

SO_RELATIONSHIP as t1

inner join SO_WORKER as t2

on t1.w_id = t2.id

inner join SO_BUSINESS as t3

on t3.id = t1.b_id

WHERE

t2.job_types LIKE '%C%'

group by b_id

) as t3

on t2.b_id = t3.b_id

WHERE t1.job_types LIKE '%C%'

AND t3.worker_counter <= 3

未格式化

SELECT t3.bus_name, t1.name, t1.job_types FROM SO_WORKER as t1 inner join SO_RELATIONSHIP as t2 on t1.id = t2.w_id inner join (SELECT count(t1.w_id) as worker_counter,t1.b_id,t3.bus_name FROM SO_RELATIONSHIP as t1 inner join SO_WORKER as t2 on t1.w_id = t2.id inner join SO_BUSINESS as t3 on t3.id = t1.b_id WHERE t2.job_types LIKE '%C%' group by b_id) as t3 on t2.b_id = t3.b_id WHERE t1.job_types LIKE '%C%' AND t3.worker_counter <= 3

————————————————–

旧代码

与帖子1的评论有关.

Table: SO_BUSINESS

id | bus_name

--------------------

1 | BUSI A

2 | BUSI B

Table: SO_WORKER

id | job_types

---------------------

1 | CEO

2 | GFO

3 | CTO

4 | Manager

5 | Worker

Table: SO_RELATIONSHIP

w_id | b_id

----------------

1 | 1

2 | 2

3 | 1

4 | 1

5 | 2

Query: Output

workers_count | b_id | bus_name

--------------------------------------------

2 | 1 | BUSI A

.

SELECT *

FROM

(

SELECT

count(t1.w_id) as workers_count,

t1.b_id,

t3.bus_name

FROM

SO_RELATIONSHIP as t1

inner join

SO_WORKER as t2 on t1.w_id = t2.id

inner join

SO_BUSINESS as t3 on t1.b_id = t3.id

WHERE

t2.job_types LIKE '%C%'

GROUP BY t1.b_id

) as t4

WHERE

t4.workers_count < 3

代码未格式化：

SELECT * FROM (SELECT count(t1.w_id) as workers_count,t1.b_id,t3.bus_name FROM SO_RELATIONSHIP as t1 inner join SO_WORKER as t2 on t1.w_id = t2.id inner join SO_BUSINESS as t3 on t1.b_id = t3.id WHERE t2.job_types LIKE '%C%' GROUP BY t1.b_id) as t4 WHERE t4.workers_count < 3

如果这有助于你,请告诉我