Сортировка дочерних позиций - [VM1] Управление товарами, атрибутами, типами, ценами

// Get list of children
$pp = $ps_product->parent_has_children( $product_id ) ;
		if( $pp ) {
			$q = "SELECT product_id,product_name,product_parent_id,product_sku,product_in_stock,product_full_image,product_thumb_image FROM #__{vm}_product WHERE product_publish='Y' AND product_parent_id='$product_id' ORDER BY CAST('product_name' AS signed) ASC" ;
		} else {
			$q = "SELECT product_id,product_name,product_parent_id,product_sku,product_in_stock,product_full_image,product_thumb_image FROM #__{vm}_product WHERE product_publish='Y' AND product_id='$product_id' ORDER BY CAST('product_name' AS signed) ASC" ;
		}