Сортировка атрибутов в админке и на сайте - Управление атрибутами, характеристиками и т.п.

                $query = "select PA.* from `#__jshopping_products_attr` as PA where PA.product_id = '".$this->_db->getEscaped($this->product_id)."' ".$where." ORDER BY `price`"; 

$query = "SELECT distinct PA.$field as val_id, V.`".$lang->get("name")."` as value_name, V.image
                      FROM `#__jshopping_products_attr` as PA INNER JOIN #__jshopping_attr_values as V ON PA.$field=V.value_id
                      WHERE PA.product_id = '".$this->product_id."' ".$where."
                      ORDER BY V.value_ordering";

$query = "SELECT distinct PA.$field as val_id, V.`".$lang->get("name")."` as value_name, V.image
                      FROM `#__jshopping_products_attr` as PA INNER JOIN #__jshopping_attr_values as V ON PA.$field=V.value_id
                      WHERE PA.product_id = '".$this->product_id."' ".$where."
                      ORDER BY PA.price"; // Сортировка по минимальной цене в атрибутах