Ninja Mate

let a='man'
()=>{
    let b='hi'
    console.log(b)//hi 
    console.log(a)//man
}
    console.log(b)//Uncaught ReferenceError: b is not defined

jpg JPG

array_push($normal_array,  [
                "src"=> "$plugins_url" . "/sinco_mate/admin/partials/images/" . strtolower( $value),
                'position' => $i
            ] );
            $i++;

jpg JPG

select
  l.loc, 
  sum(coalesce(ps.cnt, 0) + coalesce(e.cnt, 0)) AS ser, 
  count(distinct l.patient) AS patient 
from
(
  select ps_user_loc as loc, ps_ur as patient from patient_services 
  union
  select eng_user_loc as loc, eng_ur as patient  from engagements where length(eng_ur) > 0
) l
left outer join
(
  select
    ps_user_loc as loc, 
    ps_ur as patient,
    count(*) as cnt
  from patient_services
  group by ps_user_loc, ps_ur
) ps on ps.loc = l.loc and ps.patient = l.patient
left outer join
(
  select
    eng_user_loc as loc, 
    eng_ur as patient,
    count(*) as cnt
  from engagements
  where length(eng_ur) > 0
  group by eng_user_loc, eng_ur
) e on e.loc = l.loc and e.patient = l.patient
group by l.loc

SELECT 
SUM( CASE WHEN patient_gender = 'Male' THEN 1*xxx.Value ELSE 0 END ) Male, 
SUM( CASE WHEN patient_gender = 'Female' THEN 1*xxx.Value ELSE 0 END ) Female 
FROM patients JOIN (
SELECT ps_ur AS UR, COUNT(ps_ur) AS Value 
FROM patient_services 
GROUP BY UR 
UNION ALL
SELECT eng_ur AS UR, COUNT(eng_ur) AS Value  
FROM engagements 
WHERE LENGTH( eng_ur )>0  
GROUP BY UR ) xxx ON  patients.patient_ur = xxx.UR