Исключить неопубликованные товары из выгрузки YML JoomShopping - JoomShopping

if ($products = mysqli_query($mysqli, 'SELECT a.product_id, a.`name_ru-RU`, a.product_price,  a.`description_ru-RU`, a.image, a.`alias_ru-RU`, b.category_id, c.category_parent_id, c.`short_description_ru-RU` FROM jf1yo_jshopping_products as a, jf1yo_jshopping_products_to_categories as b, jf1yo_jshopping_categories as c  WHERE b.product_id = a.product_id AND c.category_id = b.category_id')) {
    $xml .= "<offers>\n";

    while( $row = mysqli_fetch_assoc($products) ){
        // $url = SEFLink("index.php?option=com_jshopping&controller=product&task=view&category_id=".$row['category_id']."&product_id=".$row['product_id'], 1);
        if ($row[product_price] > 0){
        $xml .= "<offer id=\"".$row['product_id']."\" available=\"true\">\n";
        setlocale(LC_MONETARY, 'en_US');
        $price = money_format('%i', $row['product_price']);
        $xml .= "<price>".$price."</price>\n";
        $xml .= "<currencyId>RUR</currencyId>\n";
        $xml .= "<categoryId>".$row['category_id']."</categoryId>\n";
        $xml .= "<name>".$row['name_ru-RU']."</name>\n";    
        $xml .= "<description> \n <![CDATA[".$row['description_ru-RU']."\n ]]> \n </description>\n";
        $xml .= "<picture>http://dmk.su/components/com_jshopping/files/img_products/".$row['image']."</picture>\n";
            if ($row['short_description_ru-RU'] != "")
                if ($row['alias_ru-RU'] != "")
                $xml .= "<url>".$row['short_description_ru-RU'].'/'.$row['alias_ru-RU']."</url>\n";
                else
                $xml .= "<url>".$row['short_description_ru-RU'].'/product/view/'.$row['category_id'].'/'.$row['product_id']."</url>\n";
            else {
                $parentdisc = mysqli_query($mysqli, 'SELECT `short_description_ru-RU` FROM jf1yo_jshopping_categories WHERE category_id = '.$row["category_parent_id"]);
                $discrow = mysqli_fetch_assoc($parentdisc);
                $parental = mysqli_query($mysqli, 'SELECT `alias_ru-RU` FROM jf1yo_jshopping_categories WHERE category_id = '.$row["category_id"]);
                $aliasrow = mysqli_fetch_assoc($aliasrow);
                // $xml .= "<test>".var_dump('SELECT `short_description_ru-RU` FROM jf1yo_jshopping_categories WHERE category_id = '.$row["category_parent_id"])."----".var_dump($discrow)."</test>\n\n\n\n";
                if ($row['alias_ru-RU'] != "")
                $xml .= "<url>".$discrow['short_description_ru-RU'].'/'.$aliasrow['alias_ru-RU'].'/'.$row['alias_ru-RU']."</url>\n";
                else
                 $xml .= "<url>".$discrow['short_description_ru-RU'].'/'.$aliasrow['alias_ru-RU'].'/'.$row['product_id']."</url>\n";   
               
            }
        $xml .= "</offer>\n";
        }
    }
    $xml .= "</offers>\n"; 

    mysqli_free_result($products); 
}

mysqli_close($mysqli);

$xml .= "</shop>\n</yml_catalog>";

echo $xml;