mohon di bantu, sql saya saat dirun tidak ada error namun valuen nya tidak muncul. mohon di bantu ya

SELECT id, nama, alamat, latitude, longitude,
Round((6371000 * acos(cos(radians(-7.9387161)) 
* cos(radians(latitude)) * cos(radians(longitude) 
- radians(112.6303986)) + sin(radians(-7.9387161)) 
* sin(radians(latitude)))),2) AS jarak, COUNT(status) as sub
FROM lokasifat
LEFT JOIN tb_data1 on tb_data1.id_tiang=lokasifat.alamat
WHERE tb_data1.status like 'OPEN'
HAVING jarak <=200
ORDER BY jarak

table lokasifat : id, nama, alamat, latitude, longitude
table tb_data1: no, id_tiang, id_fat, port, status
korelasinya di alamat=id_tiang

sebelumnya sql nya 

SELECT id, nama, alamat, latitude, longitude,
Round((6371000 * acos(cos(radians(-7.9387161)) 
* cos(radians(latitude)) * cos(radians(longitude) 
- radians(112.6303986)) + sin(radians(-7.9387161)) 
* sin(radians(latitude)))),2) AS jarak
FROM lokasifat
HAVING jarak <=200
ORDER BY jarak

  vailue nya sperti ini, left joint untuk menambah colom sub di kiri dengan value count (tb_data1.status) where status like "open"    
mohon di bantu suhu suhu disini

terimakasih