SELECT DISTINCT a.*, cs.title as property_status_name, concat(c2.title, "/", c.title) as property_category_name, cl.title as property_classification_name, as property_city_name, as property_province_name , AS uEditor FROM `#__pm_properties` AS a LEFT JOIN #__users AS uc ON LEFT JOIN #__users AS created_by ON = a.createdby LEFT JOIN #__users AS modified_by ON = a.modifiedby LEFT JOIN #__categories c on = a.property_category LEFT JOIN #__categories cs on = a.property_status LEFT JOIN #__categories c2 on = c.parent_id LEFT JOIN #__categories cl on = a.property_classification LEFT JOIN #__pm_cities ct on = a.property_city LEFT JOIN #__pm_provinces pt on = a.property_province WHERE a.property_island_group = 2 AND (a.property_category = 25 OR a.property_category = 28) AND a.property_featured != 1 AND a.published = 1 ORDER BY ASCArray ( )
Property Name
Floor Area
No warehouses available on this area.