Как убрать товары с пустой ценой (Вас, возможно, заинтересуют следующие товары) - [VM1] Общие вопросы и ошибки

// This shows randomly selected products from the products table
// if you don't like to set up related products for each product
$q = "SELECT product_sku FROM #__{vm}_product ";
$q .= "WHERE product_publish='Y' AND product_id != $product_id ";
$q .= "ORDER BY RAND() LIMIT 0, 4";
$db->query( $q );

// This shows randomly selected products from the products table
// if you don't like to set up related products for each product
$q = "SELECT product_sku FROM #__{vm}_product ";
$q .= "WHERE product_publish='Y' AND product_id != $product_id ";
$q .= " AND product_price > 0";
$q .= "ORDER BY RAND() LIMIT 0, 4";
$db->query( $q );

SELECT t1.product_sku FROM #__{vm}_product AS t1, #__{vm}_product_price AS t2
WHERE t1.product_publish='Y' AND t1.product_id != $product_id 
AND t2.product_price > 0
ORDER BY RAND() LIMIT 0, 4

$q  = "SELECT DISTINCT product_sku FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category, #__{vm}_product_price WHERE ";
$q .= "product_parent_id=''";
$q .= "AND #__{vm}_product.product_id=#__{vm}_product_category_xref.product_id ";
$q .= "AND #__{vm}_category.category_id=#__{vm}_product_category_xref.category_id ";
$q .= "AND #__{vm}_product_price.product_id=#__{vm}_product.product_id ";
$q .= "AND #__{vm}_product_price.shopper_group_id=5 ";
$q .= "AND #__{vm}_product_price.product_price > 0 ";
$q .= "ORDER BY RAND() LIMIT 0, 4";