SELECT TYPE as Type1 , type_id, (SELECT count( property_type ) FROM pt_property p WHERE p.property_type = pt.type_id AND price >0 AND p.status =0 AND property_location='87' and shop_id='2' ) AS Total_Number FROM pt_property_type pt WHERE shop_id='2' GROUP BY type_id

select bedrooms,count(bedrooms) as Total_Number from pt_property where property_location ='87' and shop_id='2' AND price >0 AND status =0 group by bedrooms order by bedrooms

SELECT pr . * , (SELECT count( property_id ) FROM pt_property p WHERE p.price >pr.price_from AND p.price <= pr.price_to and property_location ='87' and shop_id='2' AND STATUS =0 ) AS Total_Number FROM price_range pr

Property Price Range

Reference: KARS1287APT

Reference: KAR1004AP

Reference: KARS1288APT

Reference: KARS1289APT

Reference: KAR1320VL

Reference: KAR1003BUN

Reference: KAR1058VL

Reference: KAR1329VL

Reference: KAR1060BUN

Reference: KAR1343VL