Contar un valor con una doble coincidencia

[mikexloo]

This does it Thank you
table1 = t1 , table2=t2, table3=t3 , t11 = table1 rejoined
"SELECT t1.id
, t1.parent_id
, t1.srt_order
, t2.desc,t2.other,
, COUNT(t3.id) AS Count
FROM t1
INNER JOIN t1 AS t11 ON t11.parent_id = t1.id
INNER JOIN t2 ON t2.id = t1.id
LEFT OUTER JOIN t3 ON t3.service = t11.id
GROUP BY
t1.id
, t1.parent_id
, t1.srt_order
, t2.desc"