Hello
In Real estate Manager "amenities" for frontend we prepare:
at file
{yours site}//components/com_realestatemanager/realestatemanager.php
static function showItemREM(
Code: |
$query = "SELECT f.* ";
$query .= "FROM #__rem_feature as f ";
$query .= "LEFT JOIN #__rem_feature_houses as fv ON f.id = fv.fk_featureid ";
$query .= "WHERE f.published = 1 and fv.fk_houseid = $id ";
$query .= "ORDER BY f.categories";
$database->setQuery($query);
$house_feature = $database->loadObjectList();
|
You may change that select
Please before backup this file
Thanks,
Andrew