У меня есть запрос MySQL, как показано ниже:
$sql = SELECT p.property_id
, location
, title
, p.description
, round(price,0) as price
, featured
, c.name as property_category
, t.name as property_type
, image_path
, image
FROM property p
INNER JOIN...