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 = 2 AND (a.property_category = 25 OR a.property_category = 28) AND a.property_featured != 1 AND a.published = 1 ORDER BY a.id ASCArray ( )