SELECT
  p.p_name,
  p.id,
  cat.cat_name,
  p.property_type,
  p.p_type,
  p.address,
  c.client_name,
  p.price,
  GROUP_CONCAT(pr.price) AS c_price,
  pd.land_area,
  pd.land_area_rp,
  p.tagline,
  p.map_location,
  r.id,
  p.status,
  co.country_name,
  p.`show`,
  u.name,
  p.created_date,
  p.updated_dt,
  o.type_id,
  p.furnished,
  p.expiry_date
FROM
  property p
  LEFT OUTER JOIN region AS r
    ON p.district_id = r.id
  LEFT OUTER JOIN country AS co
    ON p.country_id = co.country_id
  LEFT OUTER JOIN property_category AS cat
    ON p.cat_id = cat.id
  LEFT OUTER JOIN property_area_details AS pd
    ON p.id = pd.property_id
  LEFT OUTER JOIN sc_clients AS c
    ON p.client_id = c.client_id
  LEFT OUTER JOIN admin AS u
    ON p.adminid = u.id
  LEFT OUTER JOIN sc_property_orientation_type AS o
    ON p.orientation_type = o.type_id
  LEFT OUTER JOIN property_amenities_details AS pad
    ON p.id = pad.property_id
  LEFT OUTER JOIN sc_commercial_property_price AS pr
    ON p.id = pr.property_id
WHERE p.id > 0
  AND (
    p.created_date > DATE_SUB(NOW(), INTERVAL 1 YEAR)
    OR p.updated_dt > DATE_SUB(NOW(), INTERVAL 1 YEAR)
  )
  AND p.p_type = 'sale'

select count(*)
from table

select any(p.p_name) as p_num, any(p.tagline) as tagline, . . .

GROUP BY
  p.p_name,
  p.id,
  cat.cat_name,
  p.property_type,
  p.p_type,
  p.address,
  c.client_name,
  p.price,
  pd.land_area,
  pd.land_area_rp,
  p.tagline,
  p.map_location,
  r.id,
  p.status,
  co.country_name,
  p.`show`,
  u.name,
  p.created_date,
  p.updated_dt,
  o.type_id,
  p.furnished,
  p.expiry_date