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